The Scenario
You're an agile coach and the sprint retrospective is in 90 minutes. The engineering director wants a throughput chart — cards completed per week over the last 12 weeks. The board's action history is in Trello. Excel is where the chart needs to be. There's no export, no built-in grouping, and no way to get from the Trello activity feed to a weekly count without doing it manually.
The bad version:
- Open Trello's action history, scroll backward through 90 days, tally each "moved to Done" action by week on a notepad
- Transfer those tallies into Excel
- Build the chart from there, hoping you didn't miscount week 8
The throughput data is in Trello. Getting it into a form you can chart is the part that costs 45 minutes before any analysis begins.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your workbook, connects to Trello, and can pull board action history and write structured results back — grouped, counted, and sorted — without any manual tallying.
The prompt to run:
Get all updateCard actions from the Trello board 'Engineering Sprint' where a card was moved to the 'Done' list. Group them by ISO week and write the week start date and card count into columns A and B of this sheet, sorted by week ascending.
What You Get
- Column A: week start date (Monday), one row per week
- Column B: cards completed that week
- Rows sorted oldest to newest for immediate chart rendering
- Zero-count weeks included so the chart has no gaps
What If the Data Is Not Quite Ready
The board was renamed mid-quarter
The Trello board was renamed from 'Sprint Q1' to 'Engineering Sprint' six weeks ago. Fetch card-move-to-Done actions from both board names, combine them into a single weekly count, and write week start date and count into columns A and B. Note the source board name in column C.
You need throughput broken out by list
Get all card-move actions from the Trello board 'Engineering Sprint' for the last 12 weeks. Write the week start date in column A and counts of cards moved to In Review, Staging, and Done in columns B, C, and D respectively.
You want cycle time alongside throughput
Fetch all cards moved to 'Done' on the 'Engineering Sprint' board in the last 90 days. Write the card name, creation date, completion date, and days between them into this Excel sheet.
Full retrospective data with summary row
Get all updateCard and createCard actions from the 'Engineering Sprint' board in the last 28 days. Write date, action type, card name, source list, and destination list into this sheet. Then add a summary row showing total cards created, total completed, and average days to completion.
One prompt pulls the raw data and the summary so you walk into the retrospective with the chart already built.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where you track sprint metrics. Ask it to pull weekly throughput from your Trello board and you'll have a chartable dataset ready before the retro starts. Also see how to export per-member activity counts and the full Trello integration overview.