Export form answers to Google Sheets
Submitted form and survey answers can be written to a Google Sheet automatically, either by connecting a workflow trigger to Zapier through a webhook or by using the native Google Sheets workflow action.
How the export works
Each submission starts a workflow whose webhook forwards the submitted answers to Zapier, and Zapier adds them as a new row in your spreadsheet. The result is a spreadsheet you can query and analyze — for example, comparing the people who answered a survey question one way with those who answered another way.
Submitted answers are also saved on the contact's record, so you can review them later — see Where form responses show up.
Set up the webhook trigger in JourneyCARE
Create a workflow that starts on submission and sends the answers to Zapier through a webhook.
Open Automations > Workflows and add a new trigger.
Choose the Form Submitted or Survey Submitted workflow trigger and select the specific form or survey.
Optionally add a filter so the action runs only when a lead gives a certain answer to a particular question.
Choose the Execute Web Hook action and paste in the webhook URL from Zapier.
Save and activate the trigger.
Create the Zap in Zapier
The Zap receives the submission from the webhook and writes it into a Google Sheet.
In Zapier, create a new Zap.
Choose Webhooks by Zapier with the Catch Hook trigger event and continue.
Copy the Custom Webhook URL and use it as the webhook URL in the Execute Web Hook action.
For the action step, choose Google Sheets with Create Spreadsheet Row.
Connect the Google account if it is not connected already, then select the Drive, the spreadsheet, and the worksheet.
Map answers to spreadsheet columns
Tell the Zap which columns the sheet should receive and which submitted answer goes into each one.
Add the columns the sheet should receive — for example, Name, Email, Phone, and Service.
Map the submitted answers to those columns.
If you just created the spreadsheet, refresh the available fields in Zapier before mapping. New spreadsheet fields may not appear until you refresh.
Test the export
Turn on the Zap and test it with a real form or survey submission.
Turn on the Zap.
Open the form or survey and copy its integration link — for surveys, the Integrate Survey with a Link tab shows it.
Submit a test response through that link, then check the spreadsheet for a new row.
After setup, submitted answers populate the Google Sheet automatically.
Or use the Google Sheets workflow action
Instead of Zapier, use the native Google Sheets workflow action in Automations, which creates spreadsheet rows directly.
Add the action to a workflow with the Form Submitted or Survey Submitted trigger, link your Google account, and select the spreadsheet and worksheet. The Create Spreadsheet Row function adds a new row for each submission.