How to Concatenate Google Sheets Rows into a Single Sentence String Using Make.com

How To
1

Hi Make.com Community,

I’m working on a workflow where I need to concatenate data from multiple columns in Google Sheets into a single sentence string. Each row contains details like Issue, What to Check, and Resolution. For example

image
image820×180 7.54 KB

I want the result for each row to look like this:
ZP SLIDE NOT HOLDING TOOLFACE: Will it pass an Autotune? ... | Resolution: PUMP(s) issues- IF THE Top Drive rotating with ...

I’ve set up a Google Sheets module to fetch data, but I’m unsure how to concatenate rows into strings dynamically. Can someone guide me on the best way to achieve this in Make.com?
I 've tried with array aggregator and used set variables modules but have some issues.

image
image1543×638 69 KB

Thanks in advance!

2

Hello @Mykhailo and welcome to the Make Community!

Google Sheets outputs a bundle for each row.
You’re currently using an Array Aggregator on that which puts all rows into an array of collections.

It’s not clear if you want to do something with a text string from each row, or if you want to build a big block of text containing all the strings separated by line breaks or some other separator?

If you need to create that text string from each row, then all the text strings in a single block of text, a Text Aggregator (in place of the Array Aggregator) would work in this case.

How do you need to use your concatenated strings?

3

Simply use a “Compose a String” or “Set Variable” module before the Array Aggregator.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.