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 Zapier.com 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!