Set up new clients in Sheets and book their kickoff call

from datetime import datetime, timedelta, timezone
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_event, credentials

SHEET_ID = "your-spreadsheet-id"
TASKS = ["Send welcome pack", "Collect documents", "Set up accounts access", "Kickoff call"]

@on_event
def handle(event):
    c = event.json or {}
    creds = Credentials(credentials.connection("google", "work"))
    rows = [[c.get("name"), c.get("email"), c.get("company"), datetime.now(timezone.utc).date().isoformat(), ""]]
    rows += [["", "", "", "", t] for t in TASKS]
    build("sheets", "v4", credentials=creds, cache_discovery=False).spreadsheets().values().append(
        spreadsheetId=SHEET_ID, range="Clients!A:E", valueInputOption="USER_ENTERED", body={"values": rows}).execute()
    cal = build("calendar", "v3", credentials=creds, cache_discovery=False)
    today = datetime.now(timezone.utc).replace(hour=0, minute=0, second=0, microsecond=0)
    week = today + timedelta(days=7 - today.weekday())
    busy = cal.freebusy().query(body={"timeMin": week.isoformat(), "timeMax": (week + timedelta(days=5)).isoformat(),
                                      "items": [{"id": "primary"}]}).execute()["calendars"]["primary"]["busy"]
    slots = [week + timedelta(days=d, hours=h) for d in range(5) for h in range(9, 17)]
    start = next(s for s in slots if all(not (b["start"] < (s + timedelta(hours=1)).isoformat() and b["end"] > s.isoformat()) for b in busy))
    cal.events().insert(calendarId="primary", sendUpdates="all", body={"summary": f"Kickoff: {c.get('company')}",
        "start": {"dateTime": start.isoformat()}, "end": {"dateTime": (start + timedelta(hours=1)).isoformat()},
        "attendees": [{"email": c.get("email")}]}).execute()
    return {"kickoff": start.isoformat()}