SurveyMonkey

Export Responses to a New Google Sheet

With the Connect Apps feature, you can automatically export your survey results to Google Sheets. 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.

The Google Sheets quick action in Connect Apps creates a new Google Sheet with your survey responses.

To export responses to a new Google Sheet:

  1. Go to the Connect Apps section of your survey.
  2. Find the Google Sheets connector.
  3. Select Create new sheet.
  4. Select Connect to sign in to your Google account.
  5. Enter a name for your spreadsheet.
  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.
    • 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 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, the 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.