Extract and store YouTube video comments in Google Sheets
Ready for 3.0What this workflow does
This workflow has 11 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls googleapis.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Google Sheets: uses Google Sheets
- If: checks a condition and branches into true / false
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- HTTP Request: calls googleapis.com
- If: checks a condition and branches into true / false
- Split Out: splits a list into separate items
- Google Sheets: update
- If: checks a condition and branches into true / false
- Google Sheets: append or update
- Google Sheets: update
Services it uses
HTTP calls to: googleapis.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Split Out
n8n-nodes-base.splitOut - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - Manual Trigger
n8n-nodes-base.manualTrigger
From the author
This n8n template demonstrates how to use the tool to crawl comments from a YouTube video and simply get all the results in a linked Google Sheet. Use cases are many: Whether you're a YouTube creator trying to understand your audience, a marketer running…