Iterator won’t split Google Sheets cell of URLs (Array = empty)

[Jacqueline_Palacios]

Hi! Hoping someone can help with this. Everything in my scenario works until I get to the iterator to upload photos. All of me photo links are in a single sell separated by a space (I’ve also tried separating with a comma, a semicolon, line break… none of it works)

I’m trying to iterate the cell to an array to then reference the value in the Etsy upload listing image URL.

During execution, the Iterator shows Array: empty (so 0 bundles), even though the Google Sheets module output clearly shows the field populated.

Additionally I was trying to set up a filter because there are typically going to be between 1 and 8 image links in the cell. I had the filter setup as the array starting with “http” AND the bundle value being less than or equal to 10. However, I still am not getting any bundles/text when I try to iterate so I’m not even sure if this will work.

If there’s a cleaner/native way to split this cell without the extra module, or if I’m missing a known gotcha with token scope after “Create a Listing” I’d love the exact recommendation. Thanks!

[L_Duperval]

Hi @Jacqueline_Palacios and welcome to the Make Community!

For the iterator to work, you need to split your URLS into an array otherwise it won’t work.

You can do that as follows:

In this case, I took the equivalent of what expect is in your cell:

This is a list of URLs separated by a space. The split function breaks them up into an array:

And I can use an iterator on the array after:

This is the function I used:

{{split(1.urllist; space)}}

Hope that helps.

L

[Jacqueline_Palacios]

Thank you for this!

Question, what is the first module? Set variable? I don’t see the bundle settings from your second screen shot.

[L_Duperval]

It’s a basic trigger. Instead of creating a cell in a google sheet with a single text in it, I’m assuming that you are extracting that value directly from the Google sheet and you’re working with that data.

L