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. This enables more options and flexibility than their official Google Sheets plugin. 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 your plan doesn’t enable API access, you can still use their own Google Sheets plugin linked above.
CONTENTS
- Before You Begin
- Step 1: Get Your Survey Monkey Access Token
- Step 2: Create your API Request URL
- Step 3: Pull Survey Monkey API Data into Sheets
- Step 4: Get More Data & Handle Pagination
BEFORE YOU BEGIN
Click here to install the API Connector add-on from the Google Marketplace.
STEP 1: GET YOUR SURVEY MONKEY ACCESS TOKEN
- Log in to Survey Monkey and click the Developers link in the footer (or just navigate directly to https://developer.surveymonkey.com/).
- Click My Apps in the header. (https://developer.surveymonkey.com/apps/)
- Click ‘Add a New App’
- 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.
- Click on the Settings tab. Scroll down for your Access Token! Keep it handy as we’ll need this in a moment.
- Click the Deploy button up top to deploy your new app.
STEP 2: CREATE YOUR SURVEY MONKEY API REQUEST URL
We’re first 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
STEP 3: PULL SURVEYMONKEY API DATA INTO SHEETS
Now let’s enter our URL into API Connector and import Survery Monkey data into Google Sheets.
- Open up Google Sheets and click Add-ons > API Connector > Open.
- In the Create screen, enter the Request URL we just created
- Under headers, enter a set of key-value pairs like this:
Authorization bearer YOUR_ACCESS_TOKEN Content-Type application/json Replace YOUR_ACCESS_TOKEN with the token you got above in step 5.
- Create a new tab and click ‘Set current’ to use that tab as your data destination.
- Name your request and click Run. A moment later you’ll see a list of your survey IDs populate your Google Sheet
STEP 4: GET MORE DATA & HANDLE PAGINATION
- 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/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. For example, this call will fetch information on the first 100 responses to your survey:https://api.surveymonkey.com/v3/surveys/YOUR_SURVEY_ID/responses/bulk
Replace YOUR_SURVEY_ID with your survey ID.
- You can also make use of the ‘page’ query string to get more responses, like this:
page 1:
https://api.surveymonkey.com/v3/surveys/YOUR_SURVEY_ID/responses/bulk?page=1
page 2:
https://api.surveymonkey.com/v3/surveys/YOUR_SURVEY_ID/responses/bulk?page=2
With API Connector, you can either set these up as separate requests or run through them automatically with pagination handling (paid feature).
The answers appears in code, not as the original content of teh response, how do u solve that? thank you!
Sorry, I’m not really sure what you mean. Can you please share a screenshot or link to your sheet so I can investigate?
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?
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 give me access to your sheet so I can investigate.