The Scenario
Your brand hit 500K subscribers last month and the community team is finally looking at what people are actually saying. Someone pulls up the 10 most recent video IDs and asks you to get all the top-level comments into a sheet so the team can tag recurring complaints and surface the power users. "Should be quick," they say.
The bad version:
- Open the first video, scroll through comments, copy 20 of them one at a time into a sheet with the video ID typed in manually
- Realize there are 300 comments on this video and YouTube only loads more as you scroll
- Check if there's a comment export in YouTube Studio — there isn't
- Write a note to the developer to "maybe add a script for this," which goes into the backlog and never comes back out
The community report is supposed to go to the head of brand next Friday. You need all the comments, not a manually curated sample.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the video IDs in your sheet and pulls comments from the YouTube API, handling pagination automatically.
For each video ID in column A, fetch all top-level comments and append them to this sheet with columns: video ID, comment ID, author, text, like count, and published date
What You Get
- One row per comment, appended to the sheet
- Column A: source video ID
- Column B: YouTube comment ID (useful for posting replies later)
- Column C: author display name
- Column D: comment text
- Column E: like count on the comment
- Column F: comment published date
- Comments fetched in recency order, most recent first
What If the Data Is Not Quite Ready
You only want comments from videos published after a certain date
For each video ID in column A that was published after 2025-01-01, fetch all top-level comments and append them with columns for video ID, comment ID, author, text, like count, and published date
You want to pull only the top 20 most-liked comments per video
For each video ID in column A, fetch the 20 top-level comments with the highest like count and write them into this sheet with video ID, author, text, and like count columns
You need to join comment data with video titles from a second tab
For each video ID in column A, look up the video title from the Titles tab (where column A has video IDs and column B has titles), then fetch all top-level comments and write them into this sheet with video ID, video title, author, text, like count, and published date
You want to flag comments that mention specific complaint keywords and add a sentiment column
For each video ID in column A, fetch all top-level comments into this sheet — add a column that flags rows where the comment text contains any of these words: broken, refund, scam, cancelled, terrible — then add a second column with a rough sentiment label (positive if like count is above 10 and no flag, negative if flagged, neutral otherwise)
One prompt handles the fetch, the keyword scan, and the labeling.
Try It
Get the 7-day free trial of SheetXAI and open a sheet with your 10 most recent video IDs — ask SheetXAI to pull all comments and you'll have a structured dataset ready for tagging within minutes. Also see bulk-posting replies to comments or the YouTube hub.