n8n Webhook Lead Capture to Google Sheets, Slack & Gmail

Capture website leads with an n8n webhook—then log to Google Sheets, notify Slack, and auto-email confirmations via Gmail

This n8n workflow turns your website form submissions into a streamlined lead-capture pipeline. It receives data through an n8n Webhook, validates and normalizes the fields, appends each lead to Google Sheets, posts a new-lead alert to Slack, and sends an automatic confirmation email to the lead using Gmail—then returns a JSON {"ok": true} response to your form.

What this workflow does

• Receives a POST request from your website form using an n8n webhook trigger.
• Normalizes and validates fields, timestamps the lead, and checks that the email is in a valid format.
• Stops processing if the email is invalid to prevent bad data from being saved or emailed.
• Appends lead details to Google Sheets (for example: received_at, name, email, message, source).
• Notifies your team in Slack with a formatted “new lead” message in a target channel (e.g., #leads).
• Sends an auto-reply confirmation email to the lead via Gmail and returns {"ok": true} to the form.

Use cases

• Collecting leads from landing pages and contacting prospects instantly after form submission.
• SaaS operators capturing demo requests and keeping a live Google Sheets record for reporting.
• Teams using Slack alerts to quickly route and respond to incoming inquiries.

Technical details

• Webhook trigger (receives POST data from your form: name, email, message, optionally source).
• Code for field normalization and formatting, plus email format validation.
• Filter to halt processing when the email is invalid.
• Google Sheets to append rows to your specified spreadsheet.
• Slack to post new-lead notifications.
• Gmail to send confirmation emails (customize subject and message content).
• Includes supporting Sticky Note documentation in the workflow.