Automate and turn YouTube comments into LinkedIn leads

n8n runs the entire workflow – it schedules tasks, passes data between tools, and keeps everything moving. Here’s how it works step by step:

1. Schedule your workflow (trigger node)

• Use the Schedule Trigger node to define how often the workflow runs: daily, every few days, or weekly.
• This way, new comments on your videos are captured automatically.
• n8n checks your video list and triggers the entire process without manual effort.

2. Fetch video URLs (Google Sheets node)

• Use a Google Sheets node to read your list of video URLs or IDs.
• This acts as the input list for the workflow: each URL is sent to Apify to fetch comments.
• You can track multiple videos at once, making the system scalable.

3. Collect comments (Apify – YouTube comments collector)

• Add the Apify YouTube Comments collector node.
• Input: video URLs from the previous step.
• Output includes:
  • Comment text
  • Author username
  • Date posted
  • Reply and vote counts
• This step turns raw comments into actionable leads.

4. Enrich commenter profiles (Apify – YouTube profile collector)

• Use the Apify YouTube Profile collector node to gather social links:
  • LinkedIn, X/Twitter, Threads, Instagram, Facebook
  • Websites and other public metadata
• Each commenter becomes a fully enriched prospect, not just a username.

5. Parse links (code node)

• Add a Code node called “Parse Links” to organize all collected links.
• The node:
  • Loops through profile links
  • Detects the platform (LinkedIn, X, Threads, Instagram, Facebook)
  • Stores them in separate fields for easier filtering
• LinkedIn URLs are prepared for the next step, and the data is structured.

6. Store and update commenter data (Google Sheets node)

• Use another Google Sheets node to save processed commenter data.
• Key settings:
  • Append or update row mode: checks if a commenter already exists using the YouTube profile ID
  • Updates existing rows or adds new ones without duplicates
  • Keeps columns for video URL, comment text, LinkedIn, X, Threads, Instagram, Facebook, etc.
• Outcome: a growing database of engaged prospects, ready for outreach.

7. Filter LinkedIn-ready leads (filter node)

• Add a Filter node after parsing links.
• Condition: only pass profiles where the LinkedIn field has a value.
• Result: only qualified leads with LinkedIn URLs move forward to outreach.
• Keeps the workflow organized and prevents errors later.

8. Push leads to HeyReach (HeyReach node)

• Connect a HeyReach node to automatically add filtered leads to your LinkedIn campaign.
• Map the LinkedIn URL from the workflow to the HeyReach profile field.
• Optional: add AI personalization to tailor connection requests using the comment or video context.
• This step turns engagement into real conversations without manual work.

9. Test your workflow

• Run the workflow manually with a few video URLs.
• Check that:
  • Google Sheets is updated correctly
  • Commenter profiles are enriched and structured
  • Only LinkedIn-ready leads are filtered
  • HeyReach receives the correct profiles
• After confirming it works, set the workflow to run on schedule, so new comments are automatically processed.

Wrapping it up

n8n connects and coordinates the entire process:

• Triggers automatically
• Fetches video URLs
• Collects and enriches comments
• Parses and filters links
• Stores clean data
• Sends LinkedIn-ready leads to HeyReach

Once active, every YouTube comment becomes a potential LinkedIn connection, fully automated and ready to scale.