Looking to create an automatically updating record of your Experience responses with Google Sheets?
How it works
Experience enables users to export response data via automatically updating Google Sheets or by downloading a CSV. Using Google Sheets requires copying import code from Experience and entering it into your Google Sheet. Your Google Sheet will continuously populate new responses every 15 min over time, so you do not have to manually update your record.
Step 1 - Go to your Experience's settings Page
Step 2 - Open the Export Page
- click on the "... More" button
- select the "Export responses" drop down option
Step 3 - Copy the Import Code
click on the blue "Copy" button under the "Export Responses to Google Sheets" section
Step 4 - Paste Code into your Google Sheet
- click into the top left cell (A1)
- Paste in the code (either by right clicking or typing ctrl+v)
It might take a second or two but the data should populate the spreadsheet taking up as many columns as needed to fit your Experience responses.
Sometimes the Google Sheet export might break. If that happens, you may need to manually update the URL. Here are some tricks you can use:
Scenario 1: You've reached an export size limit. Add Start Date Filter to your Sheet
If you have an Experience with too many responses or are only interested in responses after a certain date, you may want to filter your Google Sheet with the "start_date" tag.
- click to open the cell in which you earlier pasted the Import code (the top left cell: A1)
- click to move your cursor right before
")near the end of the text
&start_date=YYYY-MM-DD. For Instance, if I only want to see responses on or after January 2nd 2021 I would type
- press enter
Scenario 2: The export has a #N/A. Refresh the Google Formula
If you are having issues with Google pulling in your response data, you can attempt to fix this issue by amending a "fake tag" to the Import text. This will make the Google Formula refresh in attempt to retrieve the response data.
At the end of your Import code (right before the
") ) enter in
?1 and then press enter to refresh the import formula.