I’m using Flow to insert return data into Google Sheets. When there is more than one item returned it is putting all of the data in a single row. How can I break up the data into new rows? I have tried many different characters and can’t find anything that’ll work. This is what I have in Flow. {% …

This is how the action works. It inserts one row. We are working to make multiple rows possible, but in the meantime you could insert a delimiter like ## between rows and then split in Sheets with some code. I have an example here: https://docs.google.com/spreadsheets/d/1w9qSHe_hccBQ90dSPSVESWTFNWh…

Thank you for your response. I really am not familiar with Google Sheets, so will need to figure out what the ## is supposed to do and how. Below is what I see when I click on your link. I don’t see new rows splitting at the ##. [karilynae_0-1661527006594.png]

Oops, see it now. I inserted ## at the end of my flow statement, and added your code into google sheets. but it is only splitting within the one cell. I need it to start a whole new row with all the data after the ##. This is what I get… #1276 08/24/22 08/26/22 Elsie Kari Activated CAL-MAG 1…

I might need to see the code…but note that the column with the lineItems should be a single column and use :: to separate fields (because the comma will be split by Sheets and mess things up). Also note the heading uses the same approach to generate column titles For example, the code for row2 woul…

So I replaced the comma’s with :: and this is what I get now. Everything in one cell. #1277::08/26/22::08/26/22::Elsie Mae McShane::Kari Myers:: Cenitol 7.8oz::1:: true::Eagan:: ## #1277::08/26/22::08/26/22::Elsie Mae McShane::Kari Myers:: Candicid Forte 90 caps::1:: true::Eagan:: ## I …

Look again at my code…not all commas are replaced. Just those for the line items. Also, you putting all of the order details inside the loop, causing them to repeat. Try something like this: {{order.name}},{{order.createdAt | date: '%x' }},{{refund.createdAt | date: '%x' }},{{order.customer.display…

Hi Paul, I am trying to recreate the sample you have given by duplicating the same example data + code, but it returns to this error. TypeError: Cannot read properties of undefined (reading ‘length’) result [email removed] Untitled.gs:14 also, what do you mean by this approach should n…

Hi Aina-Amrn11, You can use the For Each action now to iterate through the line items on the refund and add rows to the spreadsheet one at a time. Here’s a quick example of how that could work: [DaveMcV_0-1682169776143.png] This is a feature we released earlier this year, but was not yet availab…

Hello! I am trying to pass over line items to a spreadsheet and each line item needs to fall into the next row. Using ‘for each’ passes over all the all order info for the applicable number of variants into that number of rows. Is there a way to pull all info into the next row but not all line item…

Shopify Flow inserts all data in one row in Google Sheets

Shopify Plus

Aina-amrn11 April 22, 2023, 2:40pm 11

This helps a lot! thank you so much Dave

Topic		Replies	Views
How can I use Flow to add order rows to a Google sheet? Shopify Plus	25	591	March 2, 2023
Shopify Flow: export orders to Google Sheets (one liner per order, even if multiple products ordered Shopify Plus Tacking-Tools	13	387	February 4, 2025
Flow: Adding rows to spread sheets from "Get customer data" in proper formated lines Shopify Plus flow	6	122	February 23, 2023
Exporting Fulfilled orders data to google sheets Shopify Plus flow	10	356	July 17, 2023
GetProductData formatting issues with Google Sheets Shopify Plus Tacking-Tools	4	80	June 23, 2023

Shopify Flow inserts all data in one row in Google Sheets

Related topics