How do I extract Rating Grid data using Shopify Flow?

Rating Grid responses arrive in Shopify Flow as a single pipe-delimited string, with each item and its rating separated by a colon. This article explains how the data is structured and how to use Liquid code within Shopify Flow to split each item-rating pair into its own column or row when pushing data into a Google Sheet.

If you are new to sending Grapevine survey data into Shopify Flow and Google Sheets, please start with our guide on sending survey responses into Shopify Flow before continuing with this article.

When a survey containing a Rating Grid question is submitted, the answer for that question is delivered as a single string in the following format:

For example, a Rating Grid question asking customers to rate Ease of use, Effectiveness, Quality and Price might produce:

The full answer sits within the response.answers array, alongside the question text and question code:

If your survey contains multiple Rating Grid questions, each one will appear as a separate entry in the response.answers array with its own pipe-delimited answer string.

To push each item-rating pair into its own column in a Google Sheet, you need to split the pipe-delimited string using Liquid code within your Shopify Flow workflow.

The approach uses the Liquid split filter to break the answer string first by the pipe (|) delimiter to separate each item-rating pair, and then by the colon (: ) delimiter to separate the item name from its rating value.

If you know the order of items in your Rating Grid (and you have not enabled the "Randomise row order" setting), you can extract each rating by its position in the string. This is the simplest approach and works well when you want each rating in its own column in your Google Sheet.

Use the following Liquid code in the relevant fields of your Google Sheets "Add row" action:

To get the first item's rating:

This outputs: Below Average

To get a specific item's rating by index (zero-based), assign the split result to a variable and access it by position:

Replace pairs[0] with pairs[1], pairs[2], pairs[3] etc. to access the second, third and fourth item respectively.

To get the item name (rather than the rating), use first instead of last:

This outputs: Ease of use

A practical column layout for a survey containing a Rating Grid question might look like this:

For each rating column, use the corresponding Liquid code in the Google Sheets "Add row" action field. For example:

Please Note:

The answers[0] index refers to the first question in your survey. If your Rating Grid is the second question, use answers[1], and so on.

If you have enabled the "Randomise row order" setting, the order of items in the answer string may vary between responses. In this case, rather than relying on position, you can search for a specific item by name.

Use a for loop to iterate through each pair and check for the item name:

This will output the rating for "Quality" regardless of where it appears in the answer string.
​

If your survey contains more than one Rating Grid question, each one will have its own entry in the response.answers array. Simply adjust the array index to target the correct question. For example, if you have two Rating Grid questions and you want to extract data from the second one, use answers[1] instead of answers[0]:
​

You can also use the questioncode value to identify the correct question if you prefer not to rely on position. The question code is displayed at the bottom of each question's report view in Grapevine.

Here is a full example of a Shopify Flow trigger output from a survey containing two Rating Grid questions:

To push the first Rating Grid question's data into separate Google Sheet columns, the Liquid code for each column would be:

If you have any questions about the content of this article or any other Grapevine related question, then please do just get in touch.