{"product_id":"whatsapp-lead-routing-with-n8n-google-sheets-telegram","title":"WhatsApp Lead Routing with n8n, Google Sheets \u0026 Telegram","description":"\u003ch3\u003eInstantly route WhatsApp leads to Telegram—with Google Sheets tracking and AI qualification in n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow receives incoming WhatsApp messages from Evolution API, saves and deduplicates leads in Google Sheets, and automatically alerts your team in Telegram when a message is actionable—using keyword rules and Google Gemini AI lead classification.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives WhatsApp events via webhook\u003c\/strong\u003e by handling a POST webhook call from Evolution API for each incoming WhatsApp message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes message data\u003c\/strong\u003e to extract contact details, message text, and optional latitude\/longitude.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSkips non-relevant chats\u003c\/strong\u003e by ignoring group\/broadcast chats and messages sent by the connected WhatsApp account.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates by WhatsApp message ID\u003c\/strong\u003e using n8n workflow static data, logging skipped duplicates for clean operations.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts into Google Sheets\u003c\/strong\u003e by writing\/updating each contact in the \u003cem\u003eLeads\u003c\/em\u003e worksheet using the contact identifier as the match key, including the latest message details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects location pins \/ map links\u003c\/strong\u003e and sends a Telegram alert containing the Google Maps URL and message context.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes actionable leads intelligently\u003c\/strong\u003e with:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eKeyword rules\u003c\/strong\u003e to immediately alert Telegram for direct visit\/measurement\/contract-style signals and ignore non-actionable greetings or price-only messages.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini AI classification\u003c\/strong\u003e to qualify relevant inquiries via a JSON-based response. Telegram is alerted only for AI-qualified hot leads; otherwise results are logged or handled conservatively via fallback keyword logic.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReal estate or field services: route WhatsApp location shares and visit\/measurement\/contract intent to Telegram fast.\u003c\/li\u003e\n  \u003cli\u003eSales teams: track every lead and its latest message in Google Sheets while notifying Telegram for “hot” opportunities.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers: build a reliable WhatsApp-to-CRM routing flow with deduplication and AI-based lead scoring.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations \/ nodes:\u003c\/strong\u003e Webhook (Evolution API), IF, Code, Google Sheets, Telegram.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore logic:\u003c\/strong\u003e payload normalization, group\/broadcast filtering, static-data deduplication, Google Sheets upsert by contact identifier, Telegram alerts, and Google Gemini AI JSON classification.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46326518317235,"sku":"N8N-21844","price":43.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/TeViI2a4uJe4dAV5giTyk_gVCt1d5E.png?v=1793350999","url":"https:\/\/buyflowscripts.com\/products\/whatsapp-lead-routing-with-n8n-google-sheets-telegram","provider":"N8N Commerce","version":"1.0","type":"link"}