Draft your weekly timesheet from email and commits

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)

AUTHOR = "your-github-username"

@on_trigger
def run(event):
    since = date.today() - timedelta(days=date.today().weekday())
    gmail = build("gmail", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).users()
    sent = gmail.messages().list(userId="me", q=f"in:sent after:{since:%Y/%m/%d}", maxResults=100).execute().get("messages", [])
    mails = []
    for m in sent:
        h = {x["name"]: x["value"] for x in gmail.messages().get(userId="me", id=m["id"], format="metadata",
             metadataHeaders=["To", "Subject", "Date"]).execute()["payload"]["headers"]}
        mails.append(f"{h.get('Date', '')[:16]} to {h.get('To')}: {h.get('Subject')}")
    commits = gh("GET", "/search/commits", params={"q": f"author:{AUTHOR} committer-date:>={since}", "per_page": 100})["items"]
    work = [f"{c['commit']['author']['date'][:10]} {c['repository']['full_name']}: {c['commit']['message'].splitlines()[0]}" for c in commits]
    draft = ai.generate("Sent emails:\n" + "\n".join(mails) + "\n\nCommits:\n" + "\n".join(work), max_output_tokens=1200,
                        system="Group this week's work into tasks per client with estimated hours. Output a plain-text table.").text
    notify.email_me(f"Draft timesheet, week of {since:%d %b}", draft)
    return {"emails": len(mails), "commits": len(work)}