Weekly Trello board status report in Notion and Slack

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.

Additional information

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.

Frequently asked questions

Will this work if my Trello lists have different names?

Yes. When you set the workflow up, you map your real list names (like Backlog, Shipping, Released) to the report's categories, so the agent groups cards correctly no matter how your board is structured.

Does it actually summarize the cards, or just list them?

It writes a real narrative. The agent reads the cards, groups related work, attributes it to the right people, and produces a written recap. Not a raw card dump.

How does it decide a card is stuck?

By default, anything that hasn't moved in 7 or more days or is past its due date. You can change the threshold to match how your team works.

Can I send the recap to a different place than Slack and Notion?

Yes. You can swap Slack for email or another chat tool, or send the written report to any docs system. The structure of the report stays the same.

Do I need a paid Trello plan for this?

No. It works with any board your Trello login can read, on free or paid plans. Larger boards just take a little longer to pull.