Need help adding multiple rows in Google Sheets

Hi @steijnd 

We will need to see screenshots with how your GSheet steps are configured to have more context.

@Troy Tessalone 

Here you go: 

Is this sufficient?

@steijnd 

Data needs to be formatted as an array of item, rather than a string of comma separated items.

e.g. Formatter > Utilities > Text to Line Items

Help article about handling arrays in Zaps

@Troy Tessalone 

thanks a lot! At least I have these different size values.
It duplicates al other rows as well. Can this be avoided? If not I guess I just have to deal with it. 
 

I have ran into another problem in this automation, do you mind taking a look at it? 
 

thanks again! 

@steijnd 

If you still have issues configuring the Zaps, then we will need to see updated screenshots with how your steps are outlined and configured to give context.

@Troy Tessalone 

This is how the zap is set up, nothing has changed except for the Column “Size” there is now an array of line items. 

This is how it sends data to google sheets. Only “Size” should be outputted in multiple rows, the other get duplicated as well. 

Thanks!

@steijnd 

Ok, then that means the Zap step logic would have to be different.

You would first need to create the row w/o the Size

Then use the returned Row/ID to update the same row with the first Looping iteration for the first Size

Then +1 to the returned Row/ID to update the following rows with the remaining Looping iterations for the Sizes.

@steijnd 

For the record, I recommend going with the approach where each row has the full data.

@Troy Tessalone 

okay thanks a lot! 

I agree with your last comment, but it’s a client’s preference.