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.

difficulty Advancedsetup 45 minresult Every HubSpot lead gets an AI fit score written to its record, and high-scoring leads are flagged in Google Sheets for fast follow-up.
  1. 1

    Step 1 — Trigger on a new lead

    Add the HubSpot trigger for new contacts/leads, carrying their firmographic and behavioural fields.

  2. 2

    Step 2 — Score with AI

    Add an OpenAI node with your ICP definition in the prompt, returning a 0–100 fit score and a one-line rationale.

  3. 3

    Step 3 — Write the score back

    Add a HubSpot node to update the lead's lead_score field so it's visible and filterable inside HubSpot.

  4. 4

    Step 4 — Surface hot leads in Google Sheets

    Add a Google Sheets node 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.

About this recipe. Recipes on FlowRecipesHub are written for business owners, not developers, and are tested before publishing — how recipes get made. Some ingredient links are affiliate links that cost you nothing — full disclosure.