All Collections
Google Sheets Integration
Google Sheets Integration

Automatically send Quiz, Survey or Form submissions to a Google sheet

Sharon Luria avatar
Written by Sharon Luria
Updated over a week ago

Send submissions automatically to a Google sheet following these steps:

Step #1 - Create a Zap

Click the Make a Zap button and create a name for the zap

In the Choose app & event section, select Webhooks by Zapier, and then Catch Hook in the Trigger event field and click Continue.

Copy the Custom Webhook URL. You will use this code momentarily in Opinion Stage.

Step #2 - Enter the Webhook URL into your Item

Go back to your Opinion Stage account. Edit your Quiz/Survey and then enable the "Enable custom webhook" checkbox under Settings > Integrations.

In the dialog that is displayed, paste the Webhook code that was copied from Zapier, click Save, and then save your quiz/survey.

Important: Now, take the quiz/survey on the landing page (note that if you do that in the preview window, it will not work) - this will send a test entry with the Webhook so you can test it works in Zapier.

Step #3 - Connect to Google Sheets

a) Now go back to and start by clicking Continue in the screen you left off on.

b) Click Test Zap to see verify data is sent from your quiz/survey to Zapier. When you see the data you are ready to continue to configure the action.

c) In the App Event search box, search for Google Sheets and select it.

d) In the Action Event drop down select Create Spreadsheet Row and click Continue

e) Select/connect to your Google sheet account, then select the Spreadsheet, and the Worksheet you would like the submissions to go to and then click Continue.

f) Click "Refresh Fields" and map the fields from your survey/quiz to the Google Excel sheet.

g) When you finish mapping the fields, click Continue and then Turn on Zap

You're done!

Did this answer your question?