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

Hello,

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: