{"product_id":"n8n-lead-qualification-openai-to-slack-google-sheets","title":"n8n Lead Qualification: OpenAI to Slack + Google Sheets","description":"\u003ch3\u003eTurn website inquiries into qualified leads—automatically send hot prospects to Slack and log the rest to Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures new form submissions, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to qualify and summarize each lead, then routes results based on lead quality: \u003cstrong\u003ehot leads go to Slack\u003c\/strong\u003e for fast team response, while \u003cstrong\u003ecold (and any non-hot) leads are appended to Google Sheets\u003c\/strong\u003e for follow-up.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives inquiries\u003c\/strong\u003e from an n8n form trigger with \u003cem\u003ename\u003c\/em\u003e, \u003cem\u003eemail\u003c\/em\u003e, and \u003cem\u003emessage\u003c\/em\u003e fields.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQualifies each submission with OpenAI\u003c\/strong\u003e by classifying it as \u003cem\u003ehot\u003c\/em\u003e, \u003cem\u003ecold\u003c\/em\u003e, or \u003cem\u003espam\u003c\/em\u003e, estimating urgency, summarizing the need, and drafting a suggested first reply.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses and normalizes JSON\u003c\/strong\u003e returned by OpenAI into clean lead properties for downstream routing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes the lead by classification\u003c\/strong\u003e using a switch-based decision step.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends hot leads to Slack\u003c\/strong\u003e including lead details, urgency, and the suggested reply—so your team can act immediately.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends non-hot leads to Google Sheets\u003c\/strong\u003e for later follow-up and pipeline tracking.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitor inbound leads from a website form and instantly alert your sales\/support team in \u003cstrong\u003eSlack\u003c\/strong\u003e when the submission is “hot.”\u003c\/li\u003e\n  \u003cli\u003eAutomatically capture “cold” prospects in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e so nothing falls through the cracks.\u003c\/li\u003e\n  \u003cli\u003eUse AI-generated summaries and a suggested first response to reduce manual lead triage time.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n Form Trigger\u003c\/strong\u003e to receive lead submissions (name, email, message).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e step to classify (hot\/cold\/spam), estimate urgency, summarize needs, and draft a suggested reply.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCode\u003c\/strong\u003e for extracting and normalizing OpenAI JSON into lead properties.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSwitch\u003c\/strong\u003e for routing hot vs non-hot leads.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e integration for hot-lead alerts (destination channel configurable).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e OAuth integration to append cold\/non-hot leads to a selected spreadsheet and sheet.\u003c\/li\u003e\n  \u003cli\u003eIncludes \u003cstrong\u003esticky note\u003c\/strong\u003e nodes for setup\/clarification within the workflow.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup requirements\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAdd an \u003cstrong\u003eOpenAI API credential\u003c\/strong\u003e and confirm the model selection in the lead-classification step.\u003c\/li\u003e\n  \u003cli\u003eConnect \u003cstrong\u003eSlack\u003c\/strong\u003e and set the hot-lead destination channel.\u003c\/li\u003e\n  \u003cli\u003eConnect \u003cstrong\u003eGoogle Sheets OAuth\u003c\/strong\u003e, then choose the spreadsheet and sheet for follow-up logging.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45899943608499,"sku":"N8N-18724","price":5.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/zuYRdDHvNmmjIoeH8BRTd_9b1nGX6x.png?v=1787734907","url":"https:\/\/buyflowscripts.com\/products\/n8n-lead-qualification-openai-to-slack-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}