Скачать или смотреть Automate B2B Lead Lists with Apollo.io + Apify in n8n

⚡Accelerate Your Automation & AI Agent Building⚡
https://www.skool.com/ai-builds-you-s...

🔥 FREE Skool community N8N and SEO!🔥
https://www.skool.com/ai-automation-lab

In this video, I show how to build a B2B lead list generator that pulls people data from Apollo.io (via a filtered search URL) and automates scraping with Apify—then cleans and saves everything to Google Sheets. Perfect if your ICP lives on LinkedIn and you need verified emails, titles, phone, and location at scale.

What you’ll learn
1. Why/when to use Apollo.io vs Google Business Profile for lead gen
2. How to build a filter URL in Apollo (without the broken “activation” URLs)
3. Running Apify via API (why you need the paid plan + cost math)
4. Setting minimum records (500) and handling pagination
5. n8n flow: Run → Wait/Repoll → Status Check (LLM) → Parse → Append to Sheets
6. Google Sheet schema (ID, name, LinkedIn URL, title, headline, email, phone, city/state/country)
7. Scaling tips: weekly scheduler, page offsets, and cost control
8. Tooling & costs (at time of recording)
9. Apollo.io (free plan OK for building the filter URL)
10. Apify (paid needed for API; ~$1.20 per 1k scraped records)
11. n8n for orchestration
12. Google Sheets as the simple data store

🔎 Key Takeaways
1. Use Apollo when your ICP is on LinkedIn; use GBP for local businesses.
2. In Apollo, refresh the page before copying the URL (avoid “activation” in the link).
3. Apify API requires paid plan and min 500 records per run.
4. Add a repoll loop and an LLM status checker to reliably detect success/failure.
5. Keep a tidy Sheet schema; include a unique ID for future joins & dedupe.

⏱️ Timestamps
0:00 Intro & when Apollo beats Google Business Profile
0:46 Tools overview: Apollo, Apify, n8n, Google Sheets
1:18 Building the Apollo filter (titles, location, company size, verified emails)
2:12 The correct Apollo URL (avoid “activation”)
2:44 Cost + plan notes: why Apify paid is required
3:31 Google Sheet schema (columns you’ll want)
4:41 n8n flow overview (params, run, wait/repoll, status check, append)
6:14 Apify run: payload, minRecords=500, looping until success
7:49 LLM status checker: interpreting “succeeded” vs. manual review
9:10 Writing results to Sheets (clean vs. full output)
10:14 Pagination & scaling (page offsets, weekly schedule)
11:24 Wrap-up & next steps

#LeadGeneration #Apollo #Apify #n8n #B2BMarketing #SalesAutomation #LinkedInLeads #GrowthOps #GoogleSheets