Weekly Trello board status report in Notion and Slack
Every Monday at 9am, turn your Trello board into a clean weekly status report in Notion and post a 3-bullet TLDR to your team Slack channel.
Trello
Notion
SlackProductOperationsAI ReportsDaily DigestsBuild an agent workflow that publishes a weekly status report from a configured Trello board every Monday at 9am.
Trigger: cron, Mondays at 9am in the user's local timezone. The board ID, the Notion parent page ID, and the Slack channel are configured inputs.
When the workflow runs, the agent should do the following:
1. Pull the current state of the configured Trello board. Use Trello's Get a Board action with cards expanded so every card and its list are returned in one call. Then call Trello's Get Many Board Members so the agent can attribute cards to people by name instead of just by member ID.
2. Compose a written weekly status report organized into four sections: what shipped last week (cards that moved into the Done list since the last report), what's in flight (cards currently in In Progress), what's stuck (cards that haven't moved in 7+ days or are past their due date), and what's coming next (top cards in the Up Next list). The list names Done, In Progress, and Up Next should be configurable so teams with different conventions can map their own list names.
The report should read like a narrative a team would actually want to read. Group related work, name the owners, give one or two sentences of context per item, and call out blockers in plain language. Do not produce a raw card dump.
3. Create the report as a new Notion page using Notion's Create a Page action, under the configured parent page. Title it something like "Weekly status: <date range>". Use proper headings and bullet lists in the page body so it's scannable in Notion.
4. Post a Slack message using Slack's Send a Message action to the configured team channel. The message should include a link to the new Notion page and a 3-bullet TLDR: one bullet for what shipped, one for what's stuck, one for what's coming next.
Configurable inputs the user should be able to set: Trello board ID, Notion parent page ID, Slack channel, the mapping of their list names to Done / In Progress / Up Next, the day and time the report runs, and the stuck threshold in days.
What does this prompt do?
- Reads your Trello board every Monday at 9am, including every card, every list, and the people working on the board.
- Writes a narrative weekly status report covering what shipped last week, what's in flight, what's stuck, and what's coming next.
- Files the report as a new Notion page under a parent page you choose, so the team has a permanent searchable history.
- Posts a 3-bullet TLDR in your team Slack channel with a link back to the full Notion write-up.
What do I need to use this?
- A Trello account with access to the board you want to report on.
- A Notion workspace and a parent page where weekly reports should live.
- A Slack workspace and the team channel where the Monday recap should be posted.
How can I customize it?
- Change the day or time the report runs (Friday afternoon, Tuesday morning, daily standup, etc).
- Map your board's actual list names to the report's categories if you don't use Done, In Progress, and Up Next.
- Tune the rule for what counts as stuck (5 days, 10 days, only when past due, etc).
- Pick the Slack channel and the Notion section the recap files under.
FAQs
Will this work if my Trello lists have different names?
Does it actually summarize the cards, or just list them?
How does it decide a card is stuck?
Can I send the recap to a different place than Slack and Notion?
Do I need a paid Trello plan for this?
Related templates
When your flight moves, your calendar times get corrected automatically and you get a Slack note naming the meetings you're about to miss.
Every 15 minutes, forwarded phishing reports get traced back to the server that really sent them, with a verdict in Slack and the worst senders reported.
Every weekday at 7am, sign in to the tender portals you track, filter new notices against your bid criteria, and open a deal for the ones worth chasing.
Every Monday, rank the week's matches by expected demand, put the big ones on your venue calendar, and post a rota-ready summary to Slack.
Every Monday, last week's survey answers and support conversations become one themed report in Notion, with the top five themes posted to Slack.
Every Tuesday we pull your best new reviews, draft social captions, email testimonials and product page quotes, then stage them in Notion for approval.
Stop hand-writing your weekly team update.
Connect Trello, Notion, and Slack once, and Geni publishes the status report from your board every Monday at 9am.