Add form sign-ups to your Notion CRM and send a welcome email

import base64
from email.message import EmailMessage
from clickruntime import on_event, credentials, http

DB_ID = "your-notion-database-id"

@on_event
def handle(event):
    form = event.json or {}
    email, name = form.get("email"), form.get("name", "")
    if not email:
        return {"skipped": "no email"}
    n = {"Authorization": f"Bearer {credentials.connection('notion', 'work')}", "Notion-Version": "2022-06-28"}
    props = {"Name": {"title": [{"text": {"content": name}}]}, "Email": {"email": email},
             "Notes": {"rich_text": [{"text": {"content": str(form.get("message", ""))[:1900]}}]}}
    found = http.post(f"https://api.notion.com/v1/databases/{DB_ID}/query", headers=n, json={"filter": {"property": "Email", "email": {"equals": email}}}).json()["results"]
    if found:
        http.patch(f"https://api.notion.com/v1/pages/{found[0]['id']}", headers=n, json={"properties": props})
    else:
        http.post("https://api.notion.com/v1/pages", headers=n, json={"parent": {"database_id": DB_ID}, "properties": props})
    msg = EmailMessage()
    msg["To"], msg["Subject"] = email, "Thanks for getting in touch"
    msg.set_content(f"Hi {name},\n\nThanks for your message. I'll reply personally within one working day.\n")
    http.post("https://gmail.googleapis.com/gmail/v1/users/me/messages/send", headers={"Authorization": f"Bearer {credentials.connection('google', 'work')}"},
              json={"raw": base64.urlsafe_b64encode(msg.as_bytes()).decode()})
    return {"updated": bool(found)}