Capture Website Leads to Google Sheets + Telegram Alerts

Capture every website lead and instantly alert your team—without duplicates

This n8n workflow receives POSTed website form submissions, normalizes and deduplicates lead data, writes it to your Google Sheets Leads tab, and sends a Telegram notification with different messaging for new vs repeat enquiries.

What this workflow does

• Receives form submissions via webhook: Your website sends a POST request to an n8n webhook; the workflow immediately returns a JSON confirmation response.
• Normalizes lead fields: The workflow standardizes name, phone, email, message, and source, formats phone numbers consistently, and builds a dedupe key from either phone digits or a lowercased email.
• Detects duplicates in Google Sheets: It searches the Google Sheets “Leads” sheet for an existing row matching the dedupe key.
• New lead vs repeat enquiry behavior:
  • If found: updates last_enquiry_at, refreshes message/source, and increments enquiry_count.
  • If not found: appends the normalized lead as a new row.
• Notifies via Telegram: Sends a Telegram message to your specified chat, using one format for new leads and another for repeat enquiries.

Use cases

• Track enquiries from a website contact form directly into Google Sheets without manual exports.
• Automatically update an existing lead when the same phone/email submits again (repeat enquiry handling).
• Send real-time Telegram alerts for sales or support teams to respond faster to fresh and returning prospects.

Technical details (n8n)

• webhook to accept website form POST requests and confirm immediately
• code / if to normalize fields, build dedupe keys, and choose update vs append logic
• google sheets integration to write to the Leads tab with headers: received_at, last_enquiry_at, full_name, phone, dedupe_key, email, message, source, enquiry_count
• telegram node to alert the configured chat (separate messaging for new vs repeat)
• Includes a sticky note for workflow guidance

Ideal for n8n automation engineers and SaaS operators who need reliable lead capture with deduplication and Telegram notifications.