Score New HubSpot Leads With AI and Surface the Hot Ones in Google Sheets
Each new HubSpot lead is scored by AI against your ideal-customer profile, the score is written back to HubSpot, and anything hot is pushed to Google Sheets — so reps spend their time on the leads most likely to close.
- 1
Step 1 — Trigger on a new lead
Add the
HubSpottrigger for new contacts/leads, carrying their firmographic and behavioural fields. - 2
Step 2 — Score with AI
Add an
OpenAInode with your ICP definition in the prompt, returning a 0–100 fit score and a one-line rationale. - 3
Step 3 — Write the score back
Add a
HubSpotnode to update the lead'slead_scorefield so it's visible and filterable inside HubSpot. - 4
Step 4 — Surface hot leads in Google Sheets
Add a
Google Sheetsnode to log high scorers for the team to work.
Frequently asked questions
Won't AI scoring be a black box?
Step 2 returns a rationale alongside the number, so reps see *why* a lead scored high. Review those rationales periodically and refine the ICP prompt to keep it honest.
Can I combine it with behavioural data?
Yes — pass page views, email opens or trial usage into the Step 2 prompt so the score reflects both fit and engagement.