Save website form leads to Google Sheets with Slack alerts and Gmail replies
Go to Workflow
Paul Smithy
Description
Quick Overview
This workflow captures website form submissions via a webhook, validates and normalizes the fields, appends each lead to Google Sheets, notifies a Slack channel, and sends an automatic confirmation email from Gmail.
How it works
Receives a POST request from your website form via an n8n webhook.
Normalizes the submitted fields, timestamps the lead, and validates the email address format.
Stops processing if the email is invalid.
Appends the lead details to a Google Sheets spreadsheet.
Posts a formatted new-lead alert message to a Slack channel.
Sends an auto-reply confirmation email to the lead using Gmail and returns a JSON { "ok": true } response to the form.
Setup
Create a Google Sheet with columns for received_at, name, email, message, and source, then connect Google Sheets credentials and replace YOUR_SHEET_ID with your spreadsheet URL/ID.
Connect Slack credentials and set the target channel (for example, #leads) where notifications should be posted.
Connect Gmail credentials and customize the auto-reply subject and message content (including your sign-off).
Copy the webhook URL from the webhook trigger and configure your form tool/site to send POST requests to it with name, email, message, and optionally source.
This workflow was created by Paul Smithy and shared publicly on the n8n community template library. n8nFind indexes it for discovery — the workflow remains the property of its original creator.