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.