{"product_id":"telegram-lead-capture-postgres-crm-with-n8n-groq","title":"Telegram Lead Capture \u0026 Postgres CRM with n8n \u0026 Groq","description":"\u003ch3\u003eTurn Telegram messages into a structured CRM lead—instantly\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures leads from \u003cstrong\u003eTelegram\u003c\/strong\u003e (voice notes, typed lines, or business-card photos), uses \u003cstrong\u003eGroq\u003c\/strong\u003e AI to extract structured details, checks \u003cstrong\u003ePostgres\u003c\/strong\u003e for duplicates, and sends one-tap confirmation buttons back in Telegram. A daily 8:30 digest then surfaces who needs follow-up.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives lead input\u003c\/strong\u003e from incoming Telegram messages or button taps, and also runs on a \u003cstrong\u003edaily 08:30 cron\u003c\/strong\u003e to generate follow-up digests and clean up expired pending confirmations.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates the sender\u003c\/strong\u003e against an allowed chat ID list; unauthorized senders receive a reply containing the chat ID.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConverts the input into text\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eTranscribes \u003cstrong\u003eTelegram voice notes\u003c\/strong\u003e with \u003cstrong\u003eGroq Whisper\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003eReads \u003cstrong\u003ebusiness-card images\u003c\/strong\u003e with \u003cstrong\u003eGroq Vision\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003eUses \u003cstrong\u003etyped messages as-is\u003c\/strong\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts lead fields\u003c\/strong\u003e using \u003cstrong\u003eGroq Chat Completions\u003c\/strong\u003e, including contact, company, need, budget, urgency, follow-up date, and stage update—then validates\/normalizes the result.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicates in Postgres\u003c\/strong\u003e by searching for up to \u003cstrong\u003ethree likely matching leads\u003c\/strong\u003e and sending a Telegram confirmation message with inline buttons to:\n    \u003cul\u003e\n      \u003cli\u003eupdate an existing lead\u003c\/li\u003e\n      \u003cli\u003esave a new lead\u003c\/li\u003e\n      \u003cli\u003ecancel\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOn button tap\u003c\/strong\u003e, claims the pending note from \u003cstrong\u003ePostgres\u003c\/strong\u003e, creates\/updates the lead, and replies with saved lead status, stage, score, and follow-up date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns \/today and the scheduled digest\u003c\/strong\u003e to query Postgres for due\/overdue follow-ups and cold leads, then sends a formatted summary to Telegram.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCapture sales\/partnership leads from real conversations you record as voice notes.\u003c\/li\u003e\n  \u003cli\u003eBatch-process networking contacts from business-card photos into a Postgres-backed CRM.\u003c\/li\u003e\n  \u003cli\u003eDaily follow-up reminders delivered automatically via Telegram.\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 Telegram, Postgres, Groq (Whisper, Vision, Chat Completions), plus n8n logic nodes such as \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eno op\u003c\/strong\u003e, and \u003cstrong\u003epostgres\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore workflow:\u003c\/strong\u003e normalize Telegram updates → AI extract lead data → Postgres duplicate match (top 3) → inline confirmation → CRM write-back.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46236462612659,"sku":"N8N-21014","price":16.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/EkdlP12cJmNyCd3zWRh5w_0bLO3k1P.png?v=1792227789","url":"https:\/\/buyflowscripts.com\/products\/telegram-lead-capture-postgres-crm-with-n8n-groq","provider":"N8N Commerce","version":"1.0","type":"link"}