n8n Lead Capture to Google Sheets CRM + WhatsApp & Gmail Alerts

Turn website form leads into instant CRM entries + real-time WhatsApp alerts

This n8n workflow captures POSTed website form submissions via a webhook, validates and normalizes lead data, stores qualified leads in a simple Google Sheets CRM, and immediately notifies your sales team through WhatsApp—with retry logic and escalation via Gmail when something goes wrong.

What this workflow does

• Receives leads via webhook: Accepts a website form POST request at an n8n webhook endpoint.
• Validates and normalizes data: Checks required fields, normalizes the lead payload (including international phone formatting), and flags likely bots using a honeypot field.
• Returns correct responses to the form: Sends a success response for spam, a 400 validation error with per-field details for invalid submissions, or a 500 if validation unexpectedly fails.
• Writes to Google Sheets as a CRM: Appends valid leads into a Google Sheets “Leads” tab and retries on Google Sheets errors using exponential backoff.
• Sends WhatsApp alerts with retries: Builds a WhatsApp message and sends one message per sales recipient, retrying failed sends with backoff. On delivery success, updates Google Sheets (e.g., Alert Status = SENT and Alerted At).
• Escalates failures with Gmail (with WhatsApp fallback): If execution fails or escalation is triggered, sends an incident email via Gmail and falls back to an ops WhatsApp alert if the email notification fails.

Use cases

• SaaS and lead-gen sites that need instant sales notifications from form submissions.
• Teams using a lightweight Google Sheets CRM and needing per-recipient WhatsApp alerts.
• Operators who want reliable operations with retry logic and incident escalation.

Technical details

• Webhook ingestion for incoming form submissions
• Nodes/logic: if, set, wait, gmail, switch, webhook
• Google Sheets lead storage with exponential backoff retries
• WhatsApp fan-out messaging with delivery status updates
• Bot detection via honeypot field and normalized phone handling