Import SurveyMonkey Data to Google Sheets

Import SurveyMonkey Data to Google Sheets

Last Updated On August 16, 2019
You are here:
< Back

Survey Monkey is a popular tool for creating online surveys. In this guide, we’ll walk through how to automatically pull survey data from the Survey Monkey API directly into Google Sheets, using the free API Connector add-on. This enables more options than their official Google Sheets plugin, which has limited functionality. We’ll first get an Access Token from Survey Monkey, and then set up a request to pull in metrics from Survey Monkey to your spreadsheet.

Note: To use Survey Monkey’s API, you must have a paid SurveyMonkey plan that includes API access. Currently that means you must be on a TEAM PREMIER plan. If you don’t have API access, you can still use the Google Sheets plugin linked above.

PART 1: GET YOUR SURVEY MONKEY ACCESS TOKEN

  1. Log in to Survey Monkey and click the Developers link in the footer (or just navigate directly to https://developer.surveymonkey.com/).
    surveymonkey-img1

  2. Click My Apps in the header. (https://developer.surveymonkey.com/apps/)
    surveymonkey-img2

  3. Click ‘Add a New App’
    surveymonkey-img3

  4. You can call your app anything, but we’ll call it Google Sheets. Since we only need to access our own Survey Monkey account, choose Private App and click the ‘Create App’ button.
    surveymonkey-img4

  5. Click on the Settings tab. Scroll down for your Access Token! Keep it handy as we’ll need this in a moment.
    surveymonkey-img5

  6. Click the Deploy button up top to deploy your new app.

PART 2: CREATE YOUR API REQUEST URL

We’re going to follow the Survey Monkey API documentation to request a list of survey IDs. This will be useful for constructing your other API requests.

  • Base URL:https://api.surveymonkey.com/v3
  • Endpoint: /surveys

Putting it together, we get the full API Request URL:
https://api.surveymonkey.com/v3/surveys

PART 3: ENTER VALUES INTO API CONNECTOR

We can now enter all our values into API Connector to start importing Survey Monkey data into Google Sheets.

  1. Open up Google Sheets and click Add-ons > API Connector > Create New API Request.
  2. In the Create Request interface, enter the Request URL we just created
    surveymonkey-img6

  3. Under headers, enter a key-value pair like this:
    Authorization bearer {Access Token}
    Content-Type application/json

    Replace {Access Token} with the token you got above in step 5.
    surveymonkey-img7

  4. Create a new tab. You can call it whatever you like, but here we’ll call it ‘Survey IDs’. While still in that tab, click ‘Set’ to use that tab as your data destination.
  5. Name your request. Again we’ll call it ‘Survey IDs’
  6. Click Run and a moment later you’ll see a list of your survey IDs populate your Google Sheet

PART 4: NOTES AND EXPANSIONS

  1. You can now use these IDs to create new requests, just follow the documentation. For example, creating a call to https://api.surveymonkey.com/v3/surveys/{id}/responses/bulk, where you replace {id} with your survey ID, will fetch the first 100 responses to your survey.
  2. You can also make use of the ‘page=#’ query string to get more responses. A request to https://api.surveymonkey.com/v3/surveys/{id}/responses/bulk?page=2 will return the second page of responses.

Comments:0

Leave a Reply

Your email address will not be published.