Create an array from Google sheet

I want to create an array of 3 , 4 or 5 urls for Instagram, the number of links can change , as we create carousel post. Each carousel post can have 3,4 or 5 images.

I want array to be dynamic so it can take urls of any number (3,4,5)

i have tried the one below , but is is not working


Generally, if you want to create a simple array from items in the same data bundle (in your case same Google Sheet row) you can use the function “add”.
It, however, creates an empty item in case the link does not exist.

I would then recommend creating a comma-separated string and using the function “split” instead.

It will be "dynamic" and won't create empty items.

I hope it helps.

Cheerio :cat_roomba:

1 Like