Overview

Google Sheets is a cloud-based spreadsheet platform used by organizations to store, manage, and collaborate on structured data. It enables teams to organize information, automate workflows, and analyze data in real time.

The Alchemer integration with Google Sheets supports retrieving rows, updating rows, and pushing new rows into a sheet. This allows Alchemer to use information stored in Google Sheets to personalize surveys, enrich response data, and keep Sheets synchronized with survey activity.

Common uses for the Alchemer Google Sheets integration

• Personalize survey content using values stored in Google Sheets
• Use Google Sheets data in survey logic
• Automatically retrieve and update rows in Google Sheets
• Reduce manual updates and spreadsheet maintenance
• Insert new rows into Google Sheets when survey responses are submitted

What can the Alchemer Google Sheets integration do?

• Get data
• Update data
• Push data

You will need

• Google Sheets API access and credentials
• An Alchemer plan that includes integrations and the Integration Manager permission enabled.        
  • Contact us if you are unsure if your plan includes integrations.

Setup Alchemer Google Sheets integration in surveys

Google Sheets | Get data

You will need:

• Google login associated with your Google Sheets
• Survey fields containing the lookup value used to find a row
• Row 1 of the worksheet filled in with the column header names for the columns you want to push data into

Configure the action

1. Open your survey in Survey builder.
2. Select Add New: Action.
3. In the Add Action modal, scroll to the Integrations section.
4. Select Google Sheets.
5. Select Google Sheets | Get data.
6. Google Sheets | Authentication: Select an existing authentication or create a new one.
7. Google Sheets | Sheet ID: Enter your sheet ID, which you can find in the url when you navigate to your desired sheet
   • https://docs.google.com/spreadsheets/d/<sheetID>/edit?gid=0#gid=0
8. Google Sheets | Select worksheet: Select the Google Sheet you want to query from the dropdown.
   • Note: If you see a continuous loading gray bar and no dropdown list appears, you either put in the incorrect sheetID or the sheetID is not associated with the Google Sheets account you authorized
9. Google Sheets | Get row: Choose the fields in your survey that you would like to use to find the specific Google Sheet row.
10. Google Sheets | Set field format:  Map each lookup field to its expected data type. The left dropdown lists the chosen lookup fields, and the right dropdown lists the data types:         
    • Text
    • Number
    • Date
    • Boolean
11. Google Sheets | Get data back: Choose the Google Sheets row fields to return.
12. Save the action.

Status codes

• 200: A row was successfully found and updated
• 400: The external integration returned an error or no row was found

Google Sheets | Update data

You will need:

• Google login associated with your Google Sheets
• Survey fields containing the lookup value used to find the row to update
• Row 1 of the worksheet filled in with the column header names for the columns you want to push data into

Configure the action

1. Open your survey in Survey builder.
2. Select Add New: Action.
3. In the Add Action modal, scroll to the Integrations section.
4. Select Google Sheets.
5. Select Google Sheets | Update data.
6. Google Sheets | Authentication: Select an existing authentication or create a new one.
7. Google Sheets | Sheet ID: Enter your sheet ID, which you can find in the url when you navigate to your desired sheet
   • https://docs.google.com/spreadsheets/d/<sheetID>/edit?gid=0#gid=0
8. Google Sheets | Select worksheet: Select the Google Sheet you want to query from the dropdown.
   • Note: If you see a continuous loading gray bar and no dropdown list appears, you either put in the incorrect sheetID or the sheetID is not associated with the Google Sheets account you authorized
9. Google Sheets | Get row: Choose the fields in your survey that you would like to use to find the specific Google Sheet row you want to update.
10. Google Sheets | Set field format: Map each lookup field to its expected data type. The left dropdown lists the chosen lookup fields, and the right dropdown lists the data types:
    • Text
    • Number
    • Date
    • Boolean
11. Google Sheets | Update data: Choose the Alchemer fields whose values should update the corresponding Google Sheets row fields.
12. Google Sheets | Get data back: Select metadata fields (message, status code) for debugging.
13. Save the action.

Status codes

• 200: A row was successfully found and updated    
• 400: The external integration returned an error or no row was found and no update occurred

Google Sheets | Push data

You will need:

• Google login associated with your Google Sheets
• Survey fields containing the values to insert as a new row
• Row 1 of the worksheet filled in with the column header names for the columns you want to push data into

Configure the action

1. Open your survey in Survey builder.
2. Select Add New: Action.
3. In the Add Action modal, scroll to the Integrations section.
4. Select Google Sheets.
5. Select Google Sheets | Push data.
6. Google Sheets | Authentication: Select an existing authentication or create a new one.
7. Google Sheets | Sheet ID: Enter your sheet ID, which you can find in the url when you navigate to your desired sheet
   • https://docs.google.com/spreadsheets/d/<sheetID>/edit?gid=0#gid=0
8. Google Sheets | Select worksheet: Select the sheet that will receive the new row.
   • Note: If you see a continuous loading gray bar and no dropdown list appears, you either put in the incorrect sheetID or the sheetID is not associated with the Google Sheets account you authorized
9. Google Sheets | Select the data to push: Select the Alchemer fields whose data will be pushed to Google Sheets as a new row.
   • Note:  The right-most column you wish to use must have a heading value.
10. Google Sheets | Get data back: Select metadata fields for debugging.
11. Save the action.

Testing and Troubleshooting

Testing and Validation

How to test

• Submit a survey response that triggers the integration action.
• Confirm the expected update, retrieval, or insertion occurs in Google Sheets.
• Use returned metadata values for debugging.

How to verify results

• Check the impacted row in Google Sheets.
• Ensure retrieved or updated values match expectations.

Monitoring Integration Activity

Where to find logs

• Go to Results → Individual Responses.
• Select the response you want to inspect.
• Open the Action Log tab.

What logs display

• Success or failure status
• Timestamp
• Input and output values
• Returned Google Sheets status codes

Troubleshooting

Lookup failures

• Invalid identifier values
• No matching rows found
• Incorrect type on filter value (e.g. searched on a date cast as Text)

FAQs

What permissions do I need?
Integration Manager in Alchemer and API permissions for Google Sheets.

When does the integration run?
In real time when a survey response is submitted.

Can I use multiple Google Sheets actions in one survey?
Yes. Actions can work independently or together.

Why isn't my data updating?
Check the Action Log for lookup issues, mapping errors, or Google Sheets API failures.

What if I need additional functionality?
Contact Alchemer Support for enhancement requests.