Project Type: Lead Generation & Data Automation

Tech Stack: n8n, OpenAI, Reoon API, WhatsApp Business API, Google Workspace

B2B sales teams often spend hours manually scrubbing messy lead lists, hunting down missing contact info, and drafting cold emails. As an automation agency founder, I am frequently approached by clients drowning in unverified CSV data, resulting in high bounce rates and wasted outreach hours.

To solve this, I designed a sophisticated, 7-stage data intake and enrichment pipeline in n8n. This workflow acts as an automated SDR taking raw, unstructured CSV uploads, cleaning the data, discovering and verifying missing emails, generating personalized outreach via AI, and delivering the finalized lists directly to the client's Google Drive, Sheets, or WhatsApp.

Messy Data: The client regularly purchased raw lead lists with over 100+ different column name variations, making standardization a nightmare.

High Bounce Rates: Sending cold outreach to unverified emails was damaging their domain reputation.

Manual Enrichment: Sales reps were manually opening company websites to find contact details and figure out what the company did so they could write a personalized opening line.

Scattered Delivery: The finished data needed to be routed dynamically depending on the urgency and team preference (some wanted it in Sheets, others wanted a daily WhatsApp digest).

I built a completely automated data engine using n8n that processes leads in parallel and routes them intelligently based on data quality.

The user uploads a CSV/XLSX file via an n8n Web Form. The workflow automatically standardizes the columns, removes duplicates based on website URLs and contact names, and flags invalid domains (like social media links or URL shorteners).

The system analyzes what data is missing and routes the lead accordingly:

Email Scraping: If a valid website exists but no email is provided, the workflow scrapes the company website using regex patterns to extract potential emails.

AI Selection: When multiple emails are found, GPT-5-NANO analyzes the scraped data to select the most relevant business email for the specific contact.

Dual Verification: Every email goes through a strict deliverability and SMTP check using the Reoon API, ensuring 0% bounce rates.

Parallel to the email verification, the workflow scrapes the HTML title tags, meta descriptions, and H1 headers of the target websites. This provides deep context about the company's value proposition without requiring a human to ever visit the site.

Leads are bucketed into Google Sheets based on quality (e.g., +1 Email, +2 Emails, Missing Data). For the verified leads, the workflow feeds the scraped website intelligence, contact name, and job title into GPT or Gemini. The AI generates:

A cleaned, conversational version of the contact's name and company.

Two highly specific, personalized opening lines tailored to the user's custom prompts.

Once processing is complete, the finalized, enriched dataset is automatically delivered based on the client's preference at upload: saved as a timestamped CSV in Google Drive, populated into structured Google Sheets, or sent directly as an XLSX document via the WhatsApp Business API.

Eliminated Manual Data Entry: Saved the sales team an average of 15 hours per week on list scrubbing and email hunting.

Protected Domain Reputation: The dual-verification system caught thousands of invalid/catch-all emails, dropping the client's bounce rate to near zero.

Higher Conversion Rates: The AI-generated personalization (informed by actual scraped website data) resulted in a much warmer, more relevant outreach strategy, doubling their positive reply rate.

Looking to eliminate manual data entry and supercharge your sales team with automated lead enrichment?