Log daily engineering activity to a sheet

from datetime import date, timedelta
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, notify, ai

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)

ORG, SHEET_ID = "acme", "your-spreadsheet-id"

@on_trigger
def run(event):
    day = date.today() - timedelta(days=1)
    merged = gh("GET", "/search/issues", params={"q": f"org:{ORG} is:pr is:merged merged:{day}", "per_page": 100})["items"]
    closed = gh("GET", "/search/issues", params={"q": f"org:{ORG} is:issue is:closed closed:{day}", "per_page": 100})["items"]
    rows = [[str(day), kind, i["repository_url"].split("/")[-1], i["title"], i["user"]["login"], i["html_url"]]
            for kind, items in (("PR", merged), ("Issue", closed)) for i in items]
    if not rows:
        return {"rows": 0}
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    sheets.spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Activity!A:F", valueInputOption="USER_ENTERED", body={"values": rows}).execute()
    summary = ai.generate("\n".join(f"{r[1]} {r[2]}: {r[3]}" for r in rows)[:8000], max_output_tokens=200,
                          system="Summarise this day of engineering work in 3 plain sentences for a manager.").text
    notify.email_me(f"Engineering activity {day:%a %d %b}: {len(merged)} merged, {len(closed)} closed", summary)
    return {"rows": len(rows)}