Templates / Qualify inbound leads with OpenAI, Slack, and Google Sheets

Qualify inbound leads with OpenAI, Slack, and Google Sheets

Ready for 3.0

by Operstead ✓ · 5 views · created 2026-06-25 · Lead Generation, AI Summarization

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 13 nodes and runs when an HTTP GET request hits its webhook URL. Along the way it connects OpenAI, Slack and Google Sheets.

How it runs

Trigger: When an HTTP GET request hits its webhook URL.

  1. Normalize Lead Fields (Edit Fields (Set)): sets or maps fields
  2. Qualify with AI (OpenAI): uses OpenAI
  3. Combine Lead + Score (Edit Fields (Set)): sets or maps fields
  4. Route by Tier (Switch): routes items into branches
  5. Slack: uses Slack
  6. Sheets: Append HOT (Google Sheets): uses Google Sheets
  7. Email: HOT Auto-Reply (Send Email): sends an email over SMTP
  8. Sheets: Append WARM (Google Sheets): uses Google Sheets
  9. Email: WARM Auto-Reply (Send Email): sends an email over SMTP
  10. Sheets: Append NURTURE (Google Sheets): uses Google Sheets

…plus 2 more steps. See the full node list below.

Services it uses

OpenAISlackGoogle Sheets

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (8)

From the author

Quick overview This workflow receives inbound leads via a webhook, normalizes common form fields, and uses OpenAI to score and tier each lead as HOT, WARM, or NURTURE. It logs the result to Google Sheets, sends a tier-specific email auto-reply, and alerts a…

Excerpt from Operstead's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.