Project Title: Production-Grade n8n Lead

Project Title: Production-Grade n8n Lead Capture & Routing Engine

Project Overview: Most marketing campaigns bleed high-ticket leads due to silent automation failures—unformatted phone numbers, API rate limits, or network timeouts. I engineered this fault-tolerant lead capture pipeline in n8n to guarantee 100% data integrity for incoming web and ad traffic.

The Architecture & Data Flow:

Production Ingress & Handshake: A custom webhook instantly catches payload submissions and holds the HTTP connection open until processing finishes, returning explicit 200 OK or 400 Bad Request signals directly to the frontend form.

Automated Data Sanitation: A javascript logic layer intercepts raw data, strips whitespace, standardizes casing, and normalizes regional phone numbers into strict E.164 international formats before it ever touches a database.

Smart Deduplication Engine: The system queries existing database records in real-time. If a match is found, it updates the engagement timestamp and routes the duplicate to an isolated audit log, preventing CRM pollution without ignoring the prospect.

Multi-Tab Database Sync: Clean traffic is routed into segmented Google Sheets or database tables (Valid Leads, Invalid Leads, Duplicates), ensuring sales reps only see verified data.

Speed-to-Lead Dispatch: Instantly triggers an internal email/Slack alert to the sales team while simultaneously firing a contextual, personalized auto-reply to the prospect.

Decoupled Error Recovery: If any external node fails, an isolated global error-trigger captures the exact n8n execution URL and stack trace, alerting the administrator instantly so no lead is ever silently dropped.

Tech Stack: n8n, JavaScript, REST APIs, Google Sheets API, Postman (for payload stress testing).