Import SurveyMonkey Data To Google Sheets

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

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.

Amigo Data in 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.

Create a new developer 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. 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

The 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

Step 3: Get the endpoint of the data to import

The list of endpoints can be found on the API documentation page.

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 endpoint URL as well as the headers are shown 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 results by using the query strings below.

Query parameters

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.

Launch Amigo Data in Google Sheets

Then select Custom API from the list of sources.

List of sources to connect to with Amigo Data

Paste the endpoint URL in the API URL field.

Pasting the endpoint in Amigo Data

Then expand the Details tab and enter the headers. 

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

Example:

Name: sort_order, Value: desc

Name: sort_by, Value: date_modified

Click the PREVIEW button. Flatten the nested datasets. Then click IMPORT.

Preview of the data

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

Snippet of the data

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:

Import Crunchbase Data To Google Sheets

Import Football Data To Google Sheets

Import Holidays List From Holiday API To Google Sheets