Integrate SurveyMonkey API with Google Sheets [Tutorial]

How to import SurveyMonkey data into Google Sheets

SurveyMonkey is one of the most popular online survey development platforms, offering a wide range of tools for creating, managing and analyzing surveys.

SurveyMonkey offers an API that can be used in apps created on their platform, allowing users to automate various interactions with their accounts. These include managing users and teams, surveys and questions, as well as responses and trends.

This tutorial will walk you through the steps required to connect the SurveyMonkey API to Google Sheets, using the Apipheny Google Sheets add-on:

Step 1: Install the Apipheny add-on
Step 2: Create a SurveyMonkey Draft App
Step 3: Get a SurveyMonkey API Access Token
Steps 4 & 5: Use Apipheny to import SurveyMonkey API

Step 1.) Install and open the Apipheny add-on for Google Sheets

Apipheny is an API connector for Google Sheets. You can use Apipheny to connect your Google Sheets to unlimited API data sources, make unlimited API requests, and more. There is a 30 day free trial included.

1.) Install Apipheny by opening the following link on desktop and then clicking the Install button in the Google Marketplace: https://apipheny.io/install

2.) After you’ve installed Apipheny, open a Google Sheet and then click on the Extensions dropdown in the menu at the top.

In the dropdown list you should see Apipheny. Click Apipheny then click Import API to open the Apipheny sidebar in your Google Sheet.

Tip: you can open a new Google Sheet by entering this URL in your browser: sheet.new

Step 2: Create a SurveyMonkey Draft App

To access the SurveyMonkey API, you’ll need to create a draft app in your SurveyMonkey account. The Draft App gives you 90 days to develop using the SurveyMonkey API, with access only to your own account.

After 90 days you’ll need to deploy it either as a public or as a private app. A public app is available to anyone with a SurveyMonkey account, while a private app can only access accounts for members of your organization.

For this example we’ll be using a private draft app, since it allows the API to be accessed using only the access token generated when creating the app. This token can be found in your app’s Settings.

To create a draft app, follow these steps:

Log in to your Developer Dashboard, by accessing https://developer.surveymonkey.com
Go to the My Apps menu item
Click on the Add a New App button:

After clicking Add a New App, enter a name for your app and then select the app type.

Then choose Private App and then click the Create App button:

Enter a nickname, choose an app type, and click Create App

Step 3: Obtain an SurveyMonkey API Access Token

To authenticate requests to the SurveyMonkey API from a private app such as Apipheny, you only need the access token that is automatically generated when creating the app.

Just go to your newly created app’s Settings page, scroll down to the Credentials section and copy the value in the Access Token field:

Step 4: Enter Your SurveyMonkey API Request in the Apipheny Add-on

Copy your URL for the SurveyMonkey API endpoint into the Apipheny add-on, in the API URL Path field, followed by any GET parameters required for your query.

You can learn the different types of URLs you can create in their developer documentation, under API Endpoints.

In this example, let’s use the URL for the endpoint that returns the list of surveys you created in your account:

https://api.surveymonkey.com/v3/surveys

Just copy and paste that URL in the “API URL” field in Apipheny.

Next, select the HTTP method (GET or POST) required by your API endpoint. For this example, leave is as “GET”.

Into the Headers section in Apipheny, add two rows with the following keys and values:

Header Key 1:
Content-Type

Header Value 1:
application/json

Header Key 2:
Authorization

Header Value 2:
Bearer your_access_token

your_access_token is the value you previously obtained in Step 3. Enter it after “Bearer”, with a space in between.

This is what your request should look like in the Apipheny add-on:

Add SurveyMonkey API URL and Headers in Apipheny

Step 5: Run the Surveymonkey API Request

The final step to Get SurveyMonkey API data into Google Sheets is to click the Run button at the bottom of the Apipheny add-on and wait for the results to be fetched and added to your spreadsheet: