# Operation Efficient Way To Combine Multiple Collections

**URL:** <https://community.make.com/t/operation-efficient-way-to-combine-multiple-collections/43625>\
**Category:** Questions\
**Tags:** arrays\
**Created:** [June 27, 2024, 10:31am UTC](https://community.make.com/t/operation-efficient-way-to-combine-multiple-collections/43625 "2024-06-27T10:31:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![martinjacksonuk](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/martinjacksonuk/32/23792_2.png) [@martinjacksonuk](https://community.make.com/u/martinjacksonuk)\
**Post date:** [June 27, 2024, 10:31am UTC](https://community.make.com/t/operation-efficient-way-to-combine-multiple-collections/43625/1 "2024-06-27T10:31:24Z")

</div>

I’m running a webhook which is collection various elements of data from a chatbot conversation. The messages are coming in as an “Array” with each response as a “Collection”.

I want to combine the message collections in to one string of text to populate “conversation” cell in a google sheet.

I’ve tried using Aggregators etc… but can’t seem to get it to work the way I need it.

In the image example the result I’m looking for would resemble something like:

assistant: Welcome to AskBobster | user: hi there | assistant: Hi there! How can I assist you today? | user: what functions can you perform | assistant: blah blah blah

 ![2024-06-27_11-16-06](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/8/582a0bf239c88fa33b06a7a308f19a99f8f26f40.png)

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [June 27, 2024, 2:19pm UTC](https://community.make.com/t/operation-efficient-way-to-combine-multiple-collections/43625/2 "2024-06-27T14:19:25Z")

</div>

You can just do it directly in Google Sheets cell field:

You can use the built-in function `map` and `join`

e.g.:

```plaintext
{{ join(map(1.messages; "content"); newline) }}

```

For more information, see the function documentation in the [Help Center](https://www.make.com/en/help).

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

### General

- [Help Center](https://www.make.com/en/help) | [Tutorials](https://www.make.com/en/help/tutorials.html)
- [Make Academy](https://academy.make.com) – learn Make and get your certificate
- [Discord Server](https://samliew.com/make-discord-invite) – join us in live chat for fans of Make!

### Help Center Basics

- [Mapping](https://www.make.com/en/help/mapping/mapping) – What is mapping? What can I map?
- [Mapping with arrays](https://www.make.com/en/help/mapping/mapping-arrays) – How to map items in an array
- [Aggregate an array for mapping complex fields](https://www.make.com/en/help/tools/flow-control#customizing-the-output)
- [Tokens for `parseDate`](https://www.make.com/en/help/functions/tokens-for-date-time-parsing) | [Tokens for `formatDate`](https://www.make.com/en/help/functions/tokens-for-date-time-formatting)
- [HTTP modules](https://www.make.com/en/help/tools/http) – Make a request, Get (download) a file
- [Webhooks](https://www.make.com/en/help/tools/webhooks) – Error Handling, Responding to webhooks

### Articles & Videos

- [Router Magic Formula](https://www.youtube.com/watch?v=4Q-5BsCtJu4) - YouTube
- [Error Handlers in Make](https://www.youtube.com/playlist?list=PLRE9E-rAD8U10mx2TRs54Nq1XJDdK9Kx4) - YouTube playlist
- [Getting started with OpenAI](https://community.make.com/t/getting-started-with-openai-gpt-3-and-make/7796)
- [How to use Regex in Make](https://community.make.com/t/how-to-use-regex-in-make/202)

[samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make)

> ### Join the unofficial [Make Discord server](https://samliew.com/make-discord-invite) to chat with other makers!

---

<div class="post-metadata">

**Author:** ![ManishMandot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/manishmandot/32/25887_2.png) [@ManishMandot](https://community.make.com/u/ManishMandot)\
**Post date:** [June 27, 2024, 3:01pm UTC](https://community.make.com/t/operation-efficient-way-to-combine-multiple-collections/43625/3 "2024-06-27T15:01:29Z")

</div>

Hey @martinjacksonuk

You can try this

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/2/b28d46de0e5de25cf41906d41547b125f762deb0.png)  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/e/ee23dfdb1b55ce370b1c53ee88546fb0c63f6d06.png)  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/b/0b5a10dddeb47f194058a3684b84e02c28151acd.png)  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/2/02459e78f1ec396bee40b707042df197c9f43662.png)

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [July 15, 2024, 6:04am UTC](https://community.make.com/t/operation-efficient-way-to-combine-multiple-collections/43625/4 "2024-07-15T06:04:06Z")

</div>

This topic was automatically closed because it's resolved or inactive. Please, start a new topic.