Google Sheets

A how-to guide to sending your Question Stream response data to a Google Sheet via Shopify Flow.

🚧

Be sure to enable Flow on your Fairing Integrations Page!

To start, enable Shopify Flow in the Fairing app, click "Integrations," find Shopify Flow, and click "Connect." Once enabled, we send a payload [survey response data] to Shopify Flow whenever someone submits a survey response.

If you'd like to analyze your Question Stream responses in a Google Sheet and want to automatically populate the sheet with real-time responses follow the below instructions. You can also download the Shopify Flow template here.

Create A New Workflow

If you haven't already installed Shopify Flow, you can do so via the Shopify App Store. To note, Shopify Flow is currently only available to Shopify Plus merchants.

Once you've installed Flow, get started creating a new workflow with *Enquire Post-Purchase Surveys as your trigger.

21402140

Create new Shopify Flow with EnquireLabs trigger.

After selecting New Survey Response, click Action.

21322132

Select Action

On the following screen, select Show under Get More Actions and scroll down to locate Google Sheets for Shopify Flow.

21282128

Select Show under Get More Actions

21382138

Select Google Sheets

Connect Shopify Flow To Your Google Account

After clicking Google Sheets for Shopify Flow, a new screen will appear where you'll can authorize Google Sheets for Flow access to your Google account.

21322132

Click Connect

Select the desired Google account.

21322132

Select your Google Account

And allow Shopify Flow access to write to your Google Sheets.

21242124

Authorize Shopify

Now that you've connected your Google Account, you can close the below window and click back to the window with your Shopify Flow set up.

21322132

Close Window

Add Action - Add row to spreadsheet

Now that you've authorized Shopify Flow access to your Google account, you can continue building out your workflow. Next, click "Add row to spreadsheet" action. If the button isn't clickable, you'll need to refresh the page.

21362136

Click add row to spreadsheet.

Create Google Sheet

On the next screen, Shopify Flow will ask for the URL you wish to send Question Stream responses to. You can use this template.

Copy the URL and Tab name of the Google Sheet into the Add row to spreadsheet Action form.

20442044

Setup up Google Sheet

❗️

Don't use {{orderTotal}}!!

For the time being, use the {{order.totalReceivedSet.shopMoney.amount}} variable to push the order total instead of {{orderTotal}}!

In the Row contents input box, copy the below. You can also manually build your columns, by clicking "Add a variable" located on the bottom right of the input box.

{{order.createdAt}},
{{order.name}},
{{order.id}},
{{customer.id}},
{{question | replace: ",", ""}},
{{response | replace: ",", ""}},
{{responseWasOther}},
{{questionId}},
{{referringQuestionId}}

🚧

Fix For Commas Breaking Google Sheets

If your question or response has a comma, Shopify's Flow integration will separate the data into two columns. Use the below syntax to fix this issue:

{{response | replace: ",", ""}}

Title Your Workflow & Enable

20342034

Re-title Shopify Flow

20362036

Turn on Shopify Flow


Did this page help you?