Mine YouTube competitor content ideas with Google Gemini and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 27 nodes and runs on a schedule (every week at 08:00) (plus 1 other trigger). Along the way it connects Google Sheets, Google Gemini Chat Model and Gmail.
How it runs
Trigger: On a schedule (every week at 08:00) (plus 1 other trigger).
- Configure Scan Parameters (Edit Fields (Set)): sets 9 fields: competitorChannelIds, maxVideosPerChannel, maxCandidatesPerRun…
- Read Seen Video IDs from Sheet (Google Sheets): uses Google Sheets
- Split Channel ID List (Code): runs custom JavaScript code
- Batch Process Channels (Loop Over Items (Split in Batches)): loops over the items in batches
- Combine Parsed Video Data (Code): runs custom JavaScript code
- Fetch YouTube Channel RSS (HTTP Request): calls an HTTP API
- Deduplicate and Queue Candidates (Code): runs custom JavaScript code
- Parse Videos from RSS (Code): runs custom JavaScript code
- Check for New Videos (If): checks a condition and branches into true / false
- Split Candidates for Processing (Code): runs custom JavaScript code
…plus 11 more steps. See the full node list below.
Services it uses
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 (12)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - No Operation, do nothing
n8n-nodes-base.noOp - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Gmail
n8n-nodes-base.gmail - n8n Form Trigger
n8n-nodes-base.formTrigger
From the author
Quick overview This workflow runs weekly (or on a form submission) to scan competitor YouTube channels via their RSS feeds, uses Google Gemini to generate and score new content ideas, logs high-scoring ideas to Google Sheets, tracks processed videos to avoid…