Get your Notion tasks as a Telegram digest

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

DB_ID, CHAT_ID = "your-notion-database-id", "your-chat-id"

@on_trigger
def run(event):
    end = (date.today() + timedelta(days=7)).isoformat()
    tasks = http.post(f"https://api.notion.com/v1/databases/{DB_ID}/query", headers={"Authorization": f"Bearer {credentials.connection('notion', 'work')}",
        "Notion-Version": "2022-06-28"}, json={"filter": {"and": [{"property": "Due", "date": {"on_or_before": end}},
        {"property": "Done", "checkbox": {"equals": False}}]}, "sorts": [{"property": "Due", "direction": "ascending"}]}).json()["results"]
    groups = {}
    for t in tasks:
        p = t["properties"]
        name = "".join(x["plain_text"] for x in p["Name"]["title"])
        area = (p.get("Area", {}).get("select") or {}).get("name", "Other")
        groups.setdefault(area, []).append(f"• {p['Due']['date']['start'][5:]} {name}")
    body = "\n\n".join(f"{a}\n" + "\n".join(items) for a, items in groups.items()) or "Nothing due this week."
    try:
        intro = ai.generate(f"One friendly sentence overview of this week:\n{body}", max_output_tokens=60).text.strip()
    except ai.AIError:
        intro = "This week's plan:"
    http.post(f"https://api.telegram.org/bot{credentials.secret('TELEGRAM_BOT_TOKEN')}/sendMessage",
              json={"chat_id": CHAT_ID, "text": f"{intro}\n\n{body}"})
    return {"tasks": len(tasks)}