Tell people on WhatsApp or Telegram when a Notion item changes status

from clickruntime import on_trigger, credentials, http, state, report_fetched

DB = "your-database-id"
PEOPLE = {"Sam": ("wa", "447700900111"), "Jo": ("tg", 123456789)}
WA = "https://graph.facebook.com/v20.0/your-phone-number-id/messages"

def wa_template(to, name, params):
    body = {"messaging_product": "whatsapp", "to": to, "type": "template", "template": {"name": name, "language": {"code": "en"},
            "components": [{"type": "body", "parameters": [{"type": "text", "text": str(p)} for p in params]}]}}
    return http.post(WA, headers={"Authorization": f"Bearer {credentials.secret('WHATSAPP_TOKEN')}"}, json=body).json()
TG = "https://api.telegram.org"

def tg(chat_id, text):
    http.post(f"{TG}/bot{credentials.secret('TELEGRAM_BOT_TOKEN')}/sendMessage", json={"chat_id": chat_id, "text": text})

@on_trigger
def run(event):
    h = {"Authorization": f"Bearer {credentials.secret('NOTION_TOKEN')}", "Notion-Version": "2022-06-28"}
    since = state.get("since") or "2026-01-01T00:00:00Z"
    pages = http.post(f"https://api.notion.com/v1/databases/{DB}/query", headers=h, json={"filter": {"timestamp": "last_edited_time",
                      "last_edited_time": {"after": since}}}).json()["results"]
    known = state.get("status") or {}
    changed = [p for p in pages if (p["properties"]["Status"]["status"] or {}).get("name") != known.get(p["id"])]
    report_fetched(len(changed))
    if not changed:
        return {"summary": "No status changes"}
    for p in changed:
        props = p["properties"]
        status, title = props["Status"]["status"]["name"], "".join(t["plain_text"] for t in props["Name"]["title"]) or "Untitled"
        app, to = PEOPLE.get((props["Owner"]["select"] or {}).get("name"), (None, None))
        if app == "wa": wa_template(to, "status_update", [title, status])
        elif app == "tg": tg(to, f"📌 {title} is now {status}")
        known[p["id"]] = status
    state.set("status", known); state.set("since", max(p["last_edited_time"] for p in pages))
    return {"changed": len(changed)}