Get warned before Notion deadlines

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

DATABASE_ID = "your-database-id"
DATE_FIELD = "Certificate expires"
DAYS_AHEAD = 30

@on_trigger
def run(event):
    token = credentials.secret("NOTION_TOKEN")
    today = date.today()
    resp = http.post(
        f"https://api.notion.com/v1/databases/{DATABASE_ID}/query",
        headers={"Authorization": f"Bearer {token}", "Notion-Version": "2022-06-28"},
        json={"filter": {"property": DATE_FIELD,
                         "date": {"on_or_before": (today + timedelta(days=DAYS_AHEAD)).isoformat()}}},
    )
    resp.raise_for_status()
    alerted = set(state.get("alerted") or [])
    lines = []
    for page in resp.json()["results"]:
        props = page["properties"]
        name = "".join(t["plain_text"] for t in props["Name"]["title"])
        due = props[DATE_FIELD]["date"]["start"][:10]
        key = f"{page['id']}:{due}"
        if key in alerted:
            continue
        days = (date.fromisoformat(due) - today).days
        lines.append(f"• {name}: expires {due} ({days} days)")
        alerted.add(key)
    if lines:
        notify.slack("Supplier certificates expiring soon:\n" + "\n".join(lines), channel="#compliance")
    state.set("alerted", sorted(alerted)[-500:])
    return {"alerted": len(lines)}