Turn your week's calendar into a timesheet by client

from datetime import datetime, timedelta, timezone
from clickruntime import on_trigger, credentials, http, ai

SHEET, CLIENTS = "your-spreadsheet-id", ["Northwind", "Acme", "Contoso", "Internal"]

@on_trigger
def run(event):
    h = {"Authorization": f"Bearer {credentials.connection('google', 'work')}"}
    end = datetime.now(timezone.utc)
    events = http.get("https://www.googleapis.com/calendar/v3/calendars/primary/events", headers=h, params={
        "timeMin": (end - timedelta(days=7)).isoformat(), "timeMax": end.isoformat(), "singleEvents": True}).json().get("items", [])
    events = [e for e in events if "dateTime" in e.get("start", {}) and e.get("visibility") != "private"]
    if not events:
        return {"rows": 0}
    lines = "\n".join(f"{i}. {e.get('summary', '')} | {', '.join(a['email'] for a in e.get('attendees', []))}" for i, e in enumerate(events))
    labels = ai.generate(f"Clients: {', '.join(CLIENTS)}. For each numbered event reply one client per line, or unassigned.\n{lines}",
                         max_output_tokens=20 * len(events)).text.strip().splitlines()
    rows = []
    for i, e in enumerate(events):
        s, f = datetime.fromisoformat(e["start"]["dateTime"]), datetime.fromisoformat(e["end"]["dateTime"])
        client = labels[i].split(". ", 1)[-1].strip() if i < len(labels) else "unassigned"
        rows.append([s.date().isoformat(), e.get("summary", ""), client, round((f - s).total_seconds() / 3600, 2)])
    http.post(f"https://sheets.googleapis.com/v4/spreadsheets/{SHEET}/values/Timesheet!A:D:append", headers=h,
              params={"valueInputOption": "USER_ENTERED"}, json={"values": rows})
    return {"rows": len(rows)}