Lead Capture KitTested

Lead Capture → Sheet + Alerts

Website and form enquiries are validated, de-duplicated, saved to a Google Sheet, thanked by email and announced to the team.

Passed two live end-to-end tests on Nov 11, 2026 (new lead, then duplicate). Not published yet.

Flow

Website Form Webhook

Called by Demo Form

Config

Normalize & Validate

Read Existing LeadsGoogle Sheets

Dedupe Check

Append Lead RowGoogle Sheets

Update Lead RowGoogle Sheets

Respond to Website

Thank-you emailGmail

Telegram alertTelegram

Slack alertSlack

Discord alertDiscord

TriggerApp stepLogic stepResult

A visitor submits your website form, or the hosted Demo Form hands the lead over.
Fields are cleaned and mapped, phone numbers normalised, and spam is dropped quietly.
Existing leads are matched by email or phone: a returning lead updates its row instead of adding a new one.
New leads get a thank-you email with a reference number.
The team gets an alert on Telegram, Slack and/or Discord, switched on in one Config node.
Failed alerts are written to an Error Log tab; a Sheets outage triggers the Error Handler workflow.

Trigger: Webhook: Website form POST, or called by another workflow
Apps: Google SheetsGmailTelegramSlackDiscord
Logins needed: Google Sheets (OAuth2), Gmail (OAuth2), Telegram bot, Slack (optional), Discord webhook URL (optional)
Built by: n8n Workflows 2
Last updated: Nov 11, 2026
Status: Tested: passed a real end-to-end test, not published

Copy the sample Sheet (Leads and Error Log tabs).
Import the Error Handler first, then this workflow and the Demo Form.
Create the Google Sheets, Gmail and Telegram credentials in n8n and select them on each node.
Fill in the Config node: Sheet ID, business name, alert chat or channel, alert toggles.
Set Workflow → Settings → Error workflow to the Error Handler.
Deactivate alert nodes you don't use (for example Slack) so n8n doesn't flag a missing credential.

Self-hosted n8n needs its own Google Cloud OAuth client. While that app is in Testing mode, Google tokens expire about every 7 days.