Give your action a title and click Save Action and Edit.

Choose Google Spreadsheet from the list of Integrations.

Click Add Logic / Action on the page of your survey where you want to add the action.

Following these steps will save you time and allow you to utilize a feature in step 4! Then come back to Alchemer to add the Google Spreadsheet Action. Our suggestion for your workflow is to build out the entire survey first, then add a new spreadsheet in Google and name all the columns for the questions you plan on passing. Now that you're all synced up, it's time to add the action to your survey. Add and Set Up the Google Spreadsheet Action Then follow the steps above to link a new address.

If you need to use a different account, return to Integrations > Data Connectors and click Unlink next to the email address. If one is unable to reconfigure, please contact the administrator on the account for assistance. When editing an existing action, users are asked to re-configure the google account and are provided a link back to the integrations page to do so. etc.)Ĭonnecting Your Google and Alchemer Accounts

At this time, the google spreadsheet action cannot pass values to a column name that contains special characters.

At this time the Google Spreadsheet action cannot pass any special characters and punctuation e.g.

This action will NOT create a new column in the spreadsheet it will only update existing columns.

If you need to pass links to multiple files, you will need to have a File Upload question for each file. You can only pass a single link to a single file.

File Upload questions pass a link to the file into the spreadsheet.

If you delete answers created in the Preview from the spreadsheet, the integration just starts back at the top!

The action works in Preview, allowing you to to test the integration without collecting a live response.

You can also link the same spreadsheet to multiple actions.

You can have multiple Google Spreadsheet actions pushing FROM the same survey.

Most Custom Questions should work, as long as they're meant to pass data.

The integration still works even if all of your columns aren't being updated.

This action also works with Hidden Values and Quiz Scores.

We pass the Reporting Values, not the answer options, to the spreadsheet.

Custom Group: Add As Needed (as it is also a form of Piping)Ī few quick notes before you get started:.

It's quick and allows you the flexibility of sharing the document with anyone you want! When is Google Spreadsheet not the best solution for my data?Ī few Alchemer features are not compatible with the integration, due to limitations in the Google API, so if you are using the following question types or features, we do not recommend using this action: Using the Google Spreadsheet integration you can push realtime data from your survey into a Google Spreadsheet.

Survey to go studio download