Capture website form leads in Google Sheets and send Gmail auto-replies
Go to Workflow
Philipp Primisser
Description
Quick overview
Freelancers and small businesses that collect leads through a website form can capture each submission via a webhook, save valid leads to Google Sheets and send an instant auto-reply email.
How it works
Webhook receives the POST request from the website form.
Normalizes the incoming fields (name, email, phone, message, source) and timestamps the submission.
Validates name/email/message (invalid → HTTP 400 with reasons).
Appends the lead to Google Sheets.
Sends the person a friendly confirmation email within seconds.
Returns HTTP 200 to the form.
Setup
Connect Google Sheets + Gmail (or SMTP) credentials.
Create a sheet with the header row: received_at, name, email, phone, message, source, valid, errors
Paste the webhook URL into your form.
Customize the Gmail auto-reply content (for example, replace YOUR BUSINESS NAME) and subject if needed.
Activate the workflow and configure your form to POST to the production webhook URL for /lead-intake.
Customization
Change the email text in the "Send auto-reply" node; add a Slack/Telegram node for team notification.
Additional info
Tested on n8n 1.97.
This workflow was created by Philipp Primisser and shared publicly on the n8n community template library. n8nFind indexes it for discovery — the workflow remains the property of its original creator.