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.
Integrations
Trello
Notion
Slack
Type
Categories
- Product
- Operations
Build 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 it does
- 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 you’ll need
- 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 to 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.
Use cases
- AI Reports
- Daily Digests
