The Scenario
Sprint review is in two hours. You are the scrum master. You need a checklist completion report — how many items done vs. total — for each of the 45 cards on the current sprint board. The team will want to see percentages. You have a blank Google Sheet open.
The bad version:
- Open the first card in Trello. Count the checklist items. Count the checked ones. Note it down.
- Open the second card. Count. Note.
- Forty-five cards. Each one requires opening the card, expanding the checklist, manually counting checked and unchecked boxes. You'll lose count around card 20 and have to recount.
Sprint velocity metrics are supposed to come from data, not from a scrum master spending 45 minutes counting checkboxes the morning of the review.
The Easy Way: One Prompt in SheetXAI
SheetXAI pulls the checklist data from every card and writes the completion stats directly into the sheet.
For every card on the Trello board 'Sprint 12', fetch its checklists and write the card name, total checklist items, and completed checklist items into this sheet. Add a column with the completion percentage.
What You Get
- One row per card with a checklist, skipping cards with none.
- Columns: card name (A), total items (B), completed items (C), completion percentage (D).
- Percentage calculated as completed / total, formatted as a decimal or percentage as you prefer.
- Cards with zero checklist items are either noted in a separate section or omitted, depending on your prompt.
What If the Data Is Not Quite Ready
You want separate rows per checklist when a card has multiple checklists
Get all checklists from every card in the Trello list 'In Progress'. For each checklist, write the card name, checklist name, number of done items, and total items into separate rows in this sheet.
You only want cards below a certain completion threshold
For every card on the Trello board 'Sprint 12', fetch its checklists. Write card name, total items, completed items, and percentage into this sheet. Only include cards where the completion percentage is below 50%.
You need the individual checklist item names, not just counts
For every card on the Trello board 'Sprint 12', fetch all checklists. For each checklist item, write the card name, checklist name, item name, and whether it is complete (yes/no) as separate rows in this sheet.
Pull the data, calculate completion, flag incomplete cards, and summarize for the review
For every card on the Trello board 'Sprint 12', fetch its checklists. Write card name, total items, completed items, and percentage into columns A-D. In column E, flag any card with less than 80% completion as 'needs attention'. At the bottom, add a board-level summary: total items across all cards, total completed, and overall percentage.
The summary row at the bottom is what actually goes into the sprint review slide.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet before your next sprint review, then ask it to pull checklist completion stats from your Trello board. Also useful: Export a Trello board into a sheet or the Trello integration overview.