G
GTM Vault
Browse
  • Dashboard
    • Automations
    • Skills
    • Prompts
    • Makers
  • Sign in
Loading setup wizard...
Back to YouTube lead generation: Turn comments into enriched prospects with Apify and Gemini AI

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

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.

What This Automation Does
1

Monitor Google Sheets for new YouTube URLs

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

2

Extract comments from YouTube videos

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

3

Retrieve unprocessed comments

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

4

Research comment authors with AI

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

5

Generate enriched lead profiles

Creates comprehensive lead descriptions based on gathered data including emails, social media links, and biographical context.

6

Save leads to Google Sheets

Stores enriched lead profiles in dedicated spreadsheet and marks comments as processed to prevent duplication.

Prerequisites

  • Google Sheets account with YouTube leads spreadsheet
  • Google Cloud API key with Sheets access
  • OpenRouter API key for AI models
  • Apify account with API token
  • Serper API key for Google Search

Services Used

Google SheetsLm Chat Open Router

Services with alternatives — you can swap them in the next step.