Qualify & Route Leads Across Channels with GPT-4o, Slack & CRM Integration
This n8n template demonstrates how to use AI to capture, qualify, and route inbound leads automatically from email or web forms.
It extracts key business information using AI, scores the lead based on your ideal customer profile, creates CRM records, notifies your team on Slack, and logs all activity—including failures—to Google Sheets.
Use cases include: automating sales inboxes, qualifying form leads for agencies or SaaS products, routing high-fit prospects to the right territory owner, and keeping your sales and ops teams aligned without manual data entry.
Good to know
The OpenAI model is used for lead data extraction and will incur a small cost per run depending on volume.
This workflow supports either Salesforce or HubSpot as the CRM system—select which one in the configuration node.
You’ll need valid credentials for Gmail (or another email service), OpenAI, Slack, Google Sheets, and your chosen CRM before running.
How it works
Triggers:
A Gmail trigger polls for new inbound emails.
A Webhook node receives submissions from any online form.
Both sources merge into a single pipeline.
Validation:
Incoming data is checked for required fields (email or text). Invalid entries are routed to the Dead Letter Queue (DLQ) for review.
AI Extraction:
The OpenAI node extracts structured fields like company name, size, industry, role, region, problem statement, and budget signals from free-form text.
Parsing & Scoring:
The AI output is parsed, then a code node calculates a 0–100 lead score based on transparent criteria—industry, size, role, problem clarity, and budget mentions. It also assigns a lead tier (Hot, Warm, Cold, Unqualified).
CRM Routing:
Depending on your configuration, the workflow creates a Salesforce lead (default) or can be easily adapted for HubSpot. Territory or CRM owner routing can be extended here.
Slack Notification:
A rich Slack message summarizes the lead score and reasoning and includes a “Create intro email” button for quick action.
Logging:
All successful leads are logged to Google Sheets for reporting. Any failed or invalid leads are logged separately to the DLQ tab for auditing.
How to use
Configure your credentials for Gmail, OpenAI, Slack, Google Sheets, and your CRM.
Open the Workflow Configuration node and fill in your target industries, buyer roles, company size, Slack channel ID, Google Sheets URL, and CRM choice.
Create corresponding tabs in your Google Sheet for Leads and DLQ.
Test by sending a sample email or form submission, then watch the workflow extract, score, route, and notify automatically.
Requirements
OpenAI account for text extraction
Gmail (or other email provider) for the email trigger
Slack for lead notifications
Google Sheets for logging leads and DLQ entries
Salesforce or HubSpot account for CRM integration
Customizing this workflow
This template can be expanded in many ways:
Add HubSpot routing on the first Switch output.
Integrate a Slack button handler to auto-generate intro emails.
Add retry and backoff logic for resilience.
Modify the scoring rubric in the code node to match your unique ICP.
Connect additional sources, such as LinkedIn forms or landing page builders, for omnichannel lead capture.
