NPS Tracking in Google Sheets: Formulas and Benchmarks
Send your 0-10 feedback form into Google Sheets, classify promoters and detractors by formula, calculate a monthly NPS, benchmark it honestly, and close the loop with detractors within 48 hours.
In This Guide
- Why Track NPS in Google Sheets?
- How Does the NPS Question Work?
- How Do You Build the NPS Form in WordPress?
- Getting Responses Into the Sheet Automatically
- The Promoter, Passive, Detractor Formula
- How Do You Calculate NPS Monthly?
- What Counts as a Good NPS?
- Closing the Loop With Detractors Within 48 Hours
- Charting the NPS Trend
- Next Step: One Question, One Sheet, One Habit
- Frequently Asked Questions
Why Track NPS in Google Sheets?
NPS tracking in Google Sheets means sending your 0-10 survey responses into a sheet that classifies promoters and detractors by formula, calculates a monthly score, and charts the trend. It works because NPS is deliberately simple - and context helps: the global average NPS is 32 across 150,000+ organizations (SurveyMonkey).
You do not need survey SaaS to run it. A WordPress form with one number field and one open question, connected to a sheet, produces the same score the enterprise tools calculate - plus the raw responses in a file you own, ready for any formula or chart you want.
This guide covers the whole loop: the question format, the promoter/passive/detractor formula, the monthly NPS calculation, industry benchmarks to compare against, a 48-hour detractor follow-up routine, and a trend chart that makes the number legible to the rest of the team.
How Does the NPS Question Work?
NPS asks one question: "How likely are you to recommend us to a friend or colleague?" on a 0 to 10 scale. Scores of 9 or 10 are promoters, 7 or 8 are passives, and 0 to 6 are detractors. NPS is the percentage of promoters minus the percentage of detractors, producing a score from -100 to +100.
The strict cutoffs surprise people. A 6 sounds respectable, but the methodology counts every 0 to 6 as a detractor, and passives vanish from the score entirely. That harshness is the point: the metric only rewards genuine enthusiasm, and it punishes lukewarm satisfaction that quietly churns later.
Always pair the number with an open follow-up: "What's the main reason for your score?" The score gives you a trend to watch; the verbatim answers tell you what to actually fix. A score without verbatims is a thermometer with no diagnosis.
How Do You Build the NPS Form in WordPress?
Build it with three fields: the 0-10 question as a radio or select field labeled 0 through 10, the open "why" question as a textarea, and the respondent's email. Any of the major WordPress form plugins handles this in minutes, and the survey lives on your own domain instead of a third-party page.
Keep the score as discrete choices, never a free text box. Clean integers feed formulas; answers like "maybe an 8?" break them. Capture email if you intend to close the loop with detractors - a fully anonymous NPS gives you a score you cannot act on for any individual customer.
Timing shapes the number, so pick one trigger and hold it constant: post-purchase, after a support ticket closes, or a quarterly email. If you want to tune wording or placement, A/B testing WordPress forms with results in Google Sheets shows how to compare variants fairly. For richer scored surveys beyond one question, see quiz and assessment forms with scoring in sheets.
Getting Responses Into the Sheet Automatically
Connect the form directly to Google Sheets so every response lands as a timestamped row. SheetLink Forms does this in real time - connect with the one-click Google Sheets connect (v1.12.0) or the classic Apps Script receiver deployed in your own Google account - no Zapier and no per-response fees, which matters when a survey goes out to your entire customer base at once.
- Install the free plugin from WordPress.org - it supports 12 major form plugins, including Contact Form 7, WPForms, and Fluent Forms.
- Connect Google Sheets following the Google Sheets setup guide: click Connect Google and pick or create the sheet in the Google file picker (about a minute), or deploy the classic OAuth-free Apps Script receiver.
- Map the score, comment, and email fields to columns.
- Submit a test response and confirm the row and timestamp arrive.
Point raw responses at a "Responses" tab and do all formula work on a separate "Scoring" tab. Untouched raw data means a mis-dragged formula never corrupts the source, and the automatic retry queue re-delivers any response that fails to send during a traffic spike.
The Promoter, Passive, Detractor Formula
One formula classifies every response. With scores in column B: =IFS(B2>=9, "Promoter", B2>=7, "Passive", B2<=6, "Detractor"). Scores of 9 or above become promoters, 7 or 8 passives, and 6 or below detractors, exactly matching the standard NPS cutoffs.
Rather than filling the formula down by hand, use an array version in the header row so new responses classify themselves as they arrive: =ARRAYFORMULA(IF(B2:B="",, IFS(B2:B>=9,"Promoter", B2:B>=7,"Passive", B2:B<=6,"Detractor"))). Every row your form delivers gets a category with zero manual work.
Add one more helper column, a month key: =TEXT(A2, "YYYY-MM") against the timestamp in column A. Category plus month key power everything downstream - the monthly score, the trend chart, and the detractor queue. More patterns like these live in Google Sheets formulas every lead sheet needs.
How Do You Calculate NPS Monthly?
Monthly NPS is promoters minus detractors, each as a percentage of that month's responses. With category in column D and month key in column E: =ROUND((COUNTIFS(D:D,"Promoter",E:E,G2) - COUNTIFS(D:D,"Detractor",E:E,G2)) / COUNTIFS(E:E,G2) * 100), where G2 holds a month key such as 2026-08.
Build a small summary table on the Scoring tab: month keys down column G, a response count beside each, and the NPS formula in the next column. Watch the response count as closely as the score - a month with nine responses swings wildly, so many teams show a rolling three-month score alongside the monthly one to separate signal from noise.
Sanity-check the output. The result must sit between -100 and +100, all-promoter months read exactly 100, and a month of pure passives reads 0. If a number looks impossible, the usual culprit is a blank category from a malformed score, which the Responses tab will show in seconds.
What Counts as a Good NPS?
Compare against your industry, not a universal number. The global average NPS is 32, and the top quartile of organizations score 72 or higher (SurveyMonkey). 2026 industry benchmarks show a wide spread: B2B software and SaaS averages 41, ecommerce and retail 61, and technology and services 63 (Retently, 2026).
The spread is why context matters: a SaaS product scoring 45 sits above its peers, while a retailer at 45 trails well behind. And your own trend beats any external benchmark. Moving from 28 to 38 over two quarters is a stronger signal than any single reading, because your survey timing, audience, and channel stay constant while published benchmarks mix all three.
Benchmark honestly, too. Surveying only recent purchasers, or only customers fresh from a pleasant support interaction, inflates the score and hides churn risk. Send the survey to a consistent slice of your whole base and let the number be what it is.
Closing the Loop With Detractors Within 48 Hours
A detractor response should trigger a personal follow-up within 48 hours, while the frustration is fresh and the relationship is still recoverable. Add three columns to the sheet - contacted date, owner, and outcome - and start each morning by filtering for detractors with a blank contacted date.
A 0-6 scorer who left a comment has handed you a churn warning with the reason attached. A short, non-defensive reply works best: "You scored us 3 and mentioned slow support - can I ask what happened?" Asked within two days, that question routinely turns a complaint into a fix; asked a month later, it reads as an afterthought.
You can semi-automate the nudge while keeping the reply human. A formula-flagged detractor queue plus a scheduled reminder keeps the list visible; automating follow-up emails from Google Sheets shows the pattern. Just never template the apology itself - a canned reply to an angry customer makes things worse.
Charting the NPS Trend
A trend chart makes the score legible to everyone who will never open the formulas. From the monthly summary table, insert a line chart of month against NPS, fix the axis to a sensible band, and add the response count as a second series so small-sample months are visibly noisy rather than misleadingly precise.
For an in-cell version, =SPARKLINE(H2:H13) draws the twelve-month trend in a single cell - useful at the top of the Responses tab where anyone landing in the sheet sees the direction of travel immediately. A stacked column chart of promoter, passive, and detractor counts per month adds the mix shifts the headline number hides: a flat NPS can mask passives quietly becoming detractors.
If NPS feeds wider reporting, fold it into one dashboard with your lead and revenue numbers; building dashboards from WordPress data in Google Sheets covers charts, sparklines, and pivot tables in depth.
Next Step: One Question, One Sheet, One Habit
Ship the smallest version this week: a three-field form, a direct connection to a sheet, the IFS classifier, and one monthly NPS cell. The whole build takes about an hour, and a month of real responses will teach you more than another week of comparing survey tools.
Then protect the habit: same question, same trigger, every month, with detractor follow-up inside 48 hours. Consistency is what makes the score mean something. For the broader pattern of running customer data through spreadsheets you own, see tracking leads in Google Sheets.
Frequently Asked Questions
How do you calculate NPS in Google Sheets?
Classify each 0-10 score with =IFS(B2>=9,"Promoter",B2>=7,"Passive",B2<=6,"Detractor"), then subtract the detractor percentage from the promoter percentage using COUNTIFS over the period you want. The result runs from -100 to +100, and a month-key helper column makes the monthly version one formula.
What is a good NPS score?
It depends on your industry. The global average is 32 and the top quartile score 72 or higher, per SurveyMonkey's data across 150,000+ organizations. Retently's 2026 benchmarks put B2B SaaS at 41, ecommerce and retail at 61, and technology and services at 63, so compare within your category.
What score counts as a detractor in NPS?
Any response from 0 to 6 counts as a detractor, 7 and 8 are passives, and only 9 and 10 count as promoters. The cutoffs feel harsh by design: the metric rewards genuine enthusiasm and treats lukewarm scores as churn risk rather than success.
Can an NPS score be negative?
Yes. NPS ranges from -100, where every respondent is a detractor, to +100, where every respondent is a promoter. A negative score means detractors outnumber promoters, which is common for early products and a clear signal to prioritize the open-text feedback over new surveying.
How many responses do I need for a reliable NPS?
There is no magic threshold, but small samples swing hard: one response changing category moves a ten-response month by ten points. Show the response count next to every score, and use a rolling three-month figure alongside the monthly one until your volume steadies.
How often should I send an NPS survey?
Pick one trigger and keep it constant: post-purchase, after support interactions, or a quarterly email to your whole base. Consistency matters more than frequency, because changing the timing or audience changes the score for reasons that have nothing to do with your product.
Do I need survey software to track NPS?
No. A WordPress form with a 0-10 field, a comment box, and an email field, connected directly to Google Sheets, produces the same score the dedicated tools calculate. You keep the raw responses in your own account and skip a per-response subscription entirely.
How quickly should I follow up with a detractor?
Within 48 hours, while the frustration is fresh and the customer is still recoverable. Track contacted date, owner, and outcome columns in the sheet, and filter for detractors with a blank contacted date each morning so nobody slips through the queue.
More Lead Management guides
Pipe NPS responses straight into your sheet
Send WordPress survey responses to Google Sheets in real time - no Zapier, no per-response fees, no survey SaaS required.