Connect Google Sheets and each Simplesat response is added to your spreadsheet as a new row. You decide what goes in each column and which surveys are included.
The integration is Sync feedback to Google sheet, under Survey integrations on the Google Sheets page in Simplesat.
Before you start
You'll need:
The Manage integrations permission in Simplesat, to connect Google Sheets and switch the integration on. Owner and Admin have it by default.
A Google spreadsheet with a sheet (tab) for the rows. Set both up in Google Sheets first.
Your own column names in the first row of that sheet. The responses go in the rows below.
A Google account that can edit the spreadsheet. You connect by signing in with it, and it's the account that adds the rows. This is separate from signing in to Simplesat with Google.
To see what a connected tool can read and write, go to Integration security, permissions and data flow.
Connect Google Sheets
In Simplesat, go to Integrations and open Google Sheets.
Click Sign in with Google, sign in with the Google account that can edit the spreadsheet, and allow access.
When the page shows Authenticated with Google Sheets, find Sync feedback to Google sheet under Survey integrations and click Activate integration. You can edit the Field mapping table from this point.
In Field mapping, fill in the two rows that point to your sheet:
Row | What to enter | Example |
Spreadsheet ID | The part of your spreadsheet's web address between | 1AbCdEfGhIjKlMnOpQrStUvWxYz0123456789 |
Sheet Name | The name of the tab, exactly as it appears at the bottom of the spreadsheet | Sheet1 |
For each column you want filled, from A to Z, set Action to Use data from response and pick a value in Field value. A column left on Ignore stays empty.
Click Save under the table.
Under When should this integration run?, keep Every response from all current and future surveys, or choose Let me choose and switch on each survey you want. With Let me choose, every survey starts switched off, including surveys you create later.
Note: Spreadsheet ID and Sheet Name each show a warning triangle because they're required. It stays after you fill them in, and it isn't an error.
Writing feedback back, and mapping the fields explains the Action choices and the rest of the table.
Tip: Before you rely on the integration, send yourself a test response and check that its row arrives. Testing an integration end to end shows how.
What lands in your sheet and when
The columns
The values you can pick in Use data from response include:
Value | What it holds |
Choice (Rating) | The rating the customer gave on the question your metric rating comes from |
Choice Label | That rating's label |
Sentiment | The response's sentiment: positive, neutral or negative |
Follow Up Answer | The comment the customer left with that rating |
Response ID | The response's ID in Simplesat |
Survey Name, Survey ID | The survey the response came from |
Created, Modified | When the response was created and last changed |
Customer Name, Customer Email, Company | The customer who answered |
Team Member Name, Team Member Email | The team member the response is about |
Ticket External ID, Ticket Subject | The ticket's ID in your helpdesk, and its subject |
Response Tags | The response's tags when the row was added |
Choice (Rating), Sentiment and Follow Up Answer work across every survey, so one column can hold every survey's rating.
Every other question has its own entries. To find them, search the list for the survey's name. Each entry starts with the survey's name and the question's text, for example Survey name / Question text / Choice, and ends in one of these:
Choice for a rating, or a question where the customer picks one option
Choices for a question where the customer can pick several options
Comment for a comment box question
Follow-up Answer for the comment left under a rating
The same question in two surveys has two sets of entries, so it takes two columns. A row for one survey leaves the other survey's columns empty.
Your ticket fields, customer attributes and topics aren't in the list.
When rows are added
Each response is added as a new row, below the rows already in the sheet, at least five minutes after it arrives in Simplesat. The row holds the response as it was at that moment, so a comment the customer adds within those five minutes is in the same row.
Rows already in the sheet are never changed. If a response changes after its row was added, for example when the customer answers another question later or a rating is edited, it gets a new row, and its lowest row is the latest. Map Response ID to a column to see which rows belong to the same response.
A mapping change applies only to rows added after you save it.
These never add a row:
Tagging a response.
Hidden and spam responses. A withheld response is added when it's released.
Responses from before you activated the integration.
Responses that arrive while the integration is off. They aren't added later.
Change the Google account or spreadsheet
To send rows to another spreadsheet or tab, change Spreadsheet ID or Sheet Name in Field mapping and click Save. Rows already written stay where they are.
The Google Sheets page doesn't show which Google account is connected, or whether that connection still works. If the Google sign-in expires or is revoked, or the account loses access to the spreadsheet, rows stop being added while the page still shows Authenticated with Google Sheets.
To reconnect, or to switch to another Google account:
Click Revoke access.
Click Sign in with Google and sign in with the account you want. It needs edit access to the spreadsheet.
Sync feedback to Google sheet switches back on by itself if it was on. Check that it shows Deactivate integration, and click Activate integration if it's still off.
Your Field mapping and survey choices are kept. Responses that arrive between Revoke access and signing in again aren't added to your sheet, so do the steps in one go.
Warning: Click Activate integration, not Reset integration. Reset integration puts every setting back to its default, your mapping included, and can't be undone.
Troubleshooting
No rows are arriving in my sheet
Wait at least five minutes after a response arrives. Then check each of these:
The button on Sync feedback to Google sheet reads Deactivate integration, which means it's on.
If you chose Let me choose, the response's survey is switched on.
Spreadsheet ID matches your spreadsheet's web address.
Sheet Name matches the tab name exactly.
You clicked Save under the Field mapping table.
The Google account you signed in with can edit the spreadsheet.
If none of that explains it, send us the response's link from Simplesat. For a response from the last 30 days, we can see why its row failed and run it again once the cause is fixed.
Nothing has reached my sheet since a certain date
Rows stop if the Google sign-in expired or was revoked, or the account lost edit access to the spreadsheet. The page keeps showing Authenticated with Google Sheets either way. Rows also stop if the tab was renamed, because Sheet Name no longer matches.
Fix the cause: update Sheet Name and click Save, or click Revoke access and sign in again with a Google account that can edit the spreadsheet. Sync feedback to Google sheet switches back on by itself if it was on. If it's still off, click Activate integration. Rows that failed aren't added on their own afterward. For responses from the last 30 days, send us their links and we can run them again.
The same response appears in more than one row
A response is sent to the sheet again whenever it changes, for example when the customer answers another question later or a rating is edited, and each send adds a row. The lowest row for a response is the latest. Map Response ID to a column to see which rows belong to the same response.
Some answers are missing from my sheet
A column holds only the value mapped to it, and Choice (Rating), Sentiment and Follow Up Answer cover only the question your metric rating comes from. Map each other question's entries yourself. Search the list for the survey's name to find them, and check you picked the right entry:
For a question where customers can pick several options, map Choices, not Choice.
For the comment under a rating, map Follow-up Answer, not Comment.
A new survey's questions need columns of their own.
A value I want isn't in the Use data from response list
The list holds the response and its answers, the survey, the customer, the team member, and the ticket's ID and subject. Your ticket fields, customer attributes and topics aren't in it. A CSV export from Feedback can include them.
I can't edit the Field mapping table
You can edit the table once Google Sheets is connected and you've clicked Activate integration on Sync feedback to Google sheet for the first time.
Spreadsheet ID and Sheet Name keep showing a warning icon
The triangle marks a required row. It stays after you fill the row in, and it isn't an error.
New rows still go to my old spreadsheet
Check that you clicked Save under the Field mapping table after changing Spreadsheet ID or Sheet Name. The change applies to rows added after you save. If rows still go to the old spreadsheet after that, contact us.
FAQ
Do I have to name the columns in my sheet, or does Simplesat do it?
You name them. Put your column names in the first row of the sheet, and Simplesat adds only the values below them.
Can I send different surveys to different sheets or tabs?
Every survey the integration covers goes to the same sheet, the one in Spreadsheet ID and Sheet Name. Under When should this integration run? you choose which surveys those are.
Can I add responses I already have to the sheet?
Not through the integration, which adds only responses that arrive after you activate it. For earlier ones, export them as a CSV from Feedback and paste them into your sheet.
Can I put the same question from different surveys in one column?
Each survey's question is a separate value in the list, so it takes its own column. The exception is the question your metric rating comes from: Choice (Rating), Sentiment and Follow Up Answer each hold it for every survey in one column.
Which Google account is connected?
The Google Sheets page doesn't show it. If you're not sure, click Revoke access and sign in again with the account you want. Sync feedback to Google sheet switches back on by itself if it was on. If it's still off, click Activate integration. Your mapping and survey choices are kept.
My company doesn't allow Google sign-in for Google Sheets. How else can I get the data?
Export responses as a CSV from Feedback, or read them through the Simplesat API and add them to your spreadsheet yourself.
Can I see a log of what was sent to my sheet?
No. If a response is missing from your sheet, send us its link. For a response from the last 30 days, we can tell you what happened and run it again once the cause is fixed.