Save website form leads to Google Sheets with Slack alerts and Gmail replies

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. An n8n automation workflow template by Paul Smithy.

Community Metrics

Categories

• Automation

Tags

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

Capabilities

• 4 nodes

Information