Qualify inbound leads with OpenAI, Google Sheets and Slack alerts
Ready for 3.0What this workflow does
This AI workflow has 9 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects OpenAI Chat Model, Google Sheets and Slack.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Normalize Lead (Edit Fields (Set)): sets 5 fields: name, email, company…
- AI Lead Scorer (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Prepare Row (Edit Fields (Set)): sets 10 fields: timestamp, name, email…
- Log Lead (Google Sheets) (Google Sheets): append
- Qualified? (If): checks a condition and branches into true / false
- Alert: Hot Lead (Slack) (Slack): post (message)
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack
From the author
Quick Overview This workflow receives lead submissions via a webhook, normalizes the fields, uses OpenAI to score and categorize each lead with a structured JSON output, appends every lead to Google Sheets, and posts an alert to a Slack channel when the lead…