Score B2B Leads with Claude AI and Google Sheets

If you want to score b2b leads with claude ai and log every score in Google Sheets automatically, one no-code Make scenario does the whole job — Claude scores each new lead 0–100 with a short reason, and your sheet sorts itself hottest first. No manual scoring, no guessing, no code. What you need A Make account with a scenario that triggers on new leads A Claude API key A Google Sheet with columns for name, company, email, score, and reason Two dummy leads to test with — a test name, a demo company, an example email Disclosure: Some links below are affiliate links, meaning StackScale may earn a commission at no extra cost to you. Get started with Make here: https://www.make.com/en/register?pc=stackscale&affiliateSource=devto The problem: every lead looks the same New leads pile up in your inbox and your forms, and every one of them looks the same. A hot buyer and a time-waster both say "interested", and your team calls them in whatever order they arrived. The best leads go cold while you are busy chasing the wrong ones. The fix: Make, Claude, and Sheets One Make scenario watches for every new lead, sends the details to Claude, and Claude replies with a score from zero to one hundred, plus one short reason. Make writes the score, the reason, and the lead's details into Google Sheets, sorted so the hottest leads sit at the top. The five steps The lead arrives — Connect your form to Make with a webhook, or use Make's form trigger. Every time someone submits the form, Make catches the name, the company, and the email, and the scenario starts. Send the lead to Claude — Add a Claude module with a short scoring prompt: score this lead from zero to one hundred, based on company size, role, and how clearly they described their need, and reply with the score and one short reason in JSON. Read the score — Claude replies with a score and a reason. Parse that JSON in Make, so the score and the reason become fields you can use in the next step. Log it in Google Sheets — Add a Google Sheets module that writes a new row for every lead: name, company, email, Claude's score, and the reason. Sort the sheet by score, highest first. Test with dummy leads — Fire three test leads through the form — a hot one, a cold one, and one in between — and watch the scores land in the sheet. The scoring prompt and a sample reply Send Claude a prompt like this: Score this lead 0-100 on company size, role, and how clearly they described their need. Reply with the score and one short reason, in JSON only. Claude replies with something like this: { "score": 85, "reason": "Mid-size company, clear budget, ready to buy" } Parse the JSON in Make, then map the fields into your sheet. Demo Corp with a clear budget should score high; a vague one-liner with no company should score low. The finished result Every lead scored by Claude and logged in Sheets, hottest first. Your team opens the sheet every morning knowing exactly who to call first. If a score looks wrong, tune the prompt — reword the criteria and re-test the dummy leads — not the plumbing. Watch the full tutorial on YouTube: https://youtu.be/MGayb2q3kYM — and subscribe to StackScale for a new automation tutorial every day.