Keep a Google Sheet of every work calendar event

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

SHEET_ID = "your-spreadsheet-id"

@on_trigger
def run(event):
    creds = Credentials(credentials.connection("google", "work"))
    cal = build("calendar", "v3", credentials=creds, cache_discovery=False).events()
    token = state.get("sync_token")
    res = cal.list(calendarId="primary", syncToken=token, singleEvents=True).execute() if token else \
        cal.list(calendarId="primary", singleEvents=True, maxResults=2500).execute()
    items = res.get("items", [])
    report_fetched(len(items))
    if not items:
        return {"changed": 0}
    sheet = build("sheets", "v4", credentials=creds, cache_discovery=False).spreadsheets().values()
    ids = [r[0] if r else "" for r in sheet.get(spreadsheetId=SHEET_ID, range="Events!A2:A").execute().get("values", [])]
    new_rows = []
    for e in items:
        row = [e["id"], e.get("summary", ""), e.get("start", {}).get("dateTime", ""), e.get("end", {}).get("dateTime", ""),
               ", ".join(a["email"] for a in e.get("attendees", [])), e.get("status", "")]
        if e["id"] in ids:
            n = ids.index(e["id"]) + 2
            sheet.update(spreadsheetId=SHEET_ID, range=f"Events!A{n}:F{n}", valueInputOption="RAW", body={"values": [row]}).execute()
        else:
            new_rows.append(row)
    if new_rows:
        sheet.append(spreadsheetId=SHEET_ID, range="Events!A:F", valueInputOption="RAW", body={"values": new_rows}).execute()
    state.set("sync_token", res.get("nextSyncToken"))
    return {"changed": len(items)}