SurveyMonkey

Export Responses to a Google Sheet

With a Connect apps quick action, you can automatically export your new survey results to either a new or existing Google spreadsheet, where responses populate in a new sheet in the spreadsheet. The Google Sheets quick action lets you keep your data synchronized for automatic sharing, analysis, and data visualization.

Responses are added to your Google Sheet as they arrive. Existing survey response aren't able to be exported to Google Sheets using this quick action.

The Google Sheets quick action in Connect apps lets you create a new or existing Google Sheet with your survey responses.

To export responses to a new Google Sheet:

  1. Go to the Connect apps section.
  2. Find Google Sheets.
  3. Hover over the down arrow and select Create new sheet or Use existing sheet.
  4. Select Connect to sign in to your Google account.
  5. Type a new spreadsheet name or Select spreadsheet to use an existing.
  6. Manage the conditions for your quick action:
    • Choose the data to include: Select Include survey data to choose the questions, answers, and metadata you want to send to the sheet.  If you include open text questions, select I understand to acknowledge that respondent data exported may include personal identifying information.
    • Filter the responses: Select Target specific responses to specify which responses will trigger this quick action.
  7. Select Activate to save and turn on your quick action.

Your Google Sheets quick action is turned on by default so you can test it and start collecting responses. You can always turn it off later.

You can edit the spreadsheet name, conditions, and filters of your SurveyMonkey quick action, at any time. This is useful if you need to change the criteria for which responses are exported or if you want to update the spreadsheet name. If you change the spreadsheet name within Google Sheets, the SurveyMonkey quick action will stop updating the existing spreadsheet and create a new one.

To edit your Google Sheets quick action:

  1. Go to the Connect Apps section of your survey.
  2. Select Manage.
  3. Find your quick action.
  4. Select the three dots icon ...
  5. Select Edit action.
  6. Make any desired changes.
  7. Select Save.

If you want to temporarily stop exporting new responses to your Google Sheet, you can turn off the quick action. This is useful if you want to pause the export but might want to restart it later.

To turn off the quick action:

  1. Go to the Connect apps section of your survey.
  2. Select Manage.
  3. Find your quick action, then turn off the toggle.

Deleting a quick action permanently removes it. If you no longer need to export responses using this quick action and don't plan to use it again, you can delete it.

To delete the quick action:

  1. Go to the Connect apps section of your survey.
  2. Select Manage.
  3. Find your quick action.
  4. Select the three dots icon ...
  5. Select Delete.
  6. At the confirmation message, select Delete again.