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

1. 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.

2. Validation:
   Incoming data is checked for required fields (email or text). Invalid entries are routed to the Dead Letter Queue (DLQ) for review.

3. AI Extraction:
   The OpenAI node extracts structured fields like company name, size, industry, role, region, problem statement, and budget signals from free-form text.

4. 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).

5. 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.

6. Slack Notification:
   A rich Slack message summarizes the lead score and reasoning and includes a “Create intro email” button for quick action.

7. 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.