Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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.

 

The image below shows how the data actually should be structured. 

 

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: 

If you need extra data please let me know, as I will provide it asap :)

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. 

Terms & Conditions