{"product_id":"n8n-lead-scoring-auto-reply-gpt-4o-mini-gmail-sheets","title":"n8n Lead Scoring \u0026 Auto Reply: GPT-4o-mini + Gmail + Sheets","description":"\u003ch3\u003eTurn inbound leads into scored, prioritized conversations—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow accepts leads from your form via a webhook, uses \u003cstrong\u003eOpenAI GPT-4o-mini\u003c\/strong\u003e to score intent and draft responses, then routes \u003cstrong\u003eHot leads to Gmail + Telegram alerts\u003c\/strong\u003e while logging everything in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—including a \u003cstrong\u003eweekly Monday Telegram digest\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives leads via webhook:\u003c\/strong\u003e Accepts a POST request from your form, normalizes the incoming fields (e.g., name, email, message) and immediately returns a JSON acknowledgment.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters spam and invalid submissions:\u003c\/strong\u003e Discards empty submissions and likely spam using \u003cstrong\u003eemail validation\u003c\/strong\u003e, \u003cstrong\u003edisposable-domain checks\u003c\/strong\u003e, a \u003cstrong\u003ehoneypot field\u003c\/strong\u003e, and a \u003cstrong\u003erequired message\u003c\/strong\u003e rule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI lead scoring + reply drafting (GPT-4o-mini):\u003c\/strong\u003e Sends cleaned lead data to GPT-4o-mini to score \u003cstrong\u003ebudget\u003c\/strong\u003e, \u003cstrong\u003eauthority\u003c\/strong\u003e, \u003cstrong\u003eneed\u003c\/strong\u003e, and \u003cstrong\u003etimeline\u003c\/strong\u003e against a structured JSON schema. The workflow also generates a summary, reasons, language code, and a suggested reply.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates a transparent 0–100 score:\u003c\/strong\u003e Combines AI sub-scores, then adds bonus points for a \u003cstrong\u003ebusiness email domain\u003c\/strong\u003e and a \u003cstrong\u003eprovided phone number\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes by tier:\u003c\/strong\u003e Hot (≥70), Warm (40–69), Cold (\u0026lt;40). Every lead is logged to Google Sheets (“Leads” tab) with tier, score, summary, reasons, and next steps.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAuto follow-up with Gmail and Telegram:\u003c\/strong\u003e Hot leads trigger a \u003cstrong\u003eGmail alert + Telegram message\u003c\/strong\u003e and create a \u003cstrong\u003eGmail draft\u003c\/strong\u003e reply to the lead. Warm leads create only the Gmail draft reply.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eError handling:\u003c\/strong\u003e If AI scoring fails, tier is set to \u003cstrong\u003eReview\u003c\/strong\u003e, the lead is appended to Google Sheets, and a Telegram alert includes error details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly digest:\u003c\/strong\u003e Every \u003cstrong\u003eMonday at 9:00\u003c\/strong\u003e, it reads recent leads (last 7 days) and sends a Telegram digest from the sheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators needing automated lead qualification and prioritized outreach\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building GPT-powered lead scoring with Gmail drafts and Telegram notifications\u003c\/li\u003e\n  \u003cli\u003eTeams wanting a single source of truth in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e with weekly performance visibility\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, set, code, filter, switch, gmail\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI:\u003c\/strong\u003e OpenAI GPT-4o-mini for lead scoring and suggested reply\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStorage \u0026amp; reporting:\u003c\/strong\u003e Google Sheets “Leads” tab + weekly Telegram digest\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45950302716083,"sku":"N8N-19115","price":27.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/SAmAc0DKsWU9QQTd6LFSk_nhmP7BYL.png?v=1788514478","url":"https:\/\/buyflowscripts.com\/products\/n8n-lead-scoring-auto-reply-gpt-4o-mini-gmail-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}