The Scenario
Your skip-level just asked for a combined view of all three NPS surveys — not a summary, the raw responses — by end of week.
You run a Mopinion report that aggregates your post-onboarding, in-app, and post-support NPS datasets. Together they represent 600 responses from Q1. Your manager wants them in a single Excel workbook alongside revenue data so finance can run their own cut. You're the one who has to get the data there.
The bad version:
- Export each of the three underlying datasets separately as CSV files from the Mopinion interface.
- Import each one into a different sheet, reconcile the column headers across all three (they're not identical — different surveys, different custom fields), and merge them manually into a single flat table.
- Discover that the combined file is missing the NPS score from the in-app survey because that field is named differently there, and spend another 40 minutes tracking it down.
Nobody told you the field names would diverge across datasets. Nobody told you they'd need to be reconciled by hand. You're the one who found out.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet and connects directly to Mopinion — so instead of exporting and merging three datasets by hand, you pull the whole report in one ask.
Fetch all feedback items from Mopinion report ID 22511 and list each response with timestamp, NPS score, and open-text comment in the Responses tab.
What You Get
- Every response from all datasets in report 22511 lands in a single flat table in the Responses tab.
- Columns: timestamp, NPS score, open-text comment — one row per submission, regardless of which dataset it came from.
- The row count matches the total across all three underlying surveys.
- The tab is ready to share with finance without any additional cleanup.
What If the Data Is Not Quite Ready
The NPS score field has different names across datasets
One dataset uses "nps_score," another uses "rating." You need them in one consistent column.
Fetch all feedback from Mopinion report 22511 and write each response to the Responses tab. Normalize the score field — if the response has nps_score use that, if it has rating use that — and write the value into a single Score column.
You only need responses from one quarter, not the full history
The report goes back 18 months, but you need Q1 2026 only.
Pull all feedback from Mopinion report 22511 submitted between 2026-01-01 and 2026-03-31 and write each response to the Q1 tab with timestamp, score, open-text comment, and dataset name.
You need to flag which dataset each response came from
Finance wants to know whether a given row came from post-onboarding, in-app, or post-support.
Fetch all feedback from Mopinion report 22511 and write each response to the Responses tab. Add a Source column that shows the dataset name for each row.
Pull, clean, and format for the executive deck in one step
The deck needs a clean table with no blank comment rows and a count of promoters (9–10), passives (7–8), and detractors (0–6).
Pull all responses from Mopinion report 22511, skip rows with a blank open-text comment, write the clean responses to the Data tab, then add a Summary section below with total count, promoter count (score 9–10), passive count (7–8), and detractor count (0–6).
The practical pattern: pull the data and run the segmentation in the same ask, rather than pulling first and computing separately.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet where you're preparing NPS analysis. Pull your Mopinion report data with one prompt, then see how to compute summary statistics from that data or review the full Mopinion integration guide.