Turn sheet rows into Jira tickets

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, notify, report_fetched

JIRA, SITE = "https://api.atlassian.com/ex/jira/your-cloud-id", "https://acme.atlassian.net/browse/"
adf = lambda text: {"type": "doc", "version": 1, "content": [{"type": "paragraph", "content": [{"type": "text", "text": text}]}]}

def jira(method, path, **kw):
    resp = http.request(method, JIRA + path, headers={"Authorization": f"Bearer {credentials.connection('jira', 'work')}", "Accept": "application/json"}, **kw)
    return resp.raise_for_status() or (resp.json() if resp.content else None)

SHEET_ID = "your-spreadsheet-id"

@on_trigger
def run(event):
    values = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values()
    rows = values.get(spreadsheetId=SHEET_ID, range="Requests!A2:D").execute().get("values", [])
    todo = [(i, r + [""] * (4 - len(r))) for i, r in enumerate(rows, start=2) if r and r[0] and (len(r) < 4 or not r[3])]
    report_fetched(len(todo))
    if not todo:
        return {"created": 0}
    created = []
    for i, (summary, description, priority, _) in todo:
        key = jira("POST", "/rest/api/3/issue", json={"fields": {"project": {"key": "OPS"}, "issuetype": {"name": "Task"}, "summary": summary[:250],
                   "priority": {"name": priority or "Medium"}, "description": adf(description or summary)}})["key"]
        values.update(spreadsheetId=SHEET_ID, range=f"Requests!D{i}", valueInputOption="RAW", body={"values": [[key]]}).execute()
        created.append(f"{key} {summary}")
    notify.email_me(f"{len(created)} requests sent to Jira", "\n".join(created))
    return {"created": len(created)}