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:
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
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:
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:
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:
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:
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:
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:
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:
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: