Get a weekly report from your Notion data

from datetime import date, timedelta
from clickruntime import on_trigger, credentials, http, ai, notify

NOTION = "https://api.notion.com/v1"

def headers():
    return {"Authorization": f"Bearer {credentials.secret('NOTION_TOKEN')}", "Notion-Version": "2022-06-28"}

def query(db, body=None):
    resp = http.post(f"{NOTION}/databases/{db}/query", headers=headers(), json=body or {})
    resp.raise_for_status()
    return resp.json()["results"]

def title(page, prop="Name"):
    return "".join(t["plain_text"] for t in page["properties"][prop]["title"])

ORDERS, REPORTS = "orders-database-id", "reports-database-id"

@on_trigger
def run(event):
    start = (date.today() - timedelta(days=7)).isoformat()
    rows = query(ORDERS, {"filter": {"property": "Delivered", "date": {"on_or_after": start}}})
    on_time = sum(r["properties"]["On time"]["checkbox"] for r in rows)
    in_full = sum(r["properties"]["In full"]["checkbox"] for r in rows)
    both = sum(r["properties"]["On time"]["checkbox"] and r["properties"]["In full"]["checkbox"] for r in rows)
    n = len(rows) or 1
    stats = f"Orders: {len(rows)}\nOn time: {on_time / n:.0%}\nIn full: {in_full / n:.0%}\nOTIF: {both / n:.0%}"
    http.post(f"{NOTION}/pages", headers=headers(), json={
        "parent": {"database_id": REPORTS},
        "properties": {"Name": {"title": [{"text": {"content": f"OTIF week of {start}"}}]}},
        "children": [{"paragraph": {"rich_text": [{"text": {"content": stats}}]}}]}).raise_for_status()
    comment = ai.generate("Write three sentences of commentary on these weekly delivery numbers:\n" + stats,
                          max_output_tokens=200).text
    notify.email_me(f"OTIF last week: {both / n:.0%}", f"{stats}\n\n{comment}")
    return {"orders": len(rows)}