Extract and Store YouTube Video Comments in Google Sheets
VerifiedManually pull YouTube comments via HTTP and append them to Google Sheets.
What this workflow does
This n8n workflow reads YouTube video URLs from Google Sheets, retrieves comments through HTTP requests, and stores the data in a connected spreadsheet for later use.
It supports creators, marketers, analysts, and growth teams who need to compile engagement metrics or campaign performance from YouTube comments at scale.
Who is this for?
YouTube creators, marketers, data analysts, and growth teams who need to pull video comments into spreadsheets for analysis.
What problem it solves
Manually copying YouTube comments is slow and error-prone; this workflow automates fetching comments via the YouTube API and writing them directly to Google Sheets.
What it automates
Audience feedback review
A creator pastes several video URLs into the sheet and gets all top-level comments in one place for quick sentiment checks.
Campaign performance tracking
A marketer runs the workflow after a sponsored video launch to collect comments and measure engagement metrics over time.
Engagement data export
An analyst pulls comments from multiple videos into a single Google Sheet to build reports or feed further analysis tools.
How the workflow works
The 2 nodes in this automation, in order.
- 1Google SheetsgoogleSheets
- 2HTTP RequesthttpRequest
Apps & integrations used
How to set up Extract and Store YouTube Video Comments in Google Sheets
- 1Add a Manual Trigger node as the workflow start.
- 2Connect a Google Sheets node and point it to the sheet tab that holds the list of video URLs.
- 3Add an HTTP Request node configured to call the YouTube commentThreads endpoint using the video ID from the sheet.
- 4Map the HTTP response fields (comment text, author, published date) to the columns you want in the output sheet.
- 5Add a second Google Sheets node to append the returned comments to a results tab.
- 6Test the workflow once with a single URL to confirm credentials and column mapping.
How to customize this workflow
- →Switch the Manual Trigger to a Schedule Trigger for daily or weekly runs.
- →Add a filter after the HTTP node to skip comments shorter than a chosen length.
- →Insert a Set node to clean or enrich comment data before writing to Sheets.
- →Extend the HTTP Request pagination loop to fetch all pages of comments instead of the first page only.
Extract and Store YouTube Video Comments in Google Sheets: pros & cons
Pros
- +Uses only built-in Google Sheets and HTTP Request nodes
- +No paid n8n nodes required
- +Directly populates a spreadsheet ready for further analysis
- +Easy to understand for beginners
Cons
- –Requires a valid YouTube Data API key
- –Starts only on manual execution by default
- –Does not handle nested replies without extra nodes
Frequently asked questions
It reads YouTube video URLs from a Google Sheet, calls the YouTube API via HTTP Request to fetch comments, and writes the results back into another sheet tab.
User reviews
Verified reviews from the community shape this listing's rating.
Loading reviews…
Similar workflows
Other marketing automations worth a look.