lead-enrichment-pipeline（铅浓缩管道）

Lead Capture & Tracking Pipeline 🎯

Capture leads from any source, deduplicate by email, score by intent, track in Google Sheets, and notify your team — all automatically via n8n workflows.

Problem

Leads come from multiple sources (website forms, newsletters, strategy calls, product waitlists). Manually entering them into a CRM and following up is error-prone and slow. Hot leads go cold.

This pipeline captures, deduplicates, scores, and routes leads in real-time.

What It Does

1. Capture — Receives leads from webhooks (website forms, landing pages, chatbots)
2. Deduplicate — Checks Google Sheets for existing leads (email match via appendOrUpdate)
3. Score — Basic lead scoring based on source type and engagement signals
4. Store — Appends to Google Sheets with scoring data
5. Notify — Emails team with lead details and suggested next action

Note: This pipeline does not include third-party enrichment integrations (e.g., Clearbit, FullContact). To add enrichment, insert an HTTP Request node between the webhook and the Sheets node in the workflow, calling your preferred enrichment API.

Included Workflows

Architecture

Lead Source (form, chatbot, API)
    │
    ▼
Webhook Endpoint (n8n)
    │
    ├── Validate required fields (name, email)
    ├── Check for duplicates (email match in Sheets)
    │
    ├── IF new lead:
    │   ├── Score lead (source type + available fields)
    │   ├── Append to Google Sheets
    │   └── Send notification email to team
    │
    └── IF existing lead:
        ├── Update engagement count
        └── Log new touchpoint

Required n8n Credentials

You must create these credentials in your n8n instance before importing:

After importing, open each workflow and reconnect the credential nodes to your own credentials.

Configuration Placeholders

Replace these placeholders in the workflow JSON before deploying:

Supported Lead Sources

Google Sheets Schema

Quick Start

1. Prerequisites

• n8n v2.4+ (self-hosted or cloud)
• Google Sheets API credentials (OAuth2)
• SMTP email credentials (Gmail or custom)

2. Create Tracking Sheet

Set up a Google Sheet with the columns above. Enable appendOrUpdate matching on email column to prevent duplicates.

3. Import Workflows

Import the 3 JSON files from the workflows/ directory into n8n. Replace all YOUR_* placeholders with your actual values.

4. Test

curl -X POST https://your-n8n.com/webhook/add-lead-enriched \
  -H "Content-Type: application/json" \
  -d '{
    "name": "John Doe",
    "email": "john@company.com",
    "company": "Acme Inc",
    "source": "website-contact"
  }'

Lead Scoring

Use Cases

1. Freelancers — Track inbound leads from website contact forms
2. Agencies — Multi-source lead capture with team notifications
3. SaaS — Waitlist management with scoring
4. Content creators — Newsletter subscriber tracking with engagement scoring
5. eCommerce — Customer inquiry pipeline

Requirements

• n8n v2.4+ (self-hosted or cloud)
• Google Sheets OAuth2 credentials
• SMTP email credentials