<aside>
Goal: Automate the enrichment of company leads using Apollo and Apify, pulling verified contact data and writing enriched info back into Google Sheets.
Problem: Manually enriching lead lists from conferences or scraped data is time-consuming, inconsistent, and prone to data quality issues.
Solution: A fully automated enrichment pipeline using n8n that:
🔹 Step 1 – Trigger: Manual trigger (When clicking 'Test workflow') starts the process.
🔹 Step 2 – Google Sheets: Fetch only 1 row where Collected is empty (lead not yet enriched).
🔹 Step 3 – Edit Fields: Clean input and extract company and booth ID for tracking.
🔹 Step 4 – Apollo HTTP Request (POST): Search for the organization with filters: marketing title + verified email.
🔹 Step 5 – If Condition: If model_id exists:
➤ Send to Google Sheets1 → update the row with "Collected: Yes"
➤ Then go to Wait to loop back and process the next row.
If model_id does not exist:
➤ Skip enrichment and mark it as "Name Error" (handled separately — this may already be done by the false path).
🔹 Step 6 – Wait (5 mins): Adds a buffer before making the Apify request, to protect against rate limits and pacing issues.
🔹 Step 7 – HTTP Request1 (Apify – GET): Fetches detailed lead data from Apify, including personal emails and marketing contacts for the organization ID.
🔹 Step 8 – Google Sheets2 (Append Contacts): Adds the enriched contact information to a separate sheet — full name, email, title, organization, LinkedIn, etc.
🔹 Step 9 – Google Sheets3 (Mark as Collected): Updates the original row in your main lead sheet to Collected: Yes, preventing duplicates.
🔹 Step 10 – Wait2 (5 mins): Final cooldown period before the loop starts over and processes the next row.
Tools Used:
Impact:
📂 Download & Explore the Workflow:
View GitHub Repository https://github.com/AlvLeoAI/apollo-lead-enrichment-n8n