Create recurring tasks in Notion

from datetime import date, timedelta
from slack_sdk import WebClient
from clickruntime import on_trigger, credentials, http, state

RULES_DB = "your-recurring-database-id"
TASKS_DB = "your-tasks-database-id"

@on_trigger
def run(event):  # Mondays
    h = {"Authorization": f"Bearer {credentials.secret('NOTION_TOKEN')}", "Notion-Version": "2022-06-28"}
    week = date.today().isocalendar()
    key = f"{week.year}-W{week.week}"
    done = set(state.get(key) or [])
    slack = WebClient(token=credentials.connection("slack", "work"))
    created = 0
    for rule in http.post(f"https://api.notion.com/v1/databases/{RULES_DB}/query", headers=h, json={}).json()["results"]:
        p = rule["properties"]
        if rule["id"] in done:
            continue
        title = "".join(t["plain_text"] for t in p["Name"]["title"])
        due = date.today() + timedelta(days=int(p["Weekday"]["number"] or 0))
        http.post("https://api.notion.com/v1/pages", headers=h, json={"parent": {"database_id": TASKS_DB}, "properties": {
            "Name": {"title": [{"text": {"content": title}}]}, "Due": {"date": {"start": due.isoformat()}},
            "Assignee": {"people": [{"id": u["id"]} for u in p["Owner"]["people"]]}}})
        for u in p["Owner"]["people"]:
            sid = slack.users_lookupByEmail(email=u["person"]["email"])["user"]["id"]
            slack.chat_postMessage(channel=sid, text=f"🔁 New this week: {title} (due {due:%a %d %b})")
        done.add(rule["id"]); created += 1
    state.set(key, sorted(done))
    return {"created": created}