Today we will be discussing how to export your survey data to Google Sheets. You will learn how to manually export your survey data to Google Sheets, how to set up a Google Sheets Task, and how to export Embedded Data to Google Sheets.
FAQ for Exporting to Google Sheets
What are the two main methods for exporting survey data to Google Sheets?
There are two methods:
- Manual export (one-time data export)
- Automated export using Workflows (automatic export per survey response)
Why would I use one method over the other?
Use manual export for one-time data downloads or historical data. Use Workflows for real-time, automated updates to a Google Sheet as responses come in.
Manual Export to Google Sheets
How do I manually export my survey data to Google Sheets?
- Once you've gathered your data, go to the Data & Analysis tab.
- Click the Export & Import button.
- Select Export Data.
- Select the export options you desire.
- Click Export.
What happens after I click Export?
You'll be prompted to choose a Google Account to connect to. Go through the process of allowing Google to connect by clicking Allow. Once connected, the export will begin and you'll be provided with a hyperlink. Click this link to find your export in a Google Sheet.
Setting Up Automated Export with Workflows
How do I set up Embedded Data for accurate date/time stamps?
- Go to the Survey tab and open Survey Flow.
- Click Add a New Element Here and select Embedded Data.
- Create an embedded data field labeled "Today's Date."
- Set the value to Current Date & Time.
- Click Confirm, then Apply, and republish your survey.
This allows you to pull the "Today's Date" embedded data field in the task, ensuring the survey response date is in your account's chosen time zone.
How do I create a Google Sheets Workflow?
- Go to the Workflows tab and click Create a workflow.
- In the "from scratch" column, select "Started when an event is received".
- Select Survey Response as the chosen event.
- Make your preferred selections on options and click Save.
- Click the Plus icon and select Add a task.
- Type "sheets" into the search bar and select Google Sheets.
- Select Add a row to a Google Sheet (to add one row per response) and click Next.
How do I connect my Google account to the Workflow?
- Click the Add a user account button.
- Give it a name.
- Go through the connection process by allowing access.
- Once connected, select the account you just added and click Next.
How do I configure which data gets exported?
- Choose to either add to an existing sheet or select Create a new Google Sheet.
- Give your sheet and main tab a name.
- Add column headers and values from both the survey questions and embedded data fields.
For example:
- Email address from Question 1
- Favorite number from Question 2
- Accurate date from the embedded data field created earlier
How do I finalize and test the Workflow?
- Give your workflow a name and save it.
- Submit a few test responses.
- Check your Google Sheet to verify the data is being exported correctly.
You should see the email address, survey responses, and accurate date/time stamps appearing in your Google Sheet automatically.
