Book a kickoff meeting when a client starts onboarding

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

TABLE = "https://api.airtable.com/v0/your-base-id/Clients"

@on_trigger
def run(event):
    h = {"Authorization": f"Bearer {credentials.secret('AIRTABLE_API_KEY')}"}
    recs = http.get(TABLE, headers=h, params={"filterByFormula": "AND({Status}='Onboarding',{Kickoff link}='')"}).json()["records"]
    report_fetched(len(recs))
    if not recs:
        return {"new": 0}
    cal = build("calendar", "v3", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    day = date.today() + timedelta(days=1 if date.today().weekday() < 4 else 7 - date.today().weekday())
    start = datetime.combine(day, time(10, 0))
    for r in recs:
        f = r["fields"]
        ev = cal.events().insert(calendarId="primary", sendUpdates="all", body={
            "summary": f"Kickoff: {f['Name']}", "attendees": [{"email": f["Contact email"]}],
            "start": {"dateTime": start.isoformat(), "timeZone": "Europe/London"},
            "end": {"dateTime": (start + timedelta(hours=1)).isoformat(), "timeZone": "Europe/London"}}).execute()
        http.patch(f"{TABLE}/{r['id']}", headers=h, json={"fields": {"Kickoff link": ev["htmlLink"]}})
    return {"booked": len(recs)}