Lead Scoring in Google Forms: A Step-by-Step Setup

Score every lead from your Google Form by budget, timeline, company size and role, then tag them Hot, Warm or Cold with one Sheets formula.

A contact form treats every submission the same. At five leads a week you can read them all. At fifty, you need to know who to call first without opening each response. Lead scoring gives every lead a number based on its answers. This guide builds a complete model you can copy and adjust.

Step 1: Ask four questions that predict a sale

Most B2B qualification comes down to four things:

• Budget. Can they pay for what you sell?
• Timeline. Will they buy soon, or are they collecting links?
• Company size. Do they look like your best customers?
• Role. Can this person say yes, or do they need to ask someone?

Use multiple choice or dropdown questions with fixed options. A short-answer field like "Tell us your budget" can't be scored, because every answer is worded differently.

If you want an email next to each score, open Settings > Responses and turn on Collect email addresses. An email typed into an ordinary short-answer question won't show up in the Email column of your scores.

Step 2: Choose point values

Here's a model to start from. The maximum is 30.

The reasoning behind the numbers:

• Weight what decides the deal. Budget and timeline get up to 10 points each. Size and role get up to 5. A perfect-fit company with no budget still won't buy this quarter.
• Leave big gaps. 0, 5 and 10 are easier to reason about than 6, 7 and 8. Your first model is a guess, and fine distinctions hide that.
• Bigger isn't always better. This example assumes a product for small teams, so companies over 200 score lower than companies of 11 to 50. Score for your best customers, not the biggest ones.
• Use negative points for disqualifiers. At -10, a student can't reach Hot: the best they can score is 15.

Three example leads:

Before you rely on the model, score five past leads by hand: a few that bought and a few that didn't. If a buyer lands below a non-buyer, change the points until the order makes sense.

Step 3: Score every response automatically

You can build this with lookup formulas in the linked Sheet. Our guide to assigning different points to each answer shows how. The faster way is Answer Points, a free Google Forms add-on we make at Coalball Labs.

1. Install Answer Points. In your form, click the puzzle-piece Add-ons icon and choose Answer Points > Set up scoring.
2. Type the points from the table next to each option. Highest possible score should read 30. Click Save points.
3. Click Turn on auto-scoring. A spreadsheet named "[form title] – Scores (Answer Points)" appears in your Drive.
4. Click Score existing responses to score the leads you already have.

Each lead becomes a row in the first tab, called Scores:

Lead A from the example shows Total 23, Max 30 and Percent 76.7.

Step 4: Tag leads Hot, Warm or Cold

Start with these thresholds:

• Hot: 20 or more. Strong answers on most questions. Call first.
• Warm: 10 to 19. Worth a follow-up email.
• Cold: under 10. Low priority.

For a single row, the logic is:

=IFS(Scores!C2>=20, "Hot", Scores!C2>=10, "Warm", TRUE, "Cold")

IFS checks each condition in order and returns the first match. TRUE catches everything left over.

Don't add formulas to the Scores tab itself. Score existing responses clears that tab and rewrites it, so anything you add there is lost. And because the add-on inserts each new lead as a new row, a formula you drag down on another tab can end up pointing at the wrong rows.

Instead, add a second tab called Leads. Type headers in row 1: Submitted (UTC), Email, Total, Tier. Then put this in A2:

=IFERROR(ARRAYFORMULA(SORT(FILTER({Scores!A2:C, IF(Scores!C2:C>=20, "Hot", IF(Scores!C2:C>=10, "Warm", "Cold"))}, Scores!A2:A<>""), 3, FALSE)), "No leads yet")

Here's what it does:

• {Scores!A2:C, IF(...)} takes Submitted, Email and Total, and adds a Tier column. The nested IF is the same logic as the IFS above, written so it works on a whole column.
• FILTER(..., Scores!A2:A<>"") drops empty rows.
• SORT(..., 3, FALSE) sorts by the third column, Total, highest first.
• IFERROR(..., "No leads yet") shows a message instead of an error while the sheet is empty.

New leads slot into the right place as they arrive, and Hot leads stay at the top.

For a Hot-only list, use a third tab with:

=IFERROR(SORT(FILTER(Scores!A2:C, Scores!C2:C>=20), 3, FALSE), "No hot leads yet")

If you change your point values later, the maximum changes too. Either move the thresholds, or base them on Percent (column E): swap Scores!C2:C>=20 for Scores!E2:E>=66.7 and Scores!C2:C>=10 for Scores!E2:E>=33.3.

Revisit the thresholds after your first few weeks of calls. If Warm leads keep buying, lower the Hot line.

Step 5: Sort and filter by hand

For a quick look, you don't need formulas.

1. In the Scores tab, choose Data > Create a filter.
2. Click the filter icon on Total and choose Sort Z → A.
3. To narrow the list, open the same menu, choose Filter by condition > Greater than or equal to, and type 20.

Each question also has its own column, so you can filter on one answer. For example, filter the budget column to 10 to see everyone with a budget over $5,000.

One catch: sorting the Scores tab changes the order of its rows, and new leads are still added at the bottom. Sort again when you come back. The Leads tab from Step 4 stays sorted on its own.

What this setup won't do

• Leads don't see their score. Google doesn't let add-ons change what respondents see, so there's no result screen.
• No routing by score. The add-on can't send high scorers to a special section. Google Forms' own Go to section based on answer still works on a single multiple choice or dropdown question, for example sending "This month" buyers to a section with your booking link.
• No alerts or CRM sync. Scores go to a Sheet you own. Checking the Leads tab is up to you.

Start scoring your leads

Answer Points is free during beta, with no response limit. Set your points once and every new lead arrives with a score.

Install Answer Points free

Scoring rules for each question type are in the Guide & FAQ.