AutomationFlowsAI & RAG › Qualify and Score Leads in Airtable with Openai and Slack Alerts

Qualify and Score Leads in Airtable with Openai and Slack Alerts

ByEdson Encinas @eedson on n8n.io

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…

Event trigger★★★★☆ complexityAI-powered23 nodesAirtable TriggerOpenAISlackAirtable
AI & RAG Trigger: Event Nodes: 23 Complexity: ★★★★☆ AI nodes: yes Added:

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 →

Download .json
{
  "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
          }
        ]
      ]
    }
  }
}
Pro

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 →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

AI & RAG

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

@Brightdata/N8N Nodes Brightdata, OpenAI, Airtable +2
AI & RAG

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

Google Drive Trigger, Google Drive, OpenAI +3
AI & RAG

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

OpenAI, Google Drive, Slack +4
AI & RAG

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

Slack, Zendesk Trigger, OpenAI +2
AI & RAG

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

Form Trigger, OpenAI, Airtable +2