Capture Website Form Leads to Google Sheets + Gmail Auto-Reply

Capture every website form lead instantly—save to Google Sheets and auto-reply by Gmail

This n8n automation workflow receives your website form submissions, validates the data, stores each lead in Google Sheets, and sends the submitter a fast Gmail auto-reply confirmation—so you never miss an inquiry.

What this workflow does

• Receives a form POST request via a webhook.
• Normalizes incoming fields: name, email, phone, message, source, and adds a timestamp.
• Validates name, email, message. If validation fails, the workflow returns HTTP 400 with reasons.
• Appends the lead to your configured Google Sheets sheet.
• Sends an instant confirmation email to the lead (auto-reply) within seconds using Gmail (or SMTP, as supported in setup).
• Returns HTTP 200 to the form so the user submission flow completes successfully.

Use cases

• Freelancers capturing inquiries from a contact form and wanting immediate confirmation + spreadsheet tracking.
• Small businesses that need a lightweight lead intake system without a full CRM setup.
• SaaS operators routing “contact us” submissions into Google Sheets while sending branded Gmail confirmations.

Technical details

• Webhook endpoint for /lead-intake
• Nodes used: if, code, gmail, webhook, sticky note, google sheets
• Spreadsheet header row: received_at, name, email, phone, message, source, valid, errors
• Tested on: n8n 1.97

Setup & customization

• Connect Google Sheets + Gmail (or SMTP).
• Paste the webhook URL into your form.
• Customize the Gmail auto-reply subject and message (for example, replace YOUR BUSINESS NAME).
• Activate the workflow and configure your form to POST to the production webhook URL for /lead-intake.