Email yourself a weekly Notion database backup

import csv, io
from clickruntime import on_trigger, credentials, http, notify

DATABASE_ID = "your-clients-database-id"

def plain(prop):
    kind = prop["type"]
    value = prop.get(kind)
    if kind in ("title", "rich_text"):
        return "".join(t["plain_text"] for t in value)
    if kind in ("select", "status"):
        return (value or {}).get("name", "")
    if kind == "multi_select":
        return ", ".join(o["name"] for o in value)
    if kind == "date":
        return (value or {}).get("start", "")
    return "" if isinstance(value, (dict, list)) else str(value or "")

@on_trigger
def run(event):
    headers = {"Authorization": f"Bearer {credentials.connection('notion', 'work')}",
               "Notion-Version": "2022-06-28"}
    rows, body = [], {"page_size": 100}
    while True:
        page = http.post(f"https://api.notion.com/v1/databases/{DATABASE_ID}/query",
                         headers=headers, json=body).json()
        rows += [{k: plain(v) for k, v in r["properties"].items()} for r in page["results"]]
        if not page.get("has_more"):
            break
        body["start_cursor"] = page["next_cursor"]
    out = io.StringIO()
    writer = csv.DictWriter(out, fieldnames=sorted({k for r in rows for k in r}))
    writer.writeheader()
    writer.writerows(rows)
    notify.email_me(f"Notion Clients backup: {len(rows)} rows", out.getvalue())
    return {"rows": len(rows)}