Book appointment requests into your calendar and a sheet

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

SHEET_ID = "your-spreadsheet-id"

@on_event
def handle(event):
    b = event.json
    creds = Credentials(credentials.connection("google", "work"))
    cal = build("calendar", "v3", credentials=creds, cache_discovery=False)
    busy = cal.freebusy().query(body={"timeMin": b["start"], "timeMax": b["end"], "items": [{"id": "primary"}]}).execute()
    if busy["calendars"]["primary"]["busy"]:
        return {"booked": False, "reason": "busy"}
    body = {"summary": f"Appointment: {b['name']}", "start": {"dateTime": b["start"]}, "end": {"dateTime": b["end"]},
            "attendees": [{"email": b["email"]}]}
    if b.get("event_id"):
        ev = cal.events().patch(calendarId="primary", eventId=b["event_id"], body=body, sendUpdates="all").execute()
    else:
        ev = cal.events().insert(calendarId="primary", body=body, sendUpdates="all").execute()
    build("sheets", "v4", credentials=creds, cache_discovery=False).spreadsheets().values().append(
        spreadsheetId=SHEET_ID, range="Appointments!A:E", valueInputOption="USER_ENTERED",
        body={"values": [[b["start"], b["name"], b["email"], ev["id"], "rescheduled" if b.get("event_id") else "booked"]]}).execute()
    return {"booked": True, "event": ev["id"]}