Search API Connector Documentation

Print

Import SurveyMonkey Data to Google Sheets

In this guide, we’ll walk through how to automatically pull survey data from the SurveyMonkey API directly into Google Sheets, using the API Connector add-on for Sheets.

Note: Survey Monkey limits direct API access to paid SurveyMonkey plans of TEAM PREMIER and higher. If your plan doesn’t include direct API access, you can use their official Google Sheets plugin instead. Their official plugin is more limited than this method, but can be used with any plan.

Contents

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

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 Survey Monkey Request URL

We’ll first get 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: Pull Survey Monkey API Data into Sheets

Now let’s copy that URL into API Connector.

  1. Open up Google Sheets and click Extensions > API Connector > Open.
  2. In the Create screen, enter the Request URL we just created
    surveymonkey-img6
  3. We don’t need OAuth so leave that set to None.
  4. Under headers, enter a set of key-value pairs like this:
    Authorizationbearer YOUR_ACCESS_TOKEN
    Content-Typeapplication/json

    Replace YOUR_ACCESS_TOKEN with the token you got in the first part of this article.
    surveymonkey-img7

  5. Create a new tab and click Set current to use that tab as your data destination.
  6. Name your request and click Run. A moment later you’ll see a list of your survey IDs populate your Google Sheetsurveymonkey-img8

Part 4: Get More API Data

You can check the documentation for the full list of available API requests,  but if you just want to jump in, you can play around with the URLs you enter in the API URL path field. Try the following (one at a time):

https://api.surveymonkey.com/v3/surveys
https://api.surveymonkey.com/v3/surveys/YOUR_SURVEY_ID/responses/bulk
https://api.surveymonkey.com/v3/users/me
https://api.surveymonkey.com/v3/question_bank/questions
https://api.surveymonkey.com/v3/contacts

Pay special attention to the value(s) reported in the data.id field in the initial /surveys API request. You can use these survey IDs to create new requests that return detailed survey response data.

Part 5: Handle Pagination

By default, Survey Monkey limits responses to 100 records. To get more, use the ‘page’ parameter at the end of your URL, e.g. page=1, page=2, etc.

With API Connector, you can either set these up as separate requests or run through them automatically with pagination handling (paid feature), like this:

  • Pagination type: page parameter
  • Page parameter: page
  • Run until: choose when to stop fetching data
    pagination-page-parameter

Part 6: API Documentation

Official API documentation: https://developer.surveymonkey.com/api/v3/

Previous Import Stripe Data to Google Sheets
Next Import TD Ameritrade Data to Sheets

4 thoughts on “Import SurveyMonkey Data to Google Sheets”

  1. Hi, the URL doesn’t seem to be working with my version. Could you please tell me step by step how to read through the documentation and create it? Or the URL should be same as on your example?

    Reply
    • Hey Chris, I just checked the examples in this article and they are still working for me, so the URLs should be the same. Can you please confirm that you’re on a Survey Monkey plan that allows API access, and that you’ve substituted in your own Access Token into the Header value? If it’s still not working, feel free to contact support so I can investigate.

      Reply

Leave a Reply to Chris Cancel reply

Table of Contents