Qualify CSV leads, enrich emails, and deliver results with Google Sheets, Drive, WhatsApp, and GPT-5-NANO

This automated n8n workflow transforms raw CSV data into qualified, enriched lead databases with verified emails and AI-generated personalization. It processes uploaded CSV files through multiple validation, enrichment, and sorting stages before delivering organized results via Google Drive, WhatsApp, or Google Sheets.

How It Works

Stage 1: Data Intake & Normalization

1. Form Submission: User uploads a CSV/XLSX file and selects:

• Delivery method (Google Drive, WhatsApp, or Google Sheets with processing)
• Two personalization prompts for AI-generated messages

1. Column Mapping: The workflow automatically recognizes and standardizes 100+ column name variations into consistent fields
2. Deduplication: Removes duplicate entries by website URL and contact name
3. Initial Filtering: Identifies and flags invalid websites (social media profiles, link shorteners)

Stage 2: Data Quality Routing

The workflow analyzes each record and routes it based on available data:

Route A: Invalid Website → Sends directly to "x Website" sheet

Route B: No Website → Verifies existing email and categorizes by validity

Route C: Valid Website + Email → Proceeds to email verification and enrichment

Route D: Valid Website - Email → Scrapes website to find email addresses.

Stage 3: Email Discovery & Verification

For records needing enrichment:

1. Website Scraping: Fetches HTML content from company websites
2. Email Extraction: Uses regex patterns to identify email addresses
3. AI Selection: GPT-5-NANO chooses the most relevant email from multiple options
4. Dual Verification:

• Primary check via Reoon API (deliverability, SMTP, safety)
• Backup verification if primary fails

1. Personal Email Processing: Separately validates personal emails when present

Stage 4: Website Intelligence Gathering

Parallel to email processing:

• Extracts HTML title tags for company context
• Captures meta descriptions for business understanding
• Pulls H1 headings for content insight
• Handles scraping failures gracefully with empty placeholders

Stage 5: Email Categorization Logic

Records are sorted into buckets:

• +1 Email: Has exactly one verified email (business OR personal OR newly found)
• +2 Email: Has two or more verified emails
• Single Source Records: Only business email OR only personal email

Stage 6: AI Personalization

For records with verified emails:

1. Context Assembly: Combines name, company, job title, website metadata, industry, keywords
2. AI Processing: Sends to GPT-5-NANO or Gemini with user's custom prompts
3. Structured Output: Generates:

• Cleaned contact name
• Shortened company name
• Personalization message 1 (per user prompt)
• Personalization message 2 (per user prompt)

Stage 7: Final Delivery

Based on user's initial selection:

• Google Drive: Uploads timestamped CSV, sends email with link
• WhatsApp: Converts to XLSX and sends document
• Google Sheets: Populates separate sheets by category with completion email

---

How To Use

• Active n8n instance with required credentials:
• Google Drive API access
• Google Sheets API access
• Gmail API access (for notifications)
• WhatsApp Business API credentials
• Reoon Email Verifier API keys
• OpenAI API key (GPT-5-NANO)
• Optional: Google Gemini API key

Setup Steps

1. Configure Google Sheets Destinations

Create or use existing Google Sheets for data categorization:

• +1 Email Sheet: Update document ID in "+1 Email" node
• +2 Email Sheet: Update document ID in "+2 Email" node
• x Website Sheet: Update document ID in "x Website Data" node
• No Website Sheet: Update document ID in "- Website +- Email +- Phone Number" node

Ensure all sheets have matching column headers as defined in the workflow.

2. Set Up Google Drive Folder

• Create a destination folder in Google Drive
• Update the folder ID in the "Upload file" node
• Ensure the service account has write permissions

3. Configure WhatsApp

• Add your WhatsApp Business Phone Number ID in the "Send CSV" node
• Update the recipient phone number (format: +[country code][number])

4. Customize Email Notifications

• Update sender and recipient emails in "Send a message" and "Send a Success Message" nodes
• Modify email templates as needed

5. Verify API Keys

Check that all API credentials are active:

• Reoon Email Verifier keys (two instances for redundancy)
• OpenAI API key for GPT-5-NANO
• All Google API credentials