Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

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

  1. Form webhook
  2. Clean & validate
  3. Valid email?
  4. Save lead
  5. Ping Slack
  6. Auto-reply
  7. Respond OK

Similar automations