Google Add-Ons

We have two Google add-ons available in English:

Google Forms Add-On

This add-on is available for all SurveyMonkey plan types, including the free BASIC plan.

To import your Google Form into a survey:

  1. Get the free SurveyMonkey for Google Forms add-on.
  2. Open your Google Form.
  3. Click Add-ons from the toolbar.
  4. Open the SurveyMonkey add-on. You'll need to sign in with your SurveyMonkey details to authorize and open the app.
  5. Once the app window pops up, select the form questions you want to include in your survey. Questions that are greyed out can't be imported.
  6. Click Convert to Survey.
  7. Sign in to SurveyMonkey to finish designing your survey.

Google Sheets Add-On

This add-on is available for SurveyMonkey professional plans.

To import your survey results to Google Sheets:

  1. Get the free SurveyMonkey for Google Sheets add-on.
  2. Create a new spreadsheet in your Google account.
  3. Click Add-ons from the toolbar.
  4. Open the SurveyMonkey add-on. You'll need to sign in with your SurveyMonkey details to authorize and open the app.
  5. Once your survey list pops up, click the survey you want to import results from.
  6. Choose the collectors you want to import results from. A green dot means the collector is open and a grey dot means it's closed.
  7. Click Import to the right of the survey title to import the survey data.
Spreadsheet Organization

The spreadsheet organizes respondents by row and includes the time the survey was submitted or last modified and the complete answer set for each respondent. For additional respondent metadata you may have included in an Email Invitation Collector, please download an All Responses Data XLS export.

The add-on imports all responses from the collectors you selected into a sheet with the exact same name as the survey. The following information will help you get started analyzing the spreadsheet:

  • Row 1 contains the question text from the survey.
  • Blank cells are questions the respondent didn't answer or skipped by logic in your survey.
  • Question types with multiple answers allowed (checkboxes) list each answer choice the respondent selected in the same cell.
  • Questions with multiple rows, columns, or fields of answer choices span across multiple columns in the spreadsheet with each row, column, or field in its own column.
  • A/B Test data does not import.

You can create filters in Google Sheets to organize the results, but it's best to wait to edit the spreadsheet until you're done refreshing the results—refreshing may overwrite changes you've made to the sheet.

Refreshing Your Data

To refresh the available surveys or response counts per collector, click 1 at the top of the list to the right of your SurveyMonkey username.

To manually refresh survey data to add new responses, you have two options:

Refresh Data in Same Sheet

You can refresh the data within the same sheet if both the survey title in the SurveyMonkey app window and the name of the sheet match—this will overwrite any changes you've made to the sheet.

To refresh survey data, click Import to the right of the survey title.

Import Data to New Sheet

You can import the survey data into a new sheet (or tab) within the spreadsheet if you don't want to overwite any changes you've made. You have two options:

  • Edit the name of the sheet (the tab within the spreadsheet—not the name of the spreadsheet itself), then click Import to the right of the survey title. A new sheet will be created within the spreadsheet.
  • Edit the survey title in SurveyMonkey, then click Import to the right of the survey title. A new sheet will be created with the updated survey title.
TIP! If you accidentally overwrite important changes you made to your sheet when refreshing, you can restore the previous version of the sheet from your revision history.
Limitations

If your survey has a lot of questions or responses, please refer to Google's spreadsheet size limits. We support the new version of Google Sheets, which has a limit of 2 million cells per spreadsheet.

Linking & Unlinking Your Accounts

Your Google account can only be linked with one SurveyMonkey account at a time.

To switch the SurveyMonkey account you're using in the add-on:

  1. Click Sign Out from the bottom of the SurveyMonkey app window.
  2. Click Get Started within that same window.
  3. On the authorization page, click Use Another Account and sign in.

To unlink your accounts entirely:

  1. Go to your SurveyMonkey My Account page. In the LINKED ACCOUNTS section, click Remove next to the Google Sheets or Google Forms application.
  2. Go to your Google My Account page. Find your connected apps and sites and revoke access for SurveyMonkey.
Use the SurveyMonkey for Google Forms add-on to import your form into a SurveyMonkey survey. Use the SurveyMonkey for Google Sheets add-on to import your survey results directly into Google Sheets.

Alle Antworten heute noch