Import SurveyMonkey Data To Google Sheets

How to import SurveyMonkey data to Google Sheets
Reading Time: 6 minutes

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.

  1. Install the Amigo Data extension
  2. Get the SurveyMonkey API access token
  3. Choose a SurveyMonkey API endpoint
  4. 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.

Click here to install

Install Amigo Data to import SurveyMonkey data to Google Sheets

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.

Create a SurveyMonkey API app

Enter the app name and your email address. Then select the Private App option and click the Create App button.

Entering the details and selecting the app type

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.

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.

The list of scopes to access SurveyMonkey API

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.

SurveyMonkey API Endpoint categories

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). 

List of endpoints for the surveys category

The SurveyMonkey API endpoint URL as well as the headers are given on the right side of the page under Code samples.

The endpoint URL and headers

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.

SurveyMonkey API query parameters

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.

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.

Launch Amigo Data to import SurveyMonkey data to Google Sheets

Then select Custom API from the list of sources.

List of sources to connect to with Amigo Data

Enter the SurveyMonkey API endpoint URL in the API URL field.

Entering the SurveyMonkey API endpoint in Amigo Data

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
Entering the headers

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.


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.

Preview of the SurveyMonkey data to import to Google Sheets

After a little while, the data from Survey Monkey will be imported into Google Sheets.

Snippet of the SurveyMonkey data 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, 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:

Some commonly asked questions

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.

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.

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.

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.

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

Connect and Automate Shopify Exports to Google Sheets

Import Holidays List From Holiday API To Google Sheets

Leave a Reply