Log form leads to a Google Sheet and announce them in Discord

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

SHEET_ID = "your-spreadsheet-id"
CHANNEL_ID = "your-discord-channel-id"

@on_event
def handle(event):
    lead = event.json or {}
    name, company, email = lead.get("name", "").strip(), lead.get("company", "").strip(), lead.get("email", "").strip()
    if not name or not re.match(r"[^@\s]+@[^@\s]+\.[^@\s]+$", email):
        return {"skipped": "missing name or email"}
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    row = [datetime.now(timezone.utc).isoformat(timespec="minutes"), name, company, email, lead.get("message", "")]
    sheets.spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Leads!A:E", valueInputOption="USER_ENTERED",
                                          body={"values": [row]}).execute()
    http.post(f"https://discord.com/api/v10/channels/{CHANNEL_ID}/messages",
              headers={"Authorization": f"Bot {credentials.secret('DISCORD_BOT_TOKEN')}"},
              json={"content": f"New lead: {name} ({company or 'no company'}) {email}"})
    return {"logged": email}