Free Template + Setup Guide
Google Forms NPS Template
The full NPS survey template you can paste into Google Forms in under 5 minutes. Plus the spreadsheet math you will need to actually calculate your score.
And the honest answer on when Google Forms NPS stops being enough for a SaaS team.
The NPS template for Google Forms
Two questions. That is the entire template. NPS is intentionally short.
Question text
On a scale of 0 to 10, how likely are you to recommend [Your Product] to a friend or colleague?
Scale start
0
Scale end
10
Low label
Not at all likely
High label
Extremely likely
In Google Forms: click the plus icon to add a question, then change the question type to Linear scale. Set the scale from 0 to 10. Set the low and high labels above.
Question text
What is the main reason for your score?
Set the question type to Paragraph. Leave the "Required" toggle off. Mandatory follow-up questions drop response rates by 30 to 50%.
That is the entire template. Two questions. Do not add a third unless you have a specific reason. Each extra NPS question costs you completion rate.
Or build it in Mapster in 2 minutes with AI and Branching Logic
Describe the survey you want. Mapster generates the questions, the 0 to 10 scale, the follow-up, and routes detractors to a different path than promoters.
No credit card required
How to calculate NPS from your Google Forms responses
Google Forms will not do this for you. Export to Google Sheets and run the formula manually.
The NPS formula
NPS = % Promoters − % Detractors
Promoters score 9 or 10. Detractors score 0 through 6. Passives (7 and 8) are excluded from the formula. The result is a number between -100 and +100.
Export Google Forms responses to Google Sheets
In your Google Form, click the Responses tab, then the green Sheets icon. This creates a linked spreadsheet that updates as new responses arrive.
Count Promoters, Passives, and Detractors
In your sheet, use COUNTIF formulas. Assuming the rating column is B: =COUNTIF(B:B, ">=9") for Promoters, =COUNTIF(B:B, ">=7") - COUNTIF(B:B, ">=9") for Passives, =COUNTIF(B:B, "<=6") for Detractors.
Calculate percentages
Divide each count by the total number of responses. Multiply by 100 to get a percentage. Example: 45 Promoters out of 100 responses equals 45% Promoters.
Subtract Detractor % from Promoter %
If you have 45% Promoters and 20% Detractors, your NPS is 45 minus 20 equals 25. A positive NPS means you have more Promoters than Detractors. The score range is -100 to +100.
Want to skip the math? The free NPS calculator takes your Promoter, Passive, and Detractor counts and returns the score instantly. No spreadsheet, no COUNTIF formulas.
Honest detour
When Google Forms NPS is the right tool
For many teams, Google Forms NPS is enough. It is free, fast to set up, and does not require a learning curve. If your needs are simple, it does the job.
Use Google Forms NPS when:
- You run NPS once or twice a year, not quarterly.
- Anonymous scores are fine and you do not need to follow up with detractors.
- Your customer base is small enough to read every response by hand.
- Segmentation by plan tier, role, or region is not something you need.
That covers a lot of cases. If yours is not on the list, here is where Google Forms NPS hits a wall.
Where Google Forms NPS hits a wall
Four problems that show up the moment NPS becomes a real metric in your business.
You cannot follow up with detractors
Google Forms NPS responses are anonymous unless you ask for an email. Even with an email field, you cannot tie the score back to a real user account. A 3 from a Pro-plan user worth $400 a month looks the same as a 3 from a free user who churned weeks ago. Detractor recovery is impossible without identity.
Score has to be calculated manually every time
Every quarter, you export to Google Sheets, run COUNTIF formulas, calculate percentages, subtract. Then do it again per segment if you want to compare. Mapster computes the NPS automatically and updates it as new responses arrive. Same input, hours less work.
No segmentation by user attribute
An overall NPS of 12 might hide a Pro-plan NPS of -8 and a free NPS of 28. The detractors are exactly the customers paying you the most. Google Forms cannot filter NPS by plan, role, signup date, or any user property without an export-and-pivot session in Sheets.
5 to 15% response rate at best
Email or link surveys with Google Forms typically see 5 to 15% response rates, skewed toward your most engaged users. In-product NPS triggered inside your app gets 20 to 40% from a representative sample. The smaller and more biased your sample, the less your NPS means.
What an NPS response looks like with and without identity
The difference is not what you ask. It is what you get back.
Google Forms NPS response
Timestamp: 2026-05-22 14:33
Score: 3
Reason: support has been slow lately
A detractor. You do not know which detractor, on which plan, in which region, or how much they pay you. Reaching out is impossible. Segmenting is impossible. The next step is a manual lookup that may or may not work.
Mapster NPS response
User: Marc Klein
Plan: Pro ($49/mo)
Location: Berlin, DE
Signed up: 11 months ago
Last support ticket: 4 days ago, marked resolved
NPS score: 3 (Detractor)
Reason: support has been slow lately
Same answer. Now you know it is a Pro customer 11 months in, with an unresolved support friction. CS reaches out by name within the hour. The detractor recovers. The score writes itself into your dashboard.
Google Forms NPS vs Mapster NPS
Same NPS question. Different workflow, different output.
| Capability | Google Forms NPS | Mapster NPS |
|---|---|---|
| Build the survey | 5 minutes manually | 1 minute from NPS template |
| Calculate NPS score | Manual COUNTIF in Sheets every time | Automatic, updated in real time |
| Response identity | Anonymous unless email collected | Linked to user account on every response |
| Segmentation | Manual pivot in Sheets | Filter by plan, role, region, or attribute |
| In-product delivery | Iframe only | Native JS widget, behavioural triggers |
| Response rate | 5 to 15% email or link | 20 to 40% in-app |
| Detractor follow-up | Cannot identify who responded | Slack alert with user details on every detractor |
| Trend over time | Manual chart in Sheets | Built-in quarterly trend dashboard |
| Price | Free | Free plan available, Pro from $8/mo |
Looking for the full comparison across all surveys? Mapster vs Google Forms covers it.
NPS surveys with automatic scoring and user identity
Built-in NPS templates, automatic Promoter / Passive / Detractor scoring, segmentation by plan and role, in-app widget for 20 to 40% response rates. Free plan available.
Try Mapster NPS FreeNo credit card required