{"product_id":"n8n-lead-scoring-workflow-openai-hot-alerts-via-telegram","title":"n8n Lead Scoring Workflow: OpenAI HOT Alerts via Telegram","description":"\u003ch3\u003eInstant HOT Lead Alerts in Telegram—Automatically Score Every New Request with OpenAI in n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow receives incoming leads via a \u003cstrong\u003ewebhook\u003c\/strong\u003e, uses \u003cstrong\u003eOpenAI (GPT-4.1-mini)\u003c\/strong\u003e to score and classify them as \u003cstrong\u003eHOT\/WARM\/COLD\u003c\/strong\u003e, logs everything to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends a \u003cstrong\u003eTelegram\u003c\/strong\u003e alert only when the lead is truly HOT—then returns the qualification data in the webhook response.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a new lead\u003c\/strong\u003e via an n8n \u003cem\u003eWebhook\u003c\/em\u003e (POST request).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes incoming fields\u003c\/strong\u003e including \u003cstrong\u003ename, email, company, phone, message, and source\u003c\/strong\u003e, and adds a \u003cstrong\u003etimestamp\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQualifies the lead with OpenAI\u003c\/strong\u003e by generating a JSON result containing:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003escore\u003c\/strong\u003e (0–100)\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003estatus\u003c\/strong\u003e (HOT\/WARM\/COLD)\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003esummary\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003enext action\u003c\/strong\u003e\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and parses the AI output\u003c\/strong\u003e, enforcing a 0–100 score and deriving HOT\/WARM\/COLD when needed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends results to Google Sheets\u003c\/strong\u003e with columns such as \u003cstrong\u003eNAME, EMAIL, COMPANY, PHONE, SOURCE, MESSAGE, SCORE, STATUS, SUMMARY, NEXT_ACTION, CREATED_AT\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a Telegram message only for HOT leads\u003c\/strong\u003e (skips notification for WARM\/COLD).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns a JSON response\u003c\/strong\u003e to the original webhook request with \u003cstrong\u003escore, status, summary, and next action\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eNotify sales immediately when a new inbound form submission is categorized as \u003cstrong\u003eHOT\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eQualify SaaS demo requests or consultation leads and route outreach decisions using \u003cstrong\u003eAI-driven next actions\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eCentralize lead scoring history in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for reporting and team visibility.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e (GPT-4.1-mini) for lead scoring\/classification\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for logging qualifications (sheet columns as specified)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram\u003c\/strong\u003e bot to send formatted alerts (HOT only)\u003c\/li\u003e\n  \u003cli\u003eNodes\/logic used: \u003cstrong\u003ewebhook\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003etelegram\u003c\/strong\u003e, plus \u003cstrong\u003esticky note\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003ePerfect for n8n users, automation engineers, and SaaS operators who want reliable \u003cstrong\u003elead scoring automation\u003c\/strong\u003e with real-time \u003cstrong\u003eTelegram HOT alerts\u003c\/strong\u003e.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46086633193651,"sku":"N8N-19926","price":47.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/KrLJXPqa7WM6cn8y7TxMz_nZcMvrQv.png?v=1790326862","url":"https:\/\/buyflowscripts.com\/products\/n8n-lead-scoring-workflow-openai-hot-alerts-via-telegram","provider":"N8N Commerce","version":"1.0","type":"link"}