The Scenario
The product team runs a public-voting Trello board where users vote on feature requests. It's quarter-end, and the product manager needs to rank every card by vote count — most-demanded at the top — and take that list into the roadmap planning session. The vote data is in Trello. The planning session is in a spreadsheet.
The bad version:
- Open each card in the feature request board, note the vote count, and type it into a spreadsheet.
- Sort the spreadsheet manually once all the counts are entered.
- Realize three cards have votes from members who were removed from the board, so the count in Trello looks different from what you recorded last week.
Vote counts change. Any manually-copied snapshot is already stale the moment you finish typing the last row.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It fetches vote counts directly from the Trello API and writes a ranked list into your sheet — current as of the moment you run the prompt.
Open a blank sheet and paste:
Get all cards from the Trello board "Feature Requests" and write the card name, list, vote count, and list of voting members into this sheet sorted by vote count descending.
What You Get
- One row per card, sorted by vote count from highest to lowest.
- Voting member usernames appear in a dedicated column so you can see who drove demand for each feature.
- The data is live — pulled at prompt time, not from a cached snapshot.
- The sorted output is ready to share with stakeholders or drop into the roadmap planning doc.
What If the Data Is Not Quite Ready
You want voter details in separate rows rather than one aggregated cell
For each card in the Trello list "Community Votes", fetch the members who voted and write one row per voter with card name, total vote count, and voter username.
You need to filter to cards above a vote threshold
Get all cards from the Trello board "Feature Requests". Write only cards with 5 or more votes into this sheet, including card name, list, vote count, and description. Sort by vote count descending.
You want to join vote counts with existing roadmap data in the sheet
Get all cards from the Trello board "Feature Requests" and write their names and vote counts into columns A and B. Then, for each card name that appears in column D of this sheet (the roadmap list), write "on roadmap" into column C, or "not on roadmap" if it is absent.
Full community demand export in one shot
Get all cards from the Trello board "Feature Requests". Write card name, list, description, vote count, and voter usernames into this sheet sorted by vote count descending. Add a summary row showing the total number of cards and the average vote count.
The pattern: pull the live vote count at decision time, not a week before, so the ranking reflects what's actually true.
Try It
Open a blank Google Sheet and Get the 7-day free trial of SheetXAI — then ask it to rank your feature request cards by vote count so your roadmap session starts with real signal. See also running a cross-board card search or the Trello integration overview.