SurveyMonkey API To Google Sheets: Import SurveyMonkey Data

How To Import SurveyMonkey API To 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 Google Sheets add-on

To pull data from the SurveyMonkey API to Google Sheets, you’ll first have to install and open the Apipheny Google Sheets add-on:

1. Install Apipheny by clicking the following link and then clicking the Install button on the page: https://gsuite.google.com/marketplace/app/apipheny/966163326746

Install the Apipheny Google Sheets Add-on

2. After you’ve installed Apipheny, open a new or existing Google Sheet. Then, in the menu at the top of the Google Sheet, click on Add-Ons > Apipheny > Import API to open the Apipheny sidebar:

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:

Key: Content-Type
Value: application/json

Key: Authorization
Value: 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, and without the carrots “<>”.

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: