Creating and conducting an online survey to gather data and sentiments about an event or 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 integrate SurveyMonkey with Google Sheets and import the survey data from SurveyMonkey to Google Sheets. 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 which Google Sheets is excellent.
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 in 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 create a SurveyMonkey-Google Sheets integration and pull SurveyMonkey data to Google Sheets.
Steps to import SurveyMonkey data to Google Sheets with SurveyMonkey API.
- Install the Amigo Data extension
- Get the SurveyMonkey API access token
- Choose a SurveyMonkey API endpoint
- Import the SurveyMonkey data to Google Sheets
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 to import SurveyMonkey data to Google Sheets using SurveyMonkey API.
Alternatively, you can get it from Google Sheets.
- Open Google Sheets
- Go to Extensions→Add-ons→Get add-ons
- Search for Amigo Data and install it.
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 with SurveyMonkey API. 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 SurveyMonkey API 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: Choose a SurveyMonkey API endpoint
The list of endpoints that we can use to import SurveyMonkey data to Google Sheets can be found on the Survey Monkey 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 SurveyMonkey API endpoint URL as well as the headers are given 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 data SurveyMonkey data to import to Google Sheets 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 in reverse chronological order (descending), the SurveyMonkey API URL will be as given below.
https://api.surveymonkey.com/v3/surveys?sort_order=desc&start_modified_at=2022-01-01&end_modified_at=2022-10-31
We can also add the SurveyMonkey API queries in Amigo Data without having to append them to the URL. (Shown below)
Step 4: Import the data to Google Sheets
Now to back to Google Sheets and launch Amigo Data to import SurveyMonkey data to Google Sheets by clicking Extensions→Amigo Data→Connect.
Then select Custom API from the list of sources.
Enter the SurveyMonkey API endpoint URL in the API URL field.
Then expand the Details tab and enter the headers given in the Code Samples.
The SurveyMonkey API headers are:
Header 1 Name: Accept Value: application/json Header 2 Name: Authorization Value: Bearer your_api_access_token
To filter the results of the SurveyMonkey data to import to Google Sheets, we can add the query parameters here (if you haven’t appended them to the URL).
Click the +QUERY and add the query strings–the names and the values.
Example:
Name: sort_order, Value: desc
Name: sort_by, Value: date_modified
Click the PREVIEW button to retrieve the SurveyMonkey data to extract to Google Sheets. 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:
https://api.surveymonkey.com/v3/surveys/509340605/responses
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, question bank, contacts list, and a lot more with SurveyMonkey API. To explore the Survey Monkey API and learn what you can do with it, visit the SurveyMonkey API documentation.
Automatically import SurveyMonkey API data
After you’ve integrated SurveyMonkey API with Google Sheets and imported data from SurveyMonkey to Google Sheets, you need not for the second or third time import the data manually.
You can set a refresh schedule and Amigo will pull the SurveyMonkey data to Google Sheets automatically according to the time and frequency you’ve set–hourly, daily, weeky, or whenever.
And not just that, Amigo is your perfect companion for colloboration: it’ll send you alerts of the data via email or Slack to all your team members. 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: https://blog.tryamigo.com.
Some commonly asked questions
How do I connect my SurveyMonkey account to Google Sheets?
Your SurveyMonkey account will be connected to Google Sheets when you make an import with Amigo using SurveyMonkey API. No further or additional connection is necessary.
What data can I import from SurveyMonkey to Google Sheets?
You can import varied data from SurveyMonkey to Google Sheets with SurveyMonkey API. Some examples include survey lists, survey folders, contact lists, question banks, survey responses, and response counts and trends among others.
How do I schedule automatic updates of my imported data?
To schedule automatic updates of the SurveyMonkey data imported into Google Sheets, set the refresh schedule timing and frequency from the sidebar when you successfully imported SurveyMonkey data to Google Sheets. Then click “Yes, set the refresh schedule timing”.
You can also set it up later. Launch Amigo, click “View reports”, select the import, and set the refresh schedule.
How do I handle pagination when exporting large amounts of data?
You can use the page and the per_page fields to indicate the page number and page size of the requested data.
For example, to retrieve the second page of 100 results, the following endpoint URL would be used.
https://api.surveymonkey.com/v3/surveys?page=2&per_page=100
And to get the next 100 surveys, set the page to 3. And 4 for the fourth page, and so on.
Here are some articles you my find useful:
Connect HubSpot to Google Sheets