Create a Drive folder and Notion page for each new client

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

TEMPLATE_FOLDER, CLIENTS_FOLDER, DATABASE_ID = "your-template-folder-id", "your-clients-folder-id", "your-database-id"

@on_event
def handle(event):
    form = event.json or {}
    name, email = form.get("client_name", "").strip(), form.get("email", "")
    if not name:
        return {"skipped": "no client name"}
    drive = build("drive", "v3", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).files()
    folder = drive.create(body={"name": name, "mimeType": "application/vnd.google-apps.folder", "parents": [CLIENTS_FOLDER]},
                          fields="id,webViewLink").execute()
    for f in drive.list(q=f"'{TEMPLATE_FOLDER}' in parents and trashed=false", fields="files(id,name)").execute()["files"]:
        drive.copy(fileId=f["id"], body={"name": f"{name} - {f['name']}", "parents": [folder["id"]]}).execute()
    page = http.post("https://api.notion.com/v1/pages", headers={"Authorization": f"Bearer {credentials.connection('notion', 'work')}",
                     "Notion-Version": "2022-06-28"}, json={"parent": {"database_id": DATABASE_ID}, "properties": {
                     "Name": {"title": [{"text": {"content": name}}]}, "Email": {"email": email or None},
                     "Drive folder": {"url": folder["webViewLink"]}}}).json()
    notify.slack(f"New client: {name}\nNotion: {page.get('url')}\nDrive: {folder['webViewLink']}", channel="#clients")
    return {"folder": folder["id"], "page": page.get("id")}