The Scenario
The engineering manager runs a Monday morning team sync and the last item is always the same: who's been contributing on the sprint board. The manager wants comments, card moves, and updates grouped by person. Pulling this from Trello means scrolling a flat activity feed, noting each actor, and tallying manually. Every week. The sync starts at 10 and the data pull starts at 9:15.
The bad version:
- Open Trello's activity log, scroll back to the previous Monday
- Copy actions one by one into Excel, noting each actor's username
- Sort after the fact and count per person — then realize you missed actions from the first day because the scroll cut off
The data exists in Trello's action history. The grouping and counting are what Trello doesn't do — and doing it manually every week is the kind of overhead that slowly convinces managers that tracking contribution isn't worth it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It pulls Trello board action history and can group, count, and summarize by actor in a single prompt — no pivot table required.
The prompt to run:
Get all actions from the Trello board 'Engineering Sprint' in the last 28 days. Group by the member who performed the action and write one row per member with their username, total actions, comment count, and card move count into this sheet.
What You Get
- One row per team member with any activity in the last 28 days
- Columns: username, total actions, comment count, card move count
- Members with zero activity are excluded
- Ready to sort or chart immediately
What If the Data Is Not Quite Ready
You want the raw log for your own pivot table
Fetch all actions on the Trello board 'Engineering Sprint' in the last 28 days. Write each action's date, action type, actor username, card name, and source and destination list (for card moves) into this Excel sheet so I can build a pivot.
You need a specific date range, not rolling 28 days
Get all actions on the Trello board 'Engineering Sprint' between the dates in cells A1 and B1. Group by actor username and write username, comment count, and card move count into this sheet.
You want week-over-week comparison
Fetch actions from the Trello board 'Engineering Sprint' for the 14 days ending yesterday. For each team member, write their username, action count in the first 7 days, and action count in the second 7 days so I can see week-over-week change.
Full contribution report with names and most-recent card
Get all actions from the Trello board 'Engineering Sprint' in the last 28 days. For each member, write their full name, username, total actions, comment count, card create count, card move count, and the name of the most recent card they touched. Sort by total actions descending.
That version gives the manager a conversation-ready report — not just usernames and numbers.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where you run sprint metrics. The contribution summary for any date range runs in one prompt and skips the manual tally. Also see how to export card velocity and the Trello hub.