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:
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:
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:
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:
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:
Schedule requests for automatic updates
Reference cell values in requests
Stack multiple URLs in a single request
Run all saved requests at once
Crypto API tutorials and more: