Qualify and score leads in Airtable with OpenAI and Slack alerts

🧩 Description 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 Slack when a high-intent lead is detected.

🎯 Who’s it for

- Sales teams that want instant alerts for high-intent leads - Founders who need automated qualification without hiring SDRs - Marketing teams running paid campaigns and capturing inbound leads - RevOps teams building structured, explainable scoring systems

If you store leads in Airtable and want AI-assisted qualification with fallback logic (not just blind AI scoring), this template is for you.

🤖 What it does This workflow implements a hybrid lead scoring model:

1. Triggers when a new lead is created in Airtable. 2. Normalizes and standardizes lead data. 3. Sends structured context to OpenAI for qualification. 4. Validates the AI response (strict JSON parsing). 5. Falls back to deterministic scoring if AI fails. 6. Combines AI score (50% weight) + rule-based score. 7. Updates Airtable with: - Final score (0–100) - Hot/Warm/Cold tag - AI reasoning - Confidence level

8. Sends Slack alerts: - 🔥 Hot leads (score ≥ 80) - ⚠️ AI scoring failures (manual review required)

Unlike basic AI-only scoring, this workflow guarantees reliability by combining LLM reasoning with business logic.