Operation Efficient Way To Combine Multiple Collections

[martinjacksonuk]

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

[samliew]

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

You can use the built-in function map and join

e.g.:

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

For more information, see the function documentation in the Help Center.

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 | Tutorials
• Make Academy – learn Make and get your certificate
• Discord Server – join us in live chat for fans of Make!

Help Center Basics

• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• Aggregate an array for mapping complex fields
• Tokens for parseDate | Tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

Articles & Videos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Getting started with OpenAI
• How to use Regex in Make

samliew – request private consultation

Join the unofficial Make Discord server to chat with other makers!

[ManishMandot]

Hey @martinjacksonuk

You can try this