Lead Enrichment Pipeline: Leadfeeder to Apollo to Google Sheets

Description

🎯 What This Does

This automation creates a seamless daily pipeline that:
Pulls** yesterday's website visitors from Leadfeeder
Enriches** company data using Apollo.io's powerful database
Delivers** enriched leads to your Google Sheets with smart deduplication
Alerts** your team via Telegram when something needs attention

💡 Why Automate Your Lead Enrichment?

⏰ Reclaim Your Time
Stop the copy-paste busywork.

🎯 Never Miss a Hot Lead
Automatically captures yesterday's visitors and enriches.

🚀 Enable Faster Outreach
Enriched records mean your SDRs can reach out the same day with full context—faster follow-up leads to higher conversion rates.

🛡️ API-Friendly Design
Built-in pagination, rate limiting (40s delay), and smart stop logic prevent API throttling and account issues.

⚡ Perfect For These Teams

📈 Growth Marketers
Maintain a daily pipeline of enriched accounts for targeted campaigns and ABM strategies.

📊 Sales Ops & SDR Managers
Ensure your reps start each day with high-quality, enriched leads in a shared workspace.

🔍 Data & BI Teams
Create a lightweight source-of-truth for lead activity without building complex ETL pipelines.

Workflow Overview
Daily Trigger (9 AM) → Fetch Account → Generate Pages → Retrieve Leads →
Enrich with Apollo → Update Google Sheets → Send Alerts

🕘 Trigger
Runs automatically every day at 9:00 AM server time

📋 Process Flow
Fetch your Leadfeeder Account ID
Generate smart pagination (up to 50 pages with safety cap)
Retrieve yesterday's leads in batches of 100
Split and process individual records
Enrich each company using Apollo's database
Append or update rows in Google Sheets with deduplication

🧠 Smart Logic
Pre-generates page sequences with safety limits
Stops automatically when pages return <100 results
Normalizes website URLs and handles Apollo field fallbacks
Implements intelligent rate limiting to respect API limits

📤 Output
Clean, enriched data in your Google Sheets
Telegram alerts for any workflow errors
Automatic deduplication using ID matching

🚀 Quick Setup Guide

1. Import & Configure
Import the JSON workflow file to your n8n instance

2. Add Your Credentials
Set up these integrations in n8n:
Leadfeeder**: HTTP Header Auth with Bearer token
Apollo**: HTTP Header Auth with API key
Google Sheets**: OAuth2 with edit permissions
Telegram**: Bot Token + Chat ID for alerts

3. Update Sheet Configuration
Replace documentId with your Google Sheets URL or from list
Set correct sheetName (gid) in Google Sheets nodes
Verify column mapping matches your sheet structure

5. Test Your Setup
Run a test with yesterday's date to confirm:
✅ Leads are retrieved from Leadfeeder
✅ Apollo enrichment populates correctly
✅ Rows append/update in Google Sheets
✅ Telegram alerts work for errors

🛠️ Level Up Your Automation

CRM Integration
Push enriched leads directly into HubSpot, Salesforce, or Pipedrive for automatic sequences and follow-up campaigns.

Daily Intelligence Reports
Add Slack or email summaries highlighting high-value accounts by revenue, employee count, or industry vertical.

Smart Routing
Route leads to specific team members based on company size, industry, or geographic location.

Data Flow Structure
Each lead goes through this enrichment pipeline:
Raw Lead: Company name, website, visit data from Leadfeeder
Apollo Enrichment: Industry, size, revenue, contact info, social profiles
Sheet Update: Merged data with smart deduplication and timestamp tracking

Support

Created by: khaisa Studio
Support: Contact for Custom Work
Category: Sales Automation, Lead Generation, Data Enrichment
Tags: lead-generation, leadfeeder, apollo, google-sheets, lead-enrichment, sales-automation