Skip to main content

EP02Season 1

AI Scores Every Lead: Hot, Warm or Cold

Claude AI reads every new lead, scores it Hot, Warm or Cold, alerts you about hot leads and replies on WhatsApp. Free n8n template plus a step-by-step setup docs.

Setup time
45–60 min
Level
Beginner–Intermediate
Cost
Free to start + a few paise per lead for AI

Free n8n template · valerie-ep02-ai-lead-scoring.json

The Ep02 workflow on the n8n canvas: New Lead (Tally Webhook) and Clean Lead feed the AI Lead Classifier, which routes to Score: Hot, Warm or Cold. Hot also alerts the owner by email. All three scores save to Google Sheet, then Send WhatsApp Reply.
Finished workflow in n8nOpen full size

What it does

Every new lead is read by AI and sorted into:

  • 🔥 Hot: ready now, so you get an email alert to call immediately
  • 🌤 Warm: interested, follow up within a day
  • ❄️ Cold: just exploring, nurture later

Every lead also gets a WhatsApp reply and is saved to Google Sheets with its score.

Flow: Tally → Webhook → Clean Lead → AI Lead Classifier → Score → Sheet (+ email for Hot) → WhatsApp

Why it matters: you stop wasting your best hours on cold leads and call hot ones while they're still interested.

What you need

ToolWhyCost
n8nRuns the automationFree trial / paid
TallyThe formFree
Google Sheets + GmailCRM + hot-lead alertsFree
Anthropic (Claude) API keyThe AI that scores leadsPay-as-you-go (very low per lead with Haiku)
WhatsApp Cloud APIThe replyFree test number

💡 Did Episode 1? You can reuse the same WhatsApp template (lead_ack), token and Header Auth credential.

Import the template

  1. Download the template (button above)
  2. In n8n: Workflows → Create workflow → ⋯ → Import from File
  3. Choose valerie-ep02-ai-lead-scoring.json, then Save

Prepare your accounts

Tally form

The template is set up for a loan enquiry demo. Field labels must contain:

  • Name
  • Phone
  • Service (e.g. Home Loan, Car Loan, Personal Loan)
  • Amount (e.g. "Loan amount")
  • When (e.g. "When do you need it?" with options This week / This month / Just exploring)
  • Message

Not a loan business? Keep the labels and change the options, e.g. "Budget" for Amount.

Google Sheet

Row 1 headers, exactly:

Name | Phone | Service | Amount | Urgency | Message | Timestamp | Status | Score

Optional: colour the Score column with Format → Conditional formatting

  • Text contains Hot → red
  • Warm → yellow
  • Cold → blue

Anthropic API key

  1. Go to console.anthropic.com → API Keys → Create Key
  2. Add a little credit under Billing
  3. Copy the key
    • 🔒 Keep it private

WhatsApp

Follow Episode 1, steps 4.3–4.5 (test number, permanent token, lead_ack template). If you've done them already, skip this.

Connect the nodes

New Lead (Tally Webhook)

Nothing to change. Note the Test and Production URLs.

Clean Lead

Nothing to change. It reads Name, Phone, Service, Amount, Urgency and Message and formats the phone number.

AI Lead Classifier

This is the brain. Each category has a description that tells the AI what that score means:

  • Hot: needs it this week, gives a clear amount, asks for a specific product
  • Warm: needs it this month or gives partial details
  • Cold: no timeline, no amount, general questions

✏️ Rewrite these in your own business's words. Clearer descriptions give better scores.

Anthropic Chat Model

  1. Credential → Create new → Anthropic → paste your API key
  2. Model: choose a Claude Haiku model (fast and cheap, more than enough for scoring)

Score: Hot / Warm / Cold

Nothing to change. Each one adds a Score column (🔥 Hot / 🌤 Warm / ❄️ Cold).

Alert Owner (Hot only)

  1. Credential → Create new → Sign in with Google (Gmail)
  2. To: replace YOUR_EMAIL with your email

Save to Google Sheet

  1. Google credential → paste your Sheet URL → pick the tab

Send WhatsApp Reply

  1. Replace YOUR_PHONE_NUMBER_ID
  2. Select your Header Auth credential (Authorization = Bearer YOUR_TOKEN)

Save.

Test it with 3 demo leads

  1. Paste the Test URL into Tally → Integrations → Webhooks
  2. Click Execute workflow before each submission
  3. Submit these (with your own verified number):
LeadServiceAmountWhenMessageExpected
RahulHome Loan₹40,00,000This weekNeed home loan for a flat, papers ready🔥 Hot
PriyaCar Loan₹6,00,000This monthPlanning to buy a car next month🌤 Warm
AmitPersonal LoanJust exploringWhat are your interest rates?❄️ Cold
  1. Check:
    • ✅ The Sheet shows the right score for each lead
    • ✅ Only Rahul triggers the 🔥 email
    • ✅ The WhatsApp reply arrives every time

Go live

  1. Publish (older n8n: Active)
  2. Swap the Test URL in Tally for the Production URL

Common errors

ProblemFix
AI node error: credentials / 401Check the Anthropic API key and make sure you have credit
Model not foundPick a model from the dropdown instead of typing one
Every lead gets the same scoreMake the category descriptions more specific and different from each other
No hot-lead emailReconnect Gmail, check spam, make sure the lead scored Hot
Score column emptyThe header must be exactly Score
WhatsApp errors (131030, 132001, 190)See the Episode 1 error table

Customise it

  • Change the categories (e.g. Buyer / Renter / Spam)
  • Send different WhatsApp templates per score
  • Send hot leads to Slack or Telegram as well as email
  • Swap Claude for another AI model in the Chat Model slot

Want it done for you?

We'll tune the AI scoring to your business and set everything up for you.

👉 Get it set up

Want this done for you?

Let's talk