Turn bug reports in a sheet into GitHub issues

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

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

REPO, SHEET_ID = "acme/app", "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="Bug reports!A2:E").execute().get("values", [])
    todo = [(i, r) for i, r in enumerate(rows, start=2) if len(r) >= 3 and (len(r) < 5 or not r[4])]
    report_fetched(len(todo))
    if not todo:
        return {"created": 0}
    for i, r in todo:
        when, reporter, report = r[0], r[1], r[2]
        title = report.splitlines()[0][:100]
        try:
            title = ai.generate(report[:3000], system="Write a short, specific GitHub issue title for this bug report.", max_output_tokens=30).text.strip()
        except (ai.AINotIncluded, ai.AILimitReached):
            pass
        issue = gh("POST", f"/repos/{REPO}/issues", json={"title": title, "labels": ["bug", "from-sheet"],
                   "body": f"Reported by {reporter} on {when}\n\n{report}"})
        values.update(spreadsheetId=SHEET_ID, range=f"Bug reports!E{i}", valueInputOption="RAW", body={"values": [[issue["html_url"]]]}).execute()
    return {"created": len(todo)}