🎣 Capture website form leads in Google Sheets and send Gmail auto-replies
⚡ 22 views · 🎣 Lead Generation & Enrichment
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.
🔗 Nodes Used
Google Sheets, Webhook, Gmail
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File