{"product_id":"capture-website-leads-to-google-sheets-telegram-alerts","title":"Capture Website Leads to Google Sheets + Telegram Alerts","description":"\u003ch3\u003eCapture every website lead and instantly alert your team—without duplicates\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow receives POSTed website form submissions, normalizes and deduplicates lead data, writes it to your Google Sheets \u003cem\u003eLeads\u003c\/em\u003e tab, and sends a Telegram notification with different messaging for new vs repeat enquiries.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives form submissions via webhook:\u003c\/strong\u003e Your website sends a POST request to an n8n webhook; the workflow immediately returns a JSON confirmation response.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes lead fields:\u003c\/strong\u003e The workflow standardizes \u003cem\u003ename, phone, email, message, and source\u003c\/em\u003e, formats phone numbers consistently, and builds a \u003cstrong\u003ededupe key\u003c\/strong\u003e from either phone digits or a lowercased email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects duplicates in Google Sheets:\u003c\/strong\u003e It searches the Google Sheets “Leads” sheet for an existing row matching the dedupe key.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNew lead vs repeat enquiry behavior:\u003c\/strong\u003e\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eIf found:\u003c\/strong\u003e updates \u003cem\u003elast_enquiry_at\u003c\/em\u003e, refreshes \u003cem\u003emessage\/source\u003c\/em\u003e, and increments \u003cem\u003eenquiry_count\u003c\/em\u003e.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eIf not found:\u003c\/strong\u003e appends the normalized lead as a new row.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies via Telegram:\u003c\/strong\u003e Sends a Telegram message to your specified chat, using one format for new leads and another for repeat enquiries.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack enquiries from a website contact form directly into Google Sheets without manual exports.\u003c\/li\u003e\n  \u003cli\u003eAutomatically update an existing lead when the same phone\/email submits again (repeat enquiry handling).\u003c\/li\u003e\n  \u003cli\u003eSend real-time Telegram alerts for sales or support teams to respond faster to fresh and returning prospects.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details (n8n)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003ewebhook\u003c\/strong\u003e to accept website form POST requests and confirm immediately\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ecode \/ if\u003c\/strong\u003e to normalize fields, build dedupe keys, and choose update vs append logic\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003egoogle sheets\u003c\/strong\u003e integration to write to the \u003cstrong\u003eLeads\u003c\/strong\u003e tab with headers: \u003cem\u003ereceived_at, last_enquiry_at, full_name, phone, dedupe_key, email, message, source, enquiry_count\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003etelegram\u003c\/strong\u003e node to alert the configured chat (separate messaging for new vs repeat)\u003c\/li\u003e\n  \u003cli\u003eIncludes a \u003cstrong\u003esticky note\u003c\/strong\u003e for workflow guidance\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eIdeal for n8n automation engineers and SaaS operators who need reliable lead capture with deduplication and Telegram notifications.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45741405110451,"sku":"N8N-17618","price":62.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ssIZO8xUfELeT3hvIp_nI_eV026YkQ.png?v=1785315760","url":"https:\/\/buyflowscripts.com\/products\/capture-website-leads-to-google-sheets-telegram-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}