Skip to main content

Hi all,

I have an E-Commerce website with one product that has a size variation and sample variation. 

When I try to create a zap to transfer my orders to google sheets, it gather all the variations in one column and all the quantity in another one.

Example:

If someone orders 3 items, one blue large and two red small, I get one column with (blue, large, red, small) and the quantity column with (1,2). 

Is there a way to breakdown the variations and the quantity so it will appear like this (blue, large, 1) (red, small, 2)? 

Hope I was clear.

 

i’m having the same problem..i tried to google but didn’t find any solution


Hey @onkatalan & @ezrix 

As a first thing to try, can you switch from the “Create Google Sheet Row” action step to the “Create Google Sheet Row(s)” step. What it will then (try) and do is elegantly break line items across different rows.

Try that, see how the data comes out - and if there are still issues, take a screenshot and we’ll do our best to use Zapier Formatter steps to tidy up.