Skip to content
Dhanasvi
Sign in
YouTube Lead Generation: Turn Comments into Enriched Prospects with Apify and Gemini AI logo

YouTube Lead Generation: Turn Comments into Enriched Prospects with Apify and Gemini AI

Verified

Extract YouTube comments and enrich them into AI-qualified leads via Google Sheets.

n8nAI & LLMIntermediate👁 31 views
Open template
Updated 2026-06-16

What this workflow does

The workflow monitors Google Sheets for YouTube URLs, retrieves comments through HTTP requests, and uses an AI Agent with memory and OpenRouter models to generate enriched prospect profiles.

It is designed for marketers and sales teams seeking to automate lead generation from video engagement without manual data handling.

Who is this for?

Marketing teams, sales development reps, and growth hackers who monitor YouTube channels for leads and need to turn comments into usable prospect data.

What problem it solves

Manually pulling YouTube comments and enriching them into qualified leads is slow and repetitive. This workflow automates scraping via Apify and AI enrichment so teams stop wasting hours on manual data work.

What it automates

Product launch monitoring

Track comments on a new product video and instantly create enriched rows in Google Sheets with job titles and company info for follow-up.

Influencer outreach

Scrape comments on niche videos to identify engaged viewers and use the AI agent to score their interest level before DM outreach.

Competitor comment mining

Pull comments from competitor videos, enrich with contact signals, and feed the data into a CRM or outreach sequence.

How the workflow works

The 6 nodes in this automation, in order.

  1. 1Google SheetsgoogleSheets
  2. 2HTTP RequesthttpRequest
  3. 3Codecode
  4. 4AI Agent@n8n/n8n-nodes-langchain.agent
  5. 5Simple Memory@n8n/n8n-nodes-langchain.memoryBufferWindow
  6. 6OpenRouter Chat Model@n8n/n8n-nodes-langchain.lmChatOpenRouter

Apps & integrations used

Google SheetsHTTP RequestAI AgentSimple MemoryOpenRouter Chat Model

How to set up YouTube Lead Generation: Turn Comments into Enriched Prospects with Apify and Gemini AI

  1. 1Add your YouTube video URLs to the Google Sheets trigger node.
  2. 2Connect the HTTP Request node to the Apify YouTube comments actor.
  3. 3Link the AI Agent node using OpenRouter Chat Model and Simple Memory.
  4. 4Map the scraped comments into the AI Agent prompt for enrichment.
  5. 5Write enriched lead fields back to the Google Sheet and mark the video as processed.
  6. 6Activate the workflow and test with one video URL.

How to customize this workflow

  • →Swap OpenRouter model for Gemini or Claude via the Chat Model node.
  • →Change trigger from Google Sheets to a webhook or scheduled cron.
  • →Add a filter step before the AI Agent to skip short or spam comments.
  • →Extend the workflow with an HTTP Request to push leads into a CRM.

YouTube Lead Generation: Turn Comments into Enriched Prospects with Apify and Gemini AI: pros & cons

Pros

  • +Fully automated comment scraping and enrichment
  • +Uses existing n8n nodes without custom code
  • +Simple Memory keeps context across multiple videos
  • +Direct Google Sheets output for easy handoff

Cons

  • –Requires a paid Apify account for the actor
  • –OpenRouter usage adds per-token costs
  • –No built-in deduplication of repeat commenters
Did you find this helpful?

Frequently asked questions

It watches a Google Sheet for YouTube URLs, scrapes comments with Apify, and uses an AI agent to turn each comment into an enriched lead record.

User reviews

Verified reviews from the community shape this listing's rating.

Loading reviews…

Sign in to review

Promote YouTube Lead Generation: Turn Comments into Enriched Prospects with Apify and Gemini AI

Add this badge to your website, or share the tool.

DFeatured on DhanasviYouTube Lead Generation: Turn Comments into Enriched Prospects with Apify and Gemini AI 0