Google Forms NPS Guide
How to Create an NPS Survey in Google Forms
Google Forms has no native NPS field — but you can build one in 5 minutes with the Linear Scale question and a Sheets formula. Here's the full walkthrough, plus a faster alternative with a real NPS field built in.
What is an NPS survey?
Net Promoter Score (NPS) is a one-question loyalty metric: "How likely are you to recommend us to a friend or colleague?" Respondents answer on a 0–10 scale. You then bucket them into three groups:
Loyal enthusiasts who will refer others.
Satisfied but unenthusiastic. Vulnerable to competitors.
Unhappy customers who can damage your brand.
Your Net Promoter Score is the % of Promoters minus the % of Detractors. The result lives on a scale from -100 to +100. Above zero is positive, above 50 is excellent, above 70 is world-class.
Now let's build the survey itself in Google Forms.
How to build an NPS survey in Google Forms
Google Forms doesn't have a dedicated NPS question type, but you can fake one well enough using the Linear Scale field. Here's the exact setup.
Step 1: Create a new blank form
Go to forms.google.com and click the blank template. Give it a clear title like "NPS Survey — {Your company}".
Step 2: Add the NPS question
Type the standard NPS question into the question field:
Step 3: Switch the question type to Linear Scale
In the question type dropdown (top right of the question), choose Linear Scale. Set the range to 0 to 10. Label the low end "Not at all likely" and the high end "Extremely likely". Mark the question as required.
Step 4: Add an open-ended follow-up
Add a Paragraph question: "What's the main reason for your score?". The "why" behind the number is where most of the actionable insight lives.
⚠️ Google Forms can't show different follow-ups to Promoters vs Detractors — branching logic doesn't work on Linear Scale fields. More on that below.
Step 5: Send responses to a Google Sheet
Open the Responses tab → click the green Sheets icon → "Create a new spreadsheet". That's where you'll calculate the score in a moment.
Calculate your Net Promoter Score in Google Sheets
Google Forms only collects raw responses — there's no built-in NPS calculation. Drop this single formula into your linked Sheet to get the score automatically.
Assuming your NPS scores live in column B starting at row 2:
That returns % Promoters minus % Detractors, scaled to the standard -100 to +100 range.
Break it down further?
Add these in separate cells to see each segment:
💡 Skip the formula entirely
Paste your response data into our free NPS calculator and it'll compute the score, segment breakdown, and benchmark in one click.
What Google Forms can't do for NPS
The Linear Scale workaround gets you a survey. But the moment you want to do something with the data, you hit Google Forms' ceiling.
🚫 No native NPS field
Linear Scale is generic. You can't enforce the 0–10 range as "NPS", and the form has no awareness of Promoter/Passive/Detractor segments — that logic only lives in your head and your Sheet.
🔀 No conditional follow-ups by segment
Google Forms' branching only works on multiple-choice and dropdown questions. You cannot route Promoters to "What did we do well?" and Detractors to "What could we improve?" without an awkward extra question.
📉 No real-time score
There's no NPS dashboard, no live score, no segment chart. You see one bar graph of raw counts on the Responses tab and have to compute everything else by hand in Sheets.
🎨 Generic Google Forms styling
The 0–10 buttons render as plain radio buttons with the Google Forms color band — fine for an internal survey, off-brand for anything customer-facing.
📧 No automation by score
Want to alert a CSM when a customer scores 0–3, or trigger a referral request when someone scores 10? You'll need an Apps Script or Zapier glue layer — Google Forms can't do it on its own.
The faster way: a real NPS field in Youform
Youform has a dedicated NPS question type with the standard 0–10 scale, the right labels, and segment-aware logic built in. No Linear Scale workaround, no Sheets formula, no broken branching.
What you get out of the box
Pre-built NPS field
Drop the NPS block into your form. The 0–10 scale, endpoint labels, and Promoter/Passive/Detractor segments are wired up automatically.
Segment-aware follow-up questions
Conditional logic works on the score itself. Ask Promoters "What did we do well?" and Detractors "What could we fix?" without an extra dropdown.
Branded styling
Custom colors, fonts, and logo — survey looks like your product, not a Google Doc.
Live template
Try the NPS survey
Score it, hit Next — you'll see the Promoter / Detractor follow-up route in action.
Live results
…and here's the sharable results report
Real responses to the form above. NPS score, segment breakdown, and follow-up answers — on one page you can share with your team or stakeholders.
Google Forms shows you a static bar chart per question. Youform reports compute the NPS score, group responses by Promoter / Passive / Detractor, summarize text answers, and update in real time — and you can share the link with anyone, no login required.
Already built it in Google Forms?
Paste your Google Forms URL into our free converter and we'll rebuild it in Youform — questions, options, and structure intact. Then swap the Linear Scale for a proper NPS field.
Free forever · Unlimited NPS surveys · Unlimited responses · No credit card required
Google Forms NPS vs. Youform NPS
| Google Forms | Youform | |
|---|---|---|
| Dedicated NPS question type | ❌ Use Linear Scale workaround | ✅ |
| Branching on the score (0–10) | ❌ | ✅ |
| Automatic Promoter/Passive/Detractor segmentation | ❌ Manual in Sheets | ✅ |
| Score calculation | Sheets formula | Pair with free NPS calculator |
| Custom branding (colors, logo, fonts) | Limited | ✅ |
| Pre-built NPS template | ❌ | ✅ |
| Sharable real-time results report | ❌ Static bar charts only | ✅ |
| Cost | Free | Free (unlimited responses) |
Loved by 70,000+ users
What our users say
Frequently Asked Questions
Does Google Forms have a built-in NPS question type?
No. Google Forms doesn't have a dedicated NPS field. To build an NPS survey you use the Linear Scale question type set from 0 to 10, label the endpoints "Not at all likely" and "Extremely likely", and then calculate the score manually in Google Sheets using the % of Promoters (9–10) minus the % of Detractors (0–6).
What is the formula to calculate NPS in Google Sheets?
If your scores are in column B starting at row 2, use: =((COUNTIF(B2:B,">=9")-COUNTIF(B2:B,"<=6"))/COUNTA(B2:B))*100. That returns the % of Promoters minus the % of Detractors as your NPS score. The result ranges from -100 to +100. Anything above 0 is positive, above 50 is excellent, above 70 is world-class. Or skip the formula and paste into our free NPS calculator.
What are Promoters, Passives, and Detractors?
Respondents who score 9 or 10 are Promoters — loyal enthusiasts likely to recommend you. Scores of 7 or 8 are Passives — satisfied but unenthusiastic. Scores 0 through 6 are Detractors — unhappy customers who may damage your brand. NPS = % Promoters minus % Detractors. Passives count toward your total response volume but not toward the score itself.
Can I show different follow-ups to Promoters vs Detractors in Google Forms?
Not directly. Google Forms' branching logic only works on multiple-choice and dropdown questions — not on the Linear Scale field you'd use for NPS. The workaround is to add a separate multiple-choice question grouping respondents into Promoter/Passive/Detractor buckets, then branch from that. Youform's conditional logic works on any field including 0–10 scales, so you can ask "What did we do well?" to Promoters and "What could we improve?" to Detractors automatically.
Is there a free NPS template for Google Forms?
There's no first-party Google Forms NPS template — you have to build it yourself from the blank-form template using the steps above. Youform has a free pre-built NPS survey template with the proper 0–10 scale, segment-aware follow-up questions, and a thank-you page. Pair it with the free NPS calculator to compute your score from any list of responses.
How often should I send an NPS survey?
Quarterly is standard for a relationship NPS survey — frequent enough to track trend, rare enough to avoid survey fatigue. Transactional NPS, sent right after a specific touchpoint like a support resolution or onboarding milestone, can run continuously. Don't survey the same customer more than once per quarter for relationship NPS.
Skip the Linear Scale workaround
Build your NPS survey with a real NPS field, segment-aware follow-ups, and branded styling — free, unlimited responses.
Create free accountFree forever · Unlimited responses · No credit card required
Scrolled so much still not sure?
Let your favorite AI tell you if Youform is the right fit.
Already made up your mind?
Sign up now
Legal
🔒 Data securely stored with AWS in EU 🇪🇺