What you import
10-minute scan of unmarked rows (cap 5) → score written on the same Leads row → Slack or Gmail only if Hot and hot_alerted_at is blank.
n8n
Hot leads ping Slack or email. Cold leads wait in the sheet.
A $6k emergency and a price shopper look the same on the sheet. This file scores unmarked rows and emails or Slacks you only when a row is Hot.
Before: you scan the sheet by eye after dinner. After: a score, a Hot / Warm / Cold band, and one owner alert on Hot.
10-minute scan of unmarked rows (cap 5) → score written on the same Leads row → Slack or Gmail only if Hot and hot_alerted_at is blank.
n8n
n8n, Google Sheets, Gmail. OpenAI optional (gpt-4o-mini). Slack optional. Rule-based scoring still runs if AI is off.
25–40 minutes after the Leads sheet from WF1 exists.
Does not text or email the lead. Does not flip booked or completed. Score reasons are not diagnoses or legal conclusions. OpenAI can stay off.
Scores no-heat, no-cool, and same-day urgency above brochure-shoppers.
Budget-ready, timing-now jobs rise. Tire-kickers stay in the sheet.
Pain, new-patient insurance readiness, and soonest-available requests rise. Shopping-only forms stay quiet.
Consults with a date and a treatment in mind rise. Vague “pricing?” notes wait.
Sick-pet and same-day language rises. Records-transfer only stays in the queue.
Same-week Saturday requests rise. “Do you take walk-ins someday?” stays in the list.
Deadline language and complete contact info rise. The model does not decide the matter.
Move-in date plus budget fit rise. Vague “any units?” notes wait.
Score and alert hot leads in n8n (import this)
Video posting soon.
START-HERE.pdf page 1. Credentials. First live node. Email hello@ if a node name moved.
Preferred implementation partner is listed on Partners. Other approved shops later. We do not hold the file hostage.