How do I add columns in google sheet from array?

How To
,
1

Hello,

I have question about how to add columns in google sheet from array just like we’d do it like add row but this time will be in column.

I have been through this community, but I couldn’t find any specific guideline how to do this.

image
image1181×370 40.1 KB

I have created scenario following this order

  1. get the file names from google drive
  2. trim the file names to cut out any numbers and file formats (for example filename [1].jpg → filename)
  3. and deduplicate the file names so it only leaves unique names in array.
  4. put each array from each operation to go into separate columns in google sheet ← this I am trying to achieve.

Think I already spent quite a bit of operations on trying this one out, please help me!!

blueprint (1).json (26.4 KB)

The final result I am trying to achieve is like image below here:

image
image1056×681 97.6 KB

1 Like
2

Anyone can help me please?

3

Do the values in the Array need to keep their order? Like does the the first value in bundle 1 and the first value in bundle 2 need to be on the same row? I’m guessing this is part of a larger scenario seeing that you have 6 operations being used for each module.

4

Not it doesn’t have to be in the order as long as the values fall in the same column

1 Like
5

Is there a particular reason you need each entry to be a within a column? Seems like you can have each photo name be within a row then. Also will you need to add additional entries in the future for each column? Like will new photos fall under column A again in the future?

You can have each photo name in each column but not sure if it’s worth the number of operations you would have to spend. You would have to use a “Iterator” and split the photo name array. Then you would need to use the “Bulk Add Rows” and map out the columns you want each set of photo names to go into according to Bundle Order. As you can see this gets pretty complicated. I honestly never had a situation where I absolutely needed to have columns be added for an individual set of data. I’m pretty sure you can find a simpler way to do what you need.

What is the basic task of this automation? What is it that you want automated? I can maybe give you some ideas on simpler ways to build what you want.

6

Curious if you figured this out. I am in a similar situation.