Library / Lead Generation & Enrichment
Lead Generation & Enrichment
Save form leads to Google Sheets, alert Slack and auto-reply via Gmail
Runs on each website form webhook, validates the name and email, appends valid leads to Google Sheets, posts them to Slack and sends an automatic reply by Gmail.
What it does
## Save website form leads to Google Sheets, alert Slack and auto-reply with Gmail ### Who is this for Small businesses, consultants and agencies who want every website enquiry captured, shared with the team and answered within seconds. ### How it works 1. Form webhook receives a POST with name, email, message (and optional source). 2. Clean & validate trims fields and checks the email format. 3. Valid email? drops submissions with a bad email. 4. Save lead appends the lead to your Google Sheet. 5. Ping Slack posts the lead to your channel. 6. Auto-reply emails the lead a thank-you from your Gmail. 7. Respond OK returns a success response to the form. ### How to set up 1. Create a Google Sheet with columns: received_at, name, email, message, source. 2. Attach credentials to Save lead (Google Sheets), Ping Slack (Slack) and Auto-reply (Gmail). 3. Paste your sheet URL and set your Slack channel. 4. Edit the auto-reply text and sign-off. 5. Point your form (Webflow, WordPress, Tally, HTML) at the webhook Test URL, send a test, then activate and switch to the Production URL. ### What you need n8n (Cloud or self-hosted), Google Sheets, Gmail and a Slack workspace. No paid apps. ### How to customise Add lead scoring in Clean & validate, route by source with a Switch node, or replace Slack with Telegram or Microsoft Teams.
The steps
- Form webhook
- Clean & validate
- Valid email?
- Save lead
- Ping Slack
- Auto-reply
- Respond OK
Similar automations
Lead Generation & EnrichmentScore inbound leads with AI, reply by SMS or WhatsApp, alert sales in Slack32 stepsLead Generation & EnrichmentFind websiteless local businesses via Apify and save leads to Google Sheets14 stepsLead Generation & EnrichmentEmail Alert for Great Leads Using MadKudu and Hunter8 stepsEmail AutomationQualify and reply to form leads using OpenRouter, Gmail, and Google Sheets10 steps