The Scenario
You're a UX researcher. Three weeks ago, a design critique session left 45 inline comments on a Notion page — feedback from six different stakeholders on the new checkout flow. Your job now is to synthesize those comments into themes for the next sprint planning. The comments are scattered across different blocks of the page, attributed to different commenters, and there's no way to see them all in one view without clicking through each yellow highlight individually.
The bad version:
- Hover over the first yellow comment highlight, read the text, switch to your synthesis workbook, type it in, note the commenter, switch back to Notion, find the next highlight.
- After twenty minutes you've captured fifteen comments and lost your place in the page three times because Notion's comment sidebar closes when you click elsewhere.
- The synthesis you need is "all comments, commenter name, and text in one place." What you have is a fragmented half-finished list and a growing frustration with yellow highlights.
Synthesis work requires all the material in front of you at once. Notion's comment UX is designed for conversation, not for bulk data extraction.
The Easy Way: One Prompt in SheetXAI
SheetXAI connects to Notion and retrieves all comments from a page — commenter name, text, and timestamp — and writes them into your workbook in one operation.
Fetch all comments from Notion page ID xyz and write the commenter name, comment text, and timestamp into columns A, B, and C of this workbook
What You Get
- All 45 comments land in the workbook, one per row, with commenter name in column A, comment text in column B, and creation timestamp in column C.
- The order matches the Notion comment thread order — top of the page to bottom.
- Resolved and unresolved comments are both included by default; the prompt can be narrowed to unresolved only if needed.
What If the Data Is Not Quite Ready
You only want unresolved comments — skip anything that was already addressed
Fetch all unresolved comments from Notion page ID xyz and write commenter name, comment text, and timestamp to columns A, B, and C
Resolved comments don't appear in the workbook. Only the open items land for synthesis.
You need comments from multiple Notion pages — a series of five critique session pages
Fetch all unresolved comments from Notion pages ID abc, def, ghi, jkl, mno — combine into this workbook with an additional column D indicating which page each comment came from — write commenter name, text, timestamp, and page ID
Five sessions, one workbook, one synthesis pass. Column D tells you which page each comment belongs to.
You need to tag each comment with a theme category and write those back to Notion as replies
Fetch all unresolved comments from Notion page ID xyz and write to columns A, B, C — in column D, classify each comment into one of these themes: Navigation, Copy, Accessibility, Visual Design — then post a reply to each comment in Notion with the assigned theme
Comments land in the workbook, get categorized, and the category is posted back as a reply in Notion. The synthesis output is visible in both places.
The kill chain — fetch, classify, deduplicate commenter names, write summary
Fetch all unresolved comments from Notion page ID xyz — write commenter name, text, and timestamp to columns A, B, C — classify each comment into Navigation, Copy, Accessibility, or Visual Design in column D — deduplicate commenter names to canonical first-name forms in column E — write a one-row summary at the bottom of the workbook counting comments per theme
One prompt: fetch, classify, normalize commenter names, summarize by theme. The synthesis document is ready before you start reading.
When the classification and the fetch happen together, the themes emerge from the data instead of having to be imposed on it manually.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook you use for research synthesis. Ask SheetXAI to pull all the comments from the critique page so you can work through the themes in one place. Also useful: bulk-add-comments-to-pages for posting feedback back to pages, and the hub overview for all Notion workflows.