Hi all,
I'm setting up an automation to populate a Google Sheet with product data from form submissions, and I'm encountering a challenge with how to best structure data that includes multiple variants like sizes and colours. This is only a small part of a longer zap, but quite a crucial part.
The image below shows Column J and Column L consists of all the size and color variants.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/9d1c209c-8d38-4ce4-8918-d0b69de8fe61.png)
The image below shows how the data actually should be structured.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/6125d264-720f-424a-b673-2c6bdfa7a2b1.png)
I have tried loads of options that where discussed in this community, like using line items. I do have all the different sizes and colours as separate values, I cannot seem to succeed in placing them right below each other in different cells.
This is how my zap is currently structured:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/4fce3011-fa72-48da-9c82-c00fcafd1191.png)
If you need extra data please let me know, as I will provide it asap :)