YouTube lead generation: Turn comments into enriched prospects with Apify and Gemini AI
Ready for 3.0What this workflow does
This AI workflow has 19 nodes and runs on a schedule (every hour) (plus 3 other triggers). Along the way it connects Google Sheets, OpenRouter Chat Model and HTTP Request. It also calls api.apify.com and google.serper.dev over HTTP.
How it runs
Trigger: On a schedule (every hour) (plus 3 other triggers).
- Get rvideo urls (Google Sheets): uses Google Sheets
- Code: runs custom JavaScript code
- AI Agent: runs an AI agent, with model: OpenRouter Chat Model; 7 tools (get comments, search google, get url mardown, update result for user…); memory: Simple Memory
- HTTP apify get comments from video (HTTP Request): calls api.apify.com (POST)
- mark video url as scrapped (Google Sheets): update
- Save scrapped comments (Google Sheets): append
Services it uses
HTTP calls to: api.apify.com, google.serper.dev
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 (11)
- Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Http Request Tool
n8n-nodes-base.httpRequestTool - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code
From the author
Automated YouTube Leads: Turn Comments into Enriched Prospects Workflow Overview This cutting-edge n8n workflow is a powerful automation tool designed to revolutionize how businesses and marketers identify and qualify leads directly from YouTube video…