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:

Reads unprocessed rows

Queries Apollo for organization + verified marketing contacts

Scrapes extra data via Apify

Logs full info in a separate sheet

Tracks processing status and skips duplicates

n8n – Orchestrates the full automation workflow

Google Sheets – Stores and updates lead lists

Apollo API – Searches companies and verified contacts

Apify – Scrapes personal email and social data

JavaScript Expressions – Dynamic filtering and logic within n8n

Automated a manual lead enrichment process, saving hours of repetitive work

Targeted only verified marketing contacts, improving lead quality

Enabled strategic outbound targeting for events and conferences

Prevented duplicate processing and reduced API errors through dynamic checks and wait nodes