{"product_id":"ai-lead-scoring-in-n8n-openai-sheets-slack-alerts","title":"AI Lead Scoring in n8n: OpenAI + Sheets + Slack Alerts","description":"\u003ch3\u003eAI Lead Scoring in n8n — OpenAI, Google Sheets, and Slack Alerts with SLA Escalation\u003c\/h3\u003e\n\u003cp\u003eTurn inbound form submissions into automatically scored sales leads. This n8n workflow uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to score and categorize each lead, logs them to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends \u003cstrong\u003ehot and warm Slack alerts\u003c\/strong\u003e—including an \u003cstrong\u003eSLA-based escalation\u003c\/strong\u003e for hot leads that haven’t been handled.\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 A POST request from your form hits an \u003cstrong\u003en8n webhook\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and identifies:\u003c\/strong\u003e Incoming fields are normalized into a consistent lead structure, with a \u003cstrong\u003elead_id\u003c\/strong\u003e and timestamp generated.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores with OpenAI:\u003c\/strong\u003e The workflow builds a scoring prompt and calls the \u003cstrong\u003eOpenAI Chat Completions API\u003c\/strong\u003e to return a JSON payload containing a \u003cstrong\u003escore\u003c\/strong\u003e, \u003cstrong\u003ereason\u003c\/strong\u003e, \u003cstrong\u003enext step\u003c\/strong\u003e, and \u003cstrong\u003eintent\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies temperature:\u003c\/strong\u003e The response is parsed and assigned as \u003cstrong\u003ehot\u003c\/strong\u003e, \u003cstrong\u003ewarm\u003c\/strong\u003e, or \u003cstrong\u003ecold\/unscored\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs to Google Sheets:\u003c\/strong\u003e Every lead is appended to the \u003cstrong\u003eGoogle Sheets “Leads” tab\u003c\/strong\u003e, including fields such as \u003cstrong\u003elead_id\u003c\/strong\u003e and \u003cstrong\u003ehandled\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies Slack by priority:\u003c\/strong\u003e Hot leads and warm\/unscored leads are posted to your \u003cstrong\u003eSlack sales channel\u003c\/strong\u003e. Cold leads are only logged.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSLA escalation for hot leads:\u003c\/strong\u003e For hot leads, the workflow waits the configured SLA window, re-reads the matching row in Google Sheets, and if \u003cstrong\u003ehandled\u003c\/strong\u003e is still empty, it escalates the lead to a \u003cstrong\u003eSlack manager channel\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams scoring trial\/demo requests instantly and notifying sales with urgency.\u003c\/li\u003e\n  \u003cli\u003eLead routing for forms where intent and next steps vary by request content.\u003c\/li\u003e\n  \u003cli\u003eEnsuring no high-priority lead is missed via Slack SLA escalation.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e OpenAI (Chat Completions), Google Sheets (OAuth2), Slack.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow components:\u003c\/strong\u003e if, set, code, no op, wait, slack.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired setup:\u003c\/strong\u003e Create a Google Sheet with a “Leads” tab and matching columns (including \u003cem\u003elead_id\u003c\/em\u003e and \u003cem\u003ehandled\u003c\/em\u003e), then configure Slack channels and SLA minutes, scoring thresholds, and the OpenAI model in Settings.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46058928505011,"sku":"N8N-19706","price":68.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/XShrIAuAushT9MiySNRh-_senhmbKZ.png?v=1789722117","url":"https:\/\/buyflowscripts.com\/products\/ai-lead-scoring-in-n8n-openai-sheets-slack-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}