NPS Google Forms refers to using Google Forms to run a Net Promoter Score survey, where you ask customers the single question “How likely are you to recommend us?” on a 0–10 scale and then calculate the score by subtracting the percentage of detractors from the percentage of promoters. It is a free, simple way to collect NPS data without dedicated survey software, though it lacks some advanced features like automatic scoring and response tracking.
What Is NPS and Why Does It Matter?
Net Promoter Score (NPS) is a customer loyalty metric introduced by Fred Reichheld in a 2003 Harvard Business Review article. It is based on one core question: “On a scale of 0 to 10, how likely are you to recommend our company/product/service to a friend or colleague?” Respondents are grouped into three categories:
- Promoters (9–10): Loyal enthusiasts who will keep buying and refer others.
- Passives (7–8): Satisfied but unenthusiastic; vulnerable to competitive offers.
- Detractors (0–6): Unhappy customers who can damage your brand through negative word-of-mouth.
The NPS is calculated as: % Promoters – % Detractors. The result ranges from -100 to +100. A positive score is generally considered good, above 50 is excellent, and above 70 is world-class, though benchmarks vary by industry.
Why Use Google Forms for NPS?
Google Forms is a free, web-based tool that requires no special software. For small businesses, startups, or teams that want a quick pulse on customer sentiment, it offers several advantages:
- Zero cost – no subscription fees.
- Easy to create and share via link, email, or embedded on a website.
- Responses are collected in a Google Sheet automatically.
- No limit on the number of responses (for personal Google accounts).
- Simple to analyze with built-in charts or by exporting data to Excel or Google Sheets.
However, it is not a dedicated NPS tool. You will need to calculate the score manually, and you won’t get features like automated follow-up emails, real-time dashboards, or trend analysis.
How to Create an NPS Survey in Google Forms
Building an NPS survey in Google Forms takes just a few minutes. Here is a step-by-step guide:
- Go to forms.google.com and start a new blank form.
- Add a title (e.g., “Customer Satisfaction Survey”) and a brief description.
- Add your first question: “How likely are you to recommend us to a friend or colleague?”
- Choose the question type: Select “Multiple choice grid” or “Linear scale.” For NPS, a linear scale from 0 to 10 is ideal.
- Set the scale: In the question settings, set the range from 0 to 10, and optionally label the endpoints (0 = “Not at all likely”, 10 = “Extremely likely”).
- Add an optional follow-up question: “What is the main reason for your score?” as a paragraph text.
- Turn on required for the NPS question to ensure you get complete data.
- Share the form via email, link, or embed it on your website.
Once responses start coming in, open the linked Google Sheet to see the raw data. To calculate NPS, count the number of promoters (9–10), passives (7–8), and detractors (0–6). Then use the formula: (Promoters / Total responses) – (Detractors / Total responses) × 100.
How to Calculate NPS from Google Forms Responses
Suppose you have 100 responses: 60 promoters, 20 passives, and 20 detractors. The calculation would be:
Promoter percentage = 60/100 = 60%
Detractor percentage = 20/100 = 20%
NPS = 60% – 20% = 40
You can automate this in Google Sheets using a formula. If your responses are in column B (the 0–10 score), you can use =COUNTIF(B:B,">=9")/COUNTA(B:B)-COUNTIF(B:B,"<=6")/COUNTA(B:B) and multiply by 100. For a more robust solution, consider using Google Apps Script or a simple pivot table.
Common Mistakes and How to Avoid Them
When using Google Forms for NPS, people often make a few mistakes:
- Using the wrong scale: Some use 1–10 or 1–5, which makes the score incompatible with standard NPS benchmarks. Always use 0–10.
- Not making the question required: Skipping the question leads to incomplete data and skewed percentages.
- Ignoring the follow-up question: Without asking “why,” you lose the actionable insight behind the score.
- Forgetting to segment responses: If you send the survey to different customer groups, you may want to add a question about the product or service they used.
- Not closing the loop: NPS is only useful if you follow up with detractors and thank promoters. Google Forms doesn’t automatically send follow-ups, so plan to do that manually.
Google Forms vs. Dedicated NPS Tools
Google Forms is a great entry-level option, but dedicated NPS tools like Delighted, SurveyMonkey, or Qualtrics offer features that Google Forms lacks:
- Automatic NPS calculation: They compute the score in real time.
- Response tracking: You can see who responded and who didn’t, and send reminders.
- Customizable follow-up workflows: Automatically send emails to detractors or notify your support team.
- Benchmarking: Compare your score against industry averages.
- Integration: Connect with CRM tools like Salesforce or HubSpot.
If you only need a basic survey and are comfortable with manual analysis, Google Forms is sufficient. If NPS becomes a core metric for your business, consider upgrading to a dedicated tool.
Template for an NPS Survey in Google Forms
Here is a blank template you can copy into Google Forms:
| Field | Content |
|---|---|
| Form Title | Customer Satisfaction Survey |
| Question 1 (Linear scale) | How likely are you to recommend us to a friend or colleague? (0–10) |
| Question 2 (Paragraph) | What is the main reason for your score? |
| Question 3 (Optional) | How can we improve your experience? |
Sample filled-in response: Q1: 9, Q2: “Great product, but shipping was slow.” Q3: “Offer faster shipping options.”
Frequently Asked Questions
Can I automatically calculate NPS in Google Forms?
No, Google Forms does not have a built-in NPS calculator. You need to manually compute the score from the responses in Google Sheets, or use a Google Apps Script to automate it.
Is Google Forms free for NPS surveys?
Yes, Google Forms is completely free for unlimited responses if you have a personal Google account. Workspace (business) accounts may have limits depending on the plan, but for most small businesses it is free.
How do I send an NPS survey via Google Forms?
You can share the form link via email, social media, or embed it on your website using the “Send” button in Google Forms. You can also generate a QR code for physical distribution.
What is a good NPS score?
There is no universal “good” score, but generally above 0 is positive, above 50 is excellent, and above 70 is world-class. Benchmarks vary by industry; for example, software companies often have higher scores than retail.
Can I use Google Forms for transactional NPS (after a purchase)?
Yes, you can create a short NPS survey and send it automatically after a purchase using tools like Zapier or Google Apps Script to trigger the email. However, Google Forms itself does not automate the sending.
How do I protect respondent privacy in Google Forms?
You can turn off “Collect email addresses” in the form settings to keep responses anonymous. Also, avoid asking for personal information unless necessary, and inform respondents how you will use the data.