Fill a timesheet sheet from your GitHub activity

from collections import defaultdict
from datetime import date, timedelta
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, 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)

AUTHOR, SHEET_ID = "your-github-username", "your-spreadsheet-id"
SCHEMA = {"type": "object", "properties": {"rows": {"type": "array", "items": {"type": "object", "properties": {
    "day": {"type": "string"}, "repo": {"type": "string"}, "description": {"type": "string"}, "hours": {"type": "number"}}}}}}

@on_trigger
def run(event):
    since = date.today() - timedelta(days=date.today().weekday())
    groups = defaultdict(list)
    for c in gh("GET", "/search/commits", params={"q": f"author:{AUTHOR} committer-date:>={since}", "per_page": 100})["items"]:
        groups[(c["commit"]["author"]["date"][:10], c["repository"]["name"])].append(f"{c['commit']['author']['date'][11:16]} {c['commit']['message'].splitlines()[0]}")
    for p in gh("GET", "/search/issues", params={"q": f"author:{AUTHOR} is:pr updated:>={since}", "per_page": 50})["items"]:
        groups[(p["updated_at"][:10], p["repository_url"].split("/")[-1])].append(f"PR: {p['title']}")
    if not groups:
        return {"rows": 0}
    text = "\n\n".join(f"{d} {r}:\n" + "\n".join(items) for (d, r), items in sorted(groups.items()))
    rows = ai.generate(text[:20000], json_schema=SCHEMA, max_output_tokens=1500,
                       system="For each day and repo, write a one-sentence description of the work and estimate hours from commit times.").json["rows"]
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    sheets.spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Timesheet!A:D", valueInputOption="USER_ENTERED",
        body={"values": [[r["day"], r["repo"], r["description"], r["hours"]] for r in rows]}).execute()
    return {"rows": len(rows)}