Back to Notion in Google Sheets
SheetXAI logo
Notion logo
Notion · Google Sheets Guide

Bulk Add Comments to Notion Pages From a Google Sheet

2026-05-15
5 min read

The Scenario

You're an editor managing a team of 12 freelance writers. After each draft review cycle, you fill in a Google Sheet with Notion page IDs in column A — one per draft — and the feedback for each draft in column B. The feedback needs to land in Notion as comments on the corresponding pages so writers can see it in context, not in a shared doc somewhere else. You have 25 drafts reviewed this week and you need the comments posted before the morning standup.

The bad version:

  • Open the first page ID from the sheet, find it in Notion, click the comment icon, type or paste the feedback from column B, post it.
  • Realize that pasting from a spreadsheet cell sometimes picks up an invisible newline at the start of the text, so the first word of your feedback is on a blank line in Notion.
  • Post the remaining 24 comments one at a time, spending 3-4 minutes per page navigating, pasting, cleaning up the paste artifact, and confirming.

25 pages at 3-4 minutes each is close to two hours for a task that is purely mechanical. The editorial judgment already happened. Posting the output shouldn't take this long.

The Easy Way: One Prompt in SheetXAI

SheetXAI reads the page IDs and feedback text from the sheet and posts each piece of feedback as a comment on the corresponding Notion page — no navigation, no paste artifacts.

Add a comment to each Notion page in column A using the feedback text in column B — trim whitespace from each comment before posting

What You Get

  • All 25 Notion pages receive a comment with the feedback text from column B.
  • Leading and trailing whitespace stripped from each comment before it's posted.
  • Column C updated with the comment post status for each row — "posted" or the specific error if a page wasn't found.

What If the Data Is Not Quite Ready

The feedback in column B has writer names at the start that should be stripped before posting

For each row, remove any text before the first colon in column B and post only the feedback content after the colon as a comment on the Notion page in column A

If your sheet uses "Writer Name: Feedback text" formatting, the prefix gets stripped before Notion sees it.

You want to post comments attributed to the writer rather than under your account

For each row, post the text from column B as a comment on the Notion page in column A — prefix the comment with the writer name from column C so attribution is visible in the comment text

Since Notion comments post under the authenticated account, this surfaces the writer attribution inside the comment text itself.

Some feedback cells contain multiple pieces of feedback separated by semicolons — post each as a separate comment

For each row in column A, split the feedback in column B on semicolons and post each piece as a separate comment on the Notion page

Multiple feedback points land as separate thread items rather than one long comment, which makes it easier for the writer to address them individually.

The kill chain — strip attribution, split multi-point feedback, post, log, flag missing pages

For each row: strip any text before the first colon in column B — split remaining text on semicolons — post each piece as a separate comment on the Notion page in column A — write the count of comments posted to column C — if the page is not found, write "page not found" in column C and skip

One prompt: attribution strip, split, multi-post, count log, error handling. The sidebar shows a clean record of what was posted and what couldn't be found.

When posting and cleanup happen together, writers see clean feedback the moment they open Notion.

Try It

Get the 7-day free trial of SheetXAI and open the review sheet with your feedback ready in column B. Ask SheetXAI to post all 25 comments before the standup. Also worth reading: pull-comments-to-sheet for pulling existing comments back for synthesis, and the hub overview for all Notion workflows.

Stop memorizing formulas.
Tell your spreadsheet what to do.

Join 4,000+ professionals saving hours every week with SheetXAI.

Learn more