Add multiple rows to Google Sheet based on list of variables

Option 3:

One hacky workaround might be to do this:

Since you know the number of items in advance, repeat that number of times:

Set variable based on index:

(expand the switch function parameters based on the largest you are expecting)

Aggregate to array.

3 Likes