I am sending data from Shopify orders to Google Sheets. I want it to contain all the line items of the products in the order, plus associated line item data. However, this leads to some order level data repeating. I would like to make it so that order level data only appears on the first row.
It is currently like this
And I would like it to end up looking like this; where anything not related to the specific line item is posted once
+5Hi
I’m not sure. All the data pushes into the correct columns. The issue is, order level data such as order number, payment status etc, repeats for each line item row that is also pushing through
How would loop by Zapier help?
+5You could try to have the first row added first and the rest in the loop by using the ID + 1 of the previous row and filling in the columns you want to fill.
If you’re not sure how to do this, you can send me a message, and we can take a look with Teamviewer :)
+5For anyone that is also looking for an answer on this: We used ‘Loop by Zapier’ and ‘Paths by Zapier’ within that loop. This way, we could differentiate between the first row that is added (Path B) and the other rows (Path A).
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
