Save form submissions to Airtable and send a confirmation email

import base64
from email.mime.text import MIMEText
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_event, credentials, http, state

BASE, TABLE = "appXXXXXXXX", "Enquiries"

@on_event
def handle(event):
    if state.get(f"done:{event.event_id}"):
        return {"skipped": "duplicate"}
    form = event.json or {}
    http.post(f"https://api.airtable.com/v0/{BASE}/{TABLE}", headers={"Authorization": f"Bearer {credentials.secret('AIRTABLE_API_KEY')}"},
              json={"fields": {"Name": form.get("name"), "Email": form.get("email"), "Message": form.get("message"), "Received": event.received_at}})
    msg = MIMEText(f"Hi {form.get('name', 'there')},\n\nThanks for getting in touch. We have your message and will reply within one working day.")
    msg["To"], msg["Subject"] = form["email"], "We received your message"
    gmail = build("gmail", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    gmail.users().messages().send(userId="me", body={"raw": base64.urlsafe_b64encode(msg.as_bytes()).decode()}).execute()
    state.set(f"done:{event.event_id}", True)
    return {"saved": True}