Capture Website Leads to Google Sheets via Webhook Validation

Capture every website lead and save it automatically to Google Sheets—validated first via a webhook

This n8n workflow receives lead submissions from your website (or any tool that POSTs JSON), validates that the lead has a name, and then appends each valid inquiry to your Google Sheets—no manual copy-paste and no lost submissions.

What this workflow does

• Receives leads via Webhook: Your form (or lead source) sends JSON to the workflow’s webhook URL.
• Centralized setup with CONFIG: All key settings (Google Sheet ID, tab name, and business name) are maintained in a single CONFIG node.
• Prepares & validates incoming data: The Prepare Lead step merges incoming fields with your configuration, then an Has Name? filter removes rows where no name is provided.
• Saves to Google Sheets: For each valid lead, the Save Lead to Sheets node appends a new row including timestamp and a status of new.
• Doesn’t hide invalid leads: Instead of silently failing, invalid submissions are logged so you can review data quality.
• Test before going live: A Manual Trigger lets you test end-to-end and confirm a row is created prior to connecting your real form.

Use cases

• Agencies capturing leads from landing page forms and storing them in one shared Google Sheet.
• Freelancers routing “Contact Us” submissions into a spreadsheet for quick follow-up.
• SaaS operators validating incoming form data so incomplete inquiries don’t pollute reporting.

Technical details

• Integrations: n8n Webhook + Google Sheets via Google OAuth2.
• Nodes/tools used: IF, Set, Code, Webhook, Sticky Note, Google Sheets, Manual Trigger.

Requirements: n8n (self-hosted or cloud) and a Google account for Google Sheets OAuth2.

Set up your Sheet header as: name, email, phone, source, status, created_at, then paste the workflow’s Production Webhook URL into your form.