The Scenario
The CX director called a working session to consolidate overlapping surveys. Three different teams have been creating Simplesat surveys over the past two years — some CSAT, some NPS, one CES that nobody remembers setting up — and before she can decide which ones to retire, she needs a complete inventory. Survey name, metric type, and question text, all in one place.
You've been handed this task because you have Simplesat access and a Google Sheet.
The bad version:
- Log into Simplesat and click through each survey one at a time to record its name and metric type
- Open a sheet, manually type each survey name and type into a row
- Go back into each survey to find the specific question wording, copy it, paste it into column C
There are eleven surveys. That's 33 manual copy operations, minimum, across two browser tabs. If any survey has multiple questions, the row count grows. The director needs the inventory before Wednesday's consolidation meeting. It is currently Monday afternoon.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to Simplesat and can list all surveys and their associated questions in one pass, writing everything directly into your sheet.
Open a blank sheet and paste this into the SheetXAI sidebar:
List all surveys in my Simplesat account and write survey ID, name, and metric type (CSAT, NPS, or CES) into columns A, B, and C
What You Get
- Column A: Simplesat survey ID
- Column B: survey name as configured in Simplesat
- Column C: metric type — CSAT, NPS, or CES
- One row per survey, ordered as they appear in your Simplesat account
- Active and inactive surveys both included unless you specify otherwise
What If the Data Is Not Quite Ready
You need the question text included alongside the survey metadata
List all surveys in my Simplesat account and write survey ID, name, metric type, and the primary question text into columns A through D
The director wants only active surveys, not archived ones
List all active surveys in my Simplesat account and write survey ID, name, and metric type into columns A, B, and C — exclude any surveys that are paused or archived
You need to group surveys by metric type to make the consolidation conversation easier
List all surveys in my Simplesat account and write survey ID, name, and metric type to columns A through C, then below the full list add a grouping summary showing how many surveys exist per metric type
You want the complete audit package — surveys, question text, response counts — in one pass
List all surveys in my Simplesat account, write survey ID, name, metric type, and primary question text to columns A through D, then add a column E with the total number of responses each survey has collected
Full picture in one shot: what exists, what it asks, and how much data is behind it.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, then ask it to list all your Simplesat surveys and questions into columns. See the account-level CSAT import spoke for pulling response data once the audit is done, or return to the Simplesat hub for all four methods.