This workflow corresponds to n8n.io template #13746 — we link there as the canonical source.
This workflow follows the Airtable → OpenAI recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "l6zve788hmIguUgf",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "AI-Powered Hybrid Lead Scoring with Sales ALerts",
"tags": [
{
"id": "MEeQUEFhxM5YOMNn",
"name": "lead scoring",
"createdAt": "2026-02-27T07:29:21.755Z",
"updatedAt": "2026-02-27T07:29:21.755Z"
},
{
"id": "L5El8MyzNzdVBJAP",
"name": "sales automation",
"createdAt": "2026-02-27T07:29:42.633Z",
"updatedAt": "2026-02-27T07:29:42.633Z"
},
{
"id": "d19lkWgLXhr6YFw8",
"name": "CRM automation",
"createdAt": "2026-02-27T07:30:18.275Z",
"updatedAt": "2026-02-27T07:30:18.275Z"
},
{
"id": "0zERJEGDfj3aK2ld",
"name": "sales workflow",
"createdAt": "2026-02-27T07:30:32.671Z",
"updatedAt": "2026-02-27T07:30:32.671Z"
},
{
"id": "65eTTDaOWqswtml9",
"name": "sales pipeline",
"createdAt": "2026-02-27T07:30:51.426Z",
"updatedAt": "2026-02-27T07:30:51.426Z"
},
{
"id": "xaTW1lbhOD9IcGcJ",
"name": "lead qualification",
"createdAt": "2026-02-27T07:31:04.799Z",
"updatedAt": "2026-02-27T07:31:04.799Z"
}
],
"nodes": [
{
"id": "d14041b6-d191-4a69-ad19-f647aad42cdb",
"name": "Trigger: New Lead Created",
"type": "n8n-nodes-base.airtableTrigger",
"position": [
-144,
-320
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5a2add48-cba8-4fb1-af26-7e4ec33e5685",
"name": "Normalize & Standardize Lead Data",
"type": "n8n-nodes-base.set",
"position": [
96,
-320
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "b5d33a59-816f-4175-8f95-95a31e1fe3d7",
"name": "Guard: Skip Already Processed Leads",
"type": "n8n-nodes-base.if",
"position": [
304,
-320
],
"parameters": {},
"typeVersion": 2.3
},
{
"id": "7c6d0b48-e983-4eb8-9058-5763ec0f5f3c",
"name": "Exit: Already Processed",
"type": "n8n-nodes-base.noOp",
"position": [
528,
-32
],
"parameters": {},
"typeVersion": 1
},
{
"id": "eb40b73a-8fde-4bc2-ae12-1503fcf39338",
"name": "Prepare AI Scoring Context",
"type": "n8n-nodes-base.set",
"position": [
544,
-336
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "1be3882d-08cc-4a70-8063-bd385752c9f0",
"name": "AI Lead Qualification (GPT)",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
800,
-336
],
"parameters": {},
"typeVersion": 2,
"alwaysOutputData": false
},
{
"id": "7c68db5a-c1e9-44d6-989d-498fb5105363",
"name": "Validate & Parse AI Response",
"type": "n8n-nodes-base.code",
"position": [
1136,
-336
],
"parameters": {},
"typeVersion": 2
},
{
"id": "7d8bb4e6-d838-4d4a-9bdf-45f42bfb9f16",
"name": "AI Response Validation",
"type": "n8n-nodes-base.if",
"position": [
864,
-64
],
"parameters": {},
"typeVersion": 2.3
},
{
"id": "de8b1dc2-90d4-4949-8360-ed342a87c13c",
"name": "Merge Valid & Fallback Paths",
"type": "n8n-nodes-base.merge",
"position": [
1136,
-64
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "9671bf02-fb74-4405-ad32-bd188fc396ba",
"name": "Alert: AI Scoring Failure",
"type": "n8n-nodes-base.slack",
"position": [
1136,
224
],
"parameters": {},
"typeVersion": 2.4
},
{
"id": "f0894b0c-13fd-4723-9742-d98b4d80c38e",
"name": "Hybrid Lead Scoring Engine",
"type": "n8n-nodes-base.code",
"position": [
1456,
-272
],
"parameters": {},
"typeVersion": 2
},
{
"id": "6bf92f87-2d41-47f1-aaa2-c0ee717c9a72",
"name": "Prepare CRM Update Payload",
"type": "n8n-nodes-base.set",
"position": [
1808,
-272
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "7fc88fb3-720d-4dc6-b61c-1c7eddb99c97",
"name": "Update Lead Record (CRM)",
"type": "n8n-nodes-base.airtable",
"position": [
1824,
-48
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "037cc655-0103-4472-9eed-4093f6d9deef",
"name": "Prepare Hot Lead Notification",
"type": "n8n-nodes-base.set",
"position": [
2112,
-48
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "7a39ed59-600c-4930-8359-8b264684dce8",
"name": "Decision: Is High-Intent Lead?",
"type": "n8n-nodes-base.if",
"position": [
2256,
-336
],
"parameters": {},
"typeVersion": 2.3
},
{
"id": "4a1e3829-ae4d-44be-b883-81ab748f007c",
"name": "Notify Sales Team \u2013 Hot Lead",
"type": "n8n-nodes-base.slack",
"position": [
2464,
-352
],
"parameters": {},
"typeVersion": 2.4
},
{
"id": "5cfe888a-794b-4e1e-a1fd-8117c5c77d08",
"name": "Exit: No Sales Notification",
"type": "n8n-nodes-base.noOp",
"position": [
2464,
-32
],
"parameters": {},
"typeVersion": 1
},
{
"id": "dc26a99e-38c2-4743-a16d-ef39fb40086d",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-816,
-608
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d3fd89d7-f129-4b2d-a739-eae0b04d961e",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-192,
-496
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "5454a239-90f5-42bc-b8cf-e2da7908301f",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
768,
-496
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fc813e38-4e27-4c7b-9585-e1adfdd465a6",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1344,
-496
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "01462396-8611-43bc-a6ec-cc1b45d5aef1",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1680,
-480
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "5cd59010-7672-4f63-83e5-64b2f2aa6b1a",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
2048,
-480
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": true,
"settings": {
"timezone": "Asia/Manila",
"callerPolicy": "workflowsFromSameOwner",
"timeSavedMode": "fixed",
"availableInMCP": false,
"executionOrder": "v1"
},
"versionId": "f84d0e21-ef55-4790-aa62-adcf984e69c5",
"connections": {
"AI Response Validation": {
"main": [
[
{
"node": "Merge Valid & Fallback Paths",
"type": "main",
"index": 0
}
],
[
{
"node": "Merge Valid & Fallback Paths",
"type": "main",
"index": 1
},
{
"node": "Alert: AI Scoring Failure",
"type": "main",
"index": 0
}
]
]
},
"Update Lead Record (CRM)": {
"main": [
[
{
"node": "Prepare Hot Lead Notification",
"type": "main",
"index": 0
}
]
]
},
"Trigger: New Lead Created": {
"main": [
[
{
"node": "Normalize & Standardize Lead Data",
"type": "main",
"index": 0
}
]
]
},
"Hybrid Lead Scoring Engine": {
"main": [
[
{
"node": "Prepare CRM Update Payload",
"type": "main",
"index": 0
}
]
]
},
"Prepare AI Scoring Context": {
"main": [
[
{
"node": "AI Lead Qualification (GPT)",
"type": "main",
"index": 0
}
]
]
},
"Prepare CRM Update Payload": {
"main": [
[
{
"node": "Update Lead Record (CRM)",
"type": "main",
"index": 0
}
]
]
},
"AI Lead Qualification (GPT)": {
"main": [
[
{
"node": "Validate & Parse AI Response",
"type": "main",
"index": 0
}
]
]
},
"Merge Valid & Fallback Paths": {
"main": [
[
{
"node": "Hybrid Lead Scoring Engine",
"type": "main",
"index": 0
}
]
]
},
"Validate & Parse AI Response": {
"main": [
[
{
"node": "AI Response Validation",
"type": "main",
"index": 0
}
]
]
},
"Prepare Hot Lead Notification": {
"main": [
[
{
"node": "Decision: Is High-Intent Lead?",
"type": "main",
"index": 0
}
]
]
},
"Decision: Is High-Intent Lead?": {
"main": [
[
{
"node": "Notify Sales Team \u2013 Hot Lead",
"type": "main",
"index": 0
}
],
[
{
"node": "Exit: No Sales Notification",
"type": "main",
"index": 0
}
]
]
},
"Normalize & Standardize Lead Data": {
"main": [
[
{
"node": "Guard: Skip Already Processed Leads",
"type": "main",
"index": 0
}
]
]
},
"Guard: Skip Already Processed Leads": {
"main": [
[
{
"node": "Prepare AI Scoring Context",
"type": "main",
"index": 0
}
],
[
{
"node": "Exit: Already Processed",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Automatically qualify, score, and route new leads using a hybrid AI + rule-based scoring engine. This workflow analyzes incoming leads from Airtable, enriches them with OpenAI-powered qualification, applies deterministic business rules, and instantly alerts your sales team in…
Source: https://n8n.io/workflows/13746/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Automatically enriches every new LinkedIn lead added to your Airtable base with AI-structured data and notifies your team in Slack. Airtable Trigger polls for new leads every minute BrightData scrapes
This workflow automatically turns any audio file uploaded to Google Drive into a complete podcast episode. It handles transcription, content generation, blog drafting, social copy creation, thumbnail
Some use cases: Sales follow-ups, auto-qualifying leads based on budget, monetizing low-budget leads, and automatic data entry. Ingestion: When a call recording is uploaded to a specific Google Drive
This workflow automatically monitors new Zendesk support tickets, identifies VIP customers, generates AI-based ticket summaries, alerts available support agents on Slack and sends a consolidated email
Some use cases: "Speed-to-Lead" optimization, lead enrichment, automated prospect research. Ingestion: A lead submits their details (Name, Email, Website) via a form. Intelligent scraping: The workflo