Array Output into one Google Sheet Cell

Hi,

I am trying to add the output from an Array to be placed in one cell. I used map() though the output is one single string without line breaks and separated by comma.

Is there a way to place the entire array with line breaks into the cell?

this is my flow

the output that i need to group together

How I am grouping it and choosing what I want in the array

Mapping that into a variable to be in single output

Then trying to output that into a single cell in google sheet

I know I am repeating some steps and some of these steps are not even needed…but can’t find the best way…

If you can help, that would be great. thank you.

Mike

Hey Mike,

You can easily use a Text Aggregator, similar to this:

The output from the Text Aggregator can then be mapped into a single cell

2 Likes