The Simplesat connector adds your survey responses to Data Studio as a data source, so they can sit in the same reports as the rest of your data. You connect it with a Simplesat API key, and nothing is written back to Simplesat.
Google renamed Looker Studio to Data Studio in April 2026, and your existing reports and data sources moved over on their own.
Before you start
A Simplesat API key with Full access, or Custom with Read on both Answers and Responses. The Legacy account key also works.
To create the key, the Owner or Admin role, or a custom role with Access API key. API keys are available on every Simplesat plan.
Any key reads responses from every survey in your workspace, whoever created the key.
For creating and managing keys, see API keys.
Connect Data Studio
In Simplesat, go to Admin → API keys, then create a key with Full access, or Custom with Read on Answers and Responses, and copy it. The key is shown only once.
In Data Studio, click Create, then Data source.
Search for Simplesat and select the Simplesat connector.
If Data Studio asks, give the Simplesat connector access to your Google account.
When Data Studio asks for your API key, paste it.
In the upper right, click CONNECT, then CREATE REPORT.
You can also start in Simplesat: the Looker Studio entry on the Integrations page opens Data Studio's connector gallery and searches it for Simplesat.
What lands in Data Studio, and when
You get one row for each response, from every survey, whose created date falls within the report's date range.
Heads up: If the report has no date range, the connector reads only the last 28 days. To see other dates, add a date range control to the report, or change the report's default date range.
The data source has these fields:
Fields | What they hold |
| The response ID, when the response was created, and when it last changed |
| The survey |
| The response's tags, separated by commas |
| The ticket ID and subject from the tool the survey came from |
| One for each ticket field |
| The customer |
| One for each customer attribute |
| One set for each team member on the response: name, email, role and ID |
| One set for each answer: |
| The response's language, where it came from, and the IP address it was sent from |
The answer sets are numbered by the question's position in its survey, so answers_1 holds a different question in each survey. To keep each survey's questions apart, use the question_text and question_metric fields, or filter on survey_name. There's no CSAT or NPS score field. You calculate scores from the ratings in choice.
Each time Data Studio refreshes the report's data, it reads every response in the date range again, so edits and deletions in Simplesat show up at that point. A ticket field or customer attribute added in Simplesat can take up to 6 hours to join the connector's field list. After that, click REFRESH FIELDS at the bottom left of the data source editor, then APPLY.
Change the API key
The connector saves your key for your Google account. To switch to a new key:
In Simplesat, create the new key and copy it.
If any other tool uses the old key, switch it to a new key first. Once you delete the old key, it stops working everywhere.
Delete the old key on Admin → API keys.
With the old key gone, the data stops loading. When Data Studio asks you to authorize the connector again, paste the new key.
If Data Studio doesn't ask, go to its Data sources tab, open the three-dot menu at the upper right of the Simplesat connector's card, and click Revoke Access. Then give the connector access again as in Connect Data Studio, and paste the new key when asked.
If the saved key is deleted, or a Custom key loses Read on Answers or Responses, the data stops loading until you paste a working key.
Troubleshooting
Data Studio won't accept my API key
Check that you copied the whole key.
Check the key's access. It must be Full access, or Custom with Read on both Answers and Responses. A Custom key with Responses only is rejected.
Check on Admin → API keys that the key still exists.
Data Studio only shows the last four weeks of responses
When a report has no date range, the connector reads the last 28 days. To see older responses, add a date range control to the report, or change its default date range.
A new ticket field or customer attribute doesn't show up in Data Studio
The field list can take up to 6 hours to include a field added in Simplesat. After that, click REFRESH FIELDS at the bottom left of the data source editor, then APPLY.
FAQ
Does the data in Data Studio update by itself?
Yes, each time Data Studio refreshes the report's data. It reads the responses in the date range again. To see the latest responses right away, refresh the data yourself.
Can I get our CSAT or NPS score from the connector?
No. The data has each answer's rating, label and sentiment, and you calculate the score from the ratings.
Can I bring in only some surveys?
No, the connector reads every survey in your workspace. To show only the surveys you want, filter on survey_name.
Does the connector work with Looker?
No. Looker, Google Cloud's BI platform, is a different product from Data Studio and doesn't use Data Studio connectors. To get Simplesat data into Looker, copy your responses into Google BigQuery with the Google BigQuery integration and connect Looker to BigQuery, or read them with the Simplesat API. Google BigQuery integrations and API & webhooks cover both.