The Alchemer Google Sheets Integration is available as an add-on. If you are interested in purchasing the Google Sheets Integration, please contact us for additional information.
With the Alchemer Google Sheets integration you can easily:
- Push survey data from Alchemer into a Google Sheets Spreadsheet.
Video Walkthrough
Integration Setup
Adding an Integration Action
1. Select an existing survey or create a new survey. Then navigate to the Survey Builder.
2. Click "Add New: Action"
You cannot add this Integration Action to the first page of the survey.
3. In the Add Action modal, scroll down to Integrations. Then click "Add" for one of your purchased integrations.
If you haven't purchased any additional integrations, you will see the below screen:
4. Select the action you would like to perform:
- Push Data to a Google Sheet
Google Sheets | Push Data to Google Sheets
Before configuring this integration action, you will need:
- The Sheet ID for the Google Sheet where you want to push the data.
- At least one worksheet
- Add column header names in Row 1 of the worksheet for the columns you want to push data into.
1. In Google Sheets, create the worksheet that you want to push data into.
2. In Alchemer, choose the survey that you want to pull the data from. Then add a Google Sheets integration action.
3. Select the "Push Data to a Google Sheet" action.
4. Click "Next" on the integration overview screen.
5. Authenticate with your Google account. Click add new authentication then name the authentication. After clicking create, provide your Google account credentials in the pop-up Google sign-in window that appears.
6. Go back to the the spreadsheet you created in Google Sheets. Copy the spreadsheet ID (highlighted in the URL in the image below) and paste it into the Google Spreadsheet ID field in Alchemer.
7. Select the worksheet that you want to use for that spreadsheet.
8. Select the data you want to push to your Google Sheet, by mapping fields in Alchemer to corresponding columns inGoogle Sheets.
First row values are shown as column headers. The right-most column you wish to use must have a heading value
Data is added (appended) to the end of the sheet in a new row by column letter reference. You must run this setup again if you change the columns in your sheet.
9. Optional. After an integration action occurs, data about the action is available for use in your survey. You can map this data back to fields in Alchemer.
For example, if there is an error in the action you can skip the rest of the survey questions for that respondent.
10. Click save to complete the integration action.
11. To test, take the survey. After the survey is completed, data will automatically be pushed into your spreadsheet.
Monitoring a Google Sheets Integration Action
A log of each run result can be found in Results > Individual Responses > Action Log.
Select an individual response and then navigate to the Action Log. In the Action Log, you can monitor whether the action was successful.
FAQs
1. The Integration Manager Permission is required to set up and use the Google Sheets Integration. If you don't have this permission you will see the following when trying to add the integration to a survey:2. To check if you have this permission or grant this permission to someone on your team, go to the left-side product navigation and select the Account drop-down, then click on the user management tab.
3. Then select the Users tab under User Management.
4. Click your username or the username for another member of your team.
5. Scroll down to the Permissions section and check if the Integration Manager box is checked. If you are an admin you can check the box for other members of your team.
Alchemer is committed to continuously releasing updates and enhancements to our survey integrations. If you have specific use cases, questions, or just general feedback, we would love to hear it. Contact us here!