Extract YouTube channel videos to Google Sheets with metadata tracking
Ready for 3.0What this workflow does
This workflow has 15 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
- Loop (Loop Over Items (Split in Batches)): loops over the items in batches
- Switch: routes items into 5 branches
- Wait: waits 0.01 seconds
- Fields - Set Channel ID (Edit Fields (Set)): sets 1 field: channel_id
- Fields - Set Channel Username (Edit Fields (Set)): sets 1 field: channel_username
- HTTP Request: calls googleapis.com
- HTTP Request: calls googleapis.com
- If: checks a condition and branches into true / false
- Fields - Set Channel ID (Edit Fields (Set)): sets 1 field: channel_id
…plus 4 more steps. See the full node list below.
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 (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - Split Out
n8n-nodes-base.splitOut - Switch
n8n-nodes-base.switch - Wait
n8n-nodes-base.wait - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches
From the author
This N8N template demonstrates how to use our tool to collect a list of videos from any YouTube channel - including video URLs, titles, descriptions, thumbnail links, publish dates, and more - all saved cleanly into a connected Google Sheet. Use cases are…