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.

Setup Guide

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.

Common Errors

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.

If you have this error, the start_date tag can help you

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
type &start_date=YYYY-MM-DD . For Instance, if I only want to see responses on or after January 2nd 2021 I would type &start_date=2021-01-02

press enter

The Sheet has been updated to only include responses after the specified start_date (January 2nd)

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.

Tracking Conversions with Hidden Fields URL Parameters