Back up your Notion databases to Google Drive every night

import json
from datetime import date
from clickruntime import on_trigger, credentials, http, notify

DATABASES = {"Clients": "notion-db-id-1", "Projects": "notion-db-id-2"}
PARENT_FOLDER = "your-drive-folder-id"

@on_trigger
def run(event):
    notion = {"Authorization": f"Bearer {credentials.connection('notion', 'work')}", "Notion-Version": "2022-06-28"}
    drive = {"Authorization": f"Bearer {credentials.connection('google', 'work')}"}
    folder = http.post("https://www.googleapis.com/drive/v3/files", headers=drive, json={"name": date.today().isoformat(),
        "mimeType": "application/vnd.google-apps.folder", "parents": [PARENT_FOLDER]}).json()["id"]
    failed = []
    for name, db in DATABASES.items():
        try:
            pages, cursor = [], None
            while True:
                r = http.post(f"https://api.notion.com/v1/databases/{db}/query", headers=notion, json={"start_cursor": cursor} if cursor else {}).json()
                pages += r["results"]
                if not r.get("has_more"):
                    break
                cursor = r["next_cursor"]
            http.post("https://www.googleapis.com/upload/drive/v3/files?uploadType=multipart", headers=drive, files={
                "metadata": ("m", json.dumps({"name": f"{name}.json", "parents": [folder]}), "application/json"),
                "file": (f"{name}.json", json.dumps(pages), "application/json")}).raise_for_status()
        except Exception as e:
            failed.append(f"{name}: {e}")
    if failed:
        notify.email_me("Notion backup failed", "\n".join(failed))
    return {"backed_up": len(DATABASES) - len(failed), "failed": len(failed)}