Shopify Triggers to Filling in a Google Sheet

Questions
,
1

Hey everyone :waving_hand:

Total beginner here so sorry if this is obvious lol.

I have a small customized digital art shop. When someone orders, Shopify sends the data into n8n, and then n8n sends it into Google Sheets so I can process it later.

Issue:
If a customer buys more than one item in the same order, only the first item gets added to the sheet.

So if someone buys:

  • A artwork

  • B artwork

  • C artwork

Only A artwork shows up in the sheet.

Same thing if someone buys 2 of the same artwork — I only get one row, so I have no idea I need to make two :sweat_smile:

What I want:
Every single item in the order should become its own row in Google Sheets. Even if they bought multiples of the same thing.

Question:
How do I loop through all the line items from a Shopify order in n8n and write each one to the sheet?
Do I use Split In Batches? Item Lists? Something else?
Looking for the simplest explanation possible please — still learning :folded_hands:

Thanks in advance!!

2

hey, i think the issue here is just how the n8n treats the data coming from shopify. Did you do with with api or shopify node? and can you share the part of the workflow just to see how the data is treated. Cuz it can also be the part where it saves the items, so it doesnt loop for each item in the order, just the first item.

3

Shopify sends the whole order as one item, and all products are inside the line_items array.
Use an Item Lists node with Split Out Items on line_items so each product becomes its own n8n item.
If a product has quantity > 1, duplicate that item (via a small Function node) before Google Sheets.
Then use Google Sheets → Append Row and every artwork will be written as a separate row.