Creating and conducting an online survey to gather data and sentiments about an event or a service or product, for which SurveyMonkey is the number go-to resource, is not the end of it. In fact, if we leave it at that, then the survey may not yield many benefits.
To make the most of your survey, you could import the survey data into Google Sheets from SurveyMonkey. This way you can not only share the survey results with your teammates but also have all the aggregated data in one place and do a proper analysis.
For this–and also many others which we’re not going to be distracted with for the moment–you can use Amigo Data, an extension for Google Sheets to pull the data automatically. It obviates the need for you to manually download, extract the responses, track the trends, etc. Amigo does all this automatically. You can get more with less.
So, let us learn how to import SurveyMonkey data to Google Sheets with Amigo Data. But before we dive in, here are the elements we’ll need to import SurveyMonkey to Google Sheets:
- Amigo Data
- SurveyMonkey API Access Token
- The endpoint of the data to import
We’ll learn to get each of these step by step.
How to import SurveyMonkey data to Google Sheets
Step 1: Install the Amigo Data extension in Google Sheets
Install the Amigo Data Google Sheets add-on from the Google Workspace Marketplace.
Click here to install.
Alternatively, you can get it from Google Sheets.
- Open a new sheet
- Go to Extensions→Add-ons→Get add-ons
- Search for Amigo Data and install
Step 2: Get the SurveyMonkey API Access Token
Log in to the SurveyMonkey developer portal using your SurveyMonkey account
Register an app by clicking the Create New App button. You can also add a new app from My Apps section.
Enter the app name and your email address. Then select the Private App option and click the Create App button.
Private apps can be used to retrieve one’s own surveys and that of one’s team. Public apps can be used by anyone with a SurveyMonkey account.
Upon registration, a draft app will be created with an access token which we can use to get data from our account for 90 days. Before the 90 days draft period ends we must deploy the app either as public or private; else it’ll be disabled.
Click SETTINGS from the app overview to find the access token
Scroll to the Scopes section and set the scopes you need to either Required or Optional and then click Update Scopes.
Step 3: Get the endpoint of the data to import
The list of endpoints can be found on the API documentation page.
Click on an endpoint category, eg, Survey Pages and Questions and click on the endpoint (say, surveys – the surveys endpoint will return a list of all the surveys).
The endpoint URL as well as the headers are shown on the right side of the page under Code samples.
This sample URL will return all the surveys associated with your account.
We can customise the URL to filter the results by using the query strings below.
For example, to retrieve a list of surveys modified between January 1, 2022 and October 31, 2022, and arranged reverse chronological order (descending), the url will be as given below.
We can also add the queries in Amigo Data without having to append them in the URL. (Shown below)
Step 4: Import the data to Google Sheets
Now to back to Google Sheets and launch Amigo Data by clicking Extensions→Amigo Data→Connect.
Then select Custom API from the list of sources.
Paste the endpoint URL in the API URL field.
Then expand the Details tab and enter the headers.
To filter the results, we can add the query parameters here.
Click the +QUERY and add the query strings–the names and the values.
Name: sort_order, Value: desc
Name: sort_by, Value: date_modified
Click the PREVIEW button. Flatten the nested datasets. Then click IMPORT.
After a little while, the data from Survey Monkey will be imported into Google Sheets.
To get a list of the responses for a survey, use this endpoint:
Here, 509340605 is the survey ID, which can be got by using the survey list endpoint.
We can likewise import contacts, response counts and trends, and get them automatically updated so that there is no need to import the data each time we want to get the latest updated data. Click here to learn how to set a refresh schedule in Amigo Data and set up alerts to get the updated data into your inbox or Slack.
For an expanding list of data that you can import to Google Sheets using the Amigo Data add-on, visit our blog.
Here are some articles to sate your curiosity: