Capture website form leads in Google Sheets and send Gmail auto-replies

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. An n8n automation workflow template by Philipp Primisser.

Community Metrics

Categories

• Automation

Tags

• n8n
• workflow
• google-sheets
• gmail
• code

Capabilities

• 3 nodes

Information