YouTube lead generation: Turn comments into enriched prospects with Apify and Gemini AI

Automatically scrapes YouTube video comments, enriches commenter profiles with AI research, and organizes qualified leads in Google Sheets.

workflowlead_generation

by Msaid Mohamed el hadion n8n

Nodes

Triggers

Platform

n8n

Tech Stack

Google Sheets

AI Agent

OpenRouter

How It Works

This workflow monitors Google Sheets for YouTube video URLs, extracts all comments using Apify, then uses AI to research comment authors across social media and web sources. Enriched lead profiles with contact details and bios are automatically saved to a dedicated leads spreadsheet.

Monitor Google Sheets for new YouTube URLs

Checks spreadsheet for new YouTube video URLs that need comment extraction and marks videos for processing.

Extract comments from YouTube videos

Uses Apify Actor to scrape all comments from specified YouTube videos and stores raw comment data.

Retrieve unprocessed comments

Fetches comment data that hasn't been researched yet and identifies comment authors for lead enrichment.

Research comment authors with AI

AI agent searches Google and social media platforms to find contact details, bios, and professional information about commenters.

Attached Files

workflow.json