Book appointments into your calendar and log clients in Airtable

from datetime import datetime, timedelta, timezone
from clickruntime import on_event, credentials, http, state

BASE, TABLE, MINUTES = "appXXXXXXXX", "Clients", 45

@on_event
def handle(event):
    if state.get(f"done:{event.event_id}"):
        return {"skipped": "duplicate"}
    req = event.json
    g = {"Authorization": f"Bearer {credentials.connection('google', 'work')}"}
    day = datetime.fromisoformat(req.get("preferred_day") or (datetime.now(timezone.utc) + timedelta(days=1)).date().isoformat()).replace(tzinfo=timezone.utc)
    busy = http.post("https://www.googleapis.com/calendar/v3/freeBusy", headers=g, json={"timeMin": day.isoformat(),
                     "timeMax": (day + timedelta(days=1)).isoformat(), "items": [{"id": "primary"}]}).json()["calendars"]["primary"]["busy"]
    slot = next(s for s in (day.replace(hour=h) for h in range(9, 17))
                if not any(b["start"] < (s + timedelta(minutes=MINUTES)).isoformat() and b["end"] > s.isoformat() for b in busy))
    http.post("https://www.googleapis.com/calendar/v3/calendars/primary/events", headers=g, params={"sendUpdates": "all"},
              json={"summary": f"Appointment: {req['name']}", "attendees": [{"email": req["email"]}],
                    "start": {"dateTime": slot.isoformat()}, "end": {"dateTime": (slot + timedelta(minutes=MINUTES)).isoformat()}})
    http.post(f"https://api.airtable.com/v0/{BASE}/{TABLE}", headers={"Authorization": f"Bearer {credentials.secret('AIRTABLE_API_KEY')}"},
              json={"fields": {"Name": req["name"], "Email": req["email"], "Appointment": slot.isoformat()}})
    state.set(f"done:{event.event_id}", True)
    return {"booked": slot.isoformat()}