Save every form entry to Airtable and a sheet

from datetime import datetime, timezone
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_event, credentials, http, notify, log

BASE_ID = "appXXXXXXXXXXXXXX"
SHEET_ID = "1AbCdEfGhIjKlMnOpQrStUvWxYz"

@on_event
def handle(event):
    form = event.json or {}
    email = (form.get("email") or "").strip().lower()
    if not email:
        log.warning("submission without email skipped")
        return {"saved": False}
    name, message = form.get("name", ""), form.get("message", "")
    http.post(f"https://api.airtable.com/v0/{BASE_ID}/Submissions",
              headers={"Authorization": f"Bearer {credentials.connection('airtable', 'work')}"},
              json={"typecast": True, "records": [{"fields": {"Name": name, "Email": email, "Message": message}}]}
              ).raise_for_status()
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    sheets.spreadsheets().values().append(
        spreadsheetId=SHEET_ID, range="Submissions!A:D", valueInputOption="USER_ENTERED",
        body={"values": [[datetime.now(timezone.utc).isoformat(timespec="minutes"), name, email, message]]}).execute()
    notify.email_me(f"New submission: {name or email}", f"{name} <{email}>\n\n{message[:500]}")
    return {"saved": True}