The Scenario
It's sprint planning week and someone finally asked the question nobody wanted to answer: which of the 400 open Canny posts should actually be on the roadmap?
You've been staring at the Canny board trying to mentally rank things, but the UI isn't built for bulk scoring. There's no way to weight by vote count, filter by tag, and sort by created date at the same time in the same view. You need the data in a sheet where you can run formulas against it.
The bad version:
- Export the Canny CSV, open it, discover the columns don't match your scoring template, spend 20 minutes reformatting
- Realise the CSV doesn't include all the tags — some are missing entirely — and go back into Canny to cross-reference by hand
- Paste everything into the scoring sheet, only to find three dozen rows where the status field is blank because Canny exported an older format
Sprint planning starts at 10 AM and it's already 9:15.
Scoring 400 posts by hand is analysis. Reformatting 400 rows of a CSV export before you can even start is not. Your team is waiting on the ranked list, not on your formatting work.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet and, through its built-in Canny integration, pulls your board data directly — no export, no reformatting, no column hunting. You ask for the data in the shape you need it.
Export all posts from my Canny 'Feature Requests' board into this sheet with columns: Post ID, Title, Status, Vote Count, Tags, Author, Created Date
What You Get
- One row per Canny post, landed in the columns you specified
- Tags written as a comma-separated string in the Tags column
- Vote Count populated as a number — ready for formulas
- Status filled in for every row, including posts with no activity
- Created Date in ISO format so you can sort chronologically
What If the Data Is Not Quite Ready
The board has posts across multiple statuses and you only want 'Open' and 'In Progress'
Export all posts from my Canny 'Feature Requests' board where status is 'Open' or 'In Progress' — columns: Post ID, Title, Status, Vote Count, Tags, Author, Created Date
Posts have multiple tags and you want each tag in its own column
Export all posts from my Canny 'Feature Requests' board — split tags into separate columns: Tag 1, Tag 2, Tag 3. Use blank if fewer tags exist. Also include Post ID, Title, Status, Vote Count.
You have three boards and need them combined in one sheet with a Board Name column
Pull all posts from my Canny boards 'Feature Requests', 'Bug Reports', and 'Integrations' into this sheet — add a Board Name column to identify the source. Include Status, Vote Count, Tags.
You want a weighted priority score calculated inline, then sorted, then the top 50 flagged
Export all open posts from my Canny 'Feature Requests' board with Post ID, Title, Vote Count, and Created Date. Add a Priority Score column = Vote Count divided by days since Created Date. Sort descending by Priority Score. Flag the top 50 rows in a 'Top 50' column with 'yes'.
One prompt does the pull, the scoring, and the flagging — so what lands in the sheet is already ranked, not just dumped.
Try It
Get the 7-day free trial of SheetXAI and open your roadmap scoring sheet, then ask it to pull your Canny board into the columns your team already uses. From there, see how to bulk-update post statuses or explore the full Canny + Google Sheets guide.