Keep a Notion log of your daily standups

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

CHANNEL_ID = "C0123STANDUP"
DATABASE_ID = "your-standups-database-id"

@on_trigger
def run(event):  # weekdays 9:30 and 11:00
    slack = WebClient(token=credentials.connection("slack", "work"))
    if datetime.now(ZoneInfo("Europe/London")).hour < 10:
        ts = slack.chat_postMessage(channel=CHANNEL_ID, text="☀️ Standup: what did you do yesterday, what's next, any blockers? Reply in this thread.")["ts"]
        state.set("prompt_ts", ts)
        return {"asked": ts}
    replies = slack.conversations_replies(channel=CHANNEL_ID, ts=state.get("prompt_ts"))["messages"][1:]
    blocks = []
    for r in replies:
        name = slack.users_info(user=r["user"])["user"]["real_name"]
        blocks.append({"object": "block", "type": "paragraph", "paragraph": {"rich_text": [
            {"text": {"content": f"{name}: "}, "annotations": {"bold": True}}, {"text": {"content": r["text"][:1900]}}]}})
    page = http.post("https://api.notion.com/v1/pages",
                     headers={"Authorization": f"Bearer {credentials.secret('NOTION_TOKEN')}", "Notion-Version": "2022-06-28"},
                     json={"parent": {"database_id": DATABASE_ID},
                           "properties": {"Name": {"title": [{"text": {"content": f"Standup {date.today()}"}}]}},
                           "children": blocks}).json()
    slack.chat_postMessage(channel=CHANNEL_ID, text=f"📝 {len(replies)} updates saved: {page['url']}")
    return {"updates": len(replies)}