# Text Aggregator + Slack don't seem to work properly **URL:** \ **Category:** Questions\ **Tags:** arrays\ **Created:** [March 1, 2025, 1:40pm UTC](https://community.make.com/t/text-aggregator-slack-dont-seem-to-work-properly/71939 "2025-03-01T13:40:40Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Will4](https://avatars.discourse-cdn.com/v4/letter/w/82dd89/32.png) [@Will4](https://community.make.com/u/Will4)\ **Post date:** [March 1, 2025, 1:40pm UTC](https://community.make.com/t/text-aggregator-slack-dont-seem-to-work-properly/71939/1 "2025-03-01T13:40:40Z")
I am working on an automation that: 1. Queries a Google sheet to get a list of client names 2. Start an iterator to look at each row, and then query ClickUp for each client name to see if we have a live job or not 3. Aggregates the results of the query and then passes ONLY client names who don’t have a live job with us 4. Aggregat the list of client names into a single output 5. Send a slack message to the team I seem to have all of it working up until the Slack message. Slack is sending multiple messages one by one, instead of a single output as you’d expect after a text aggregator. Can anyone help? ---
**Author:** ![Will4](https://avatars.discourse-cdn.com/v4/letter/w/82dd89/32.png) [@Will4](https://community.make.com/u/Will4)\ **Post date:** [March 1, 2025, 1:41pm UTC](https://community.make.com/t/text-aggregator-slack-dont-seem-to-work-properly/71939/2 "2025-03-01T13:41:17Z")
![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/0/c0c3e0d1c5c3d204765855c0073039dfa80d706e.png) ---
**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:** [March 1, 2025, 2:09pm UTC](https://community.make.com/t/text-aggregator-slack-dont-seem-to-work-properly/71939/3 "2025-03-01T14:09:56Z")
Welcome to the Make community! Delete the Iterator module. Each result from the Search Rows module will already output a separate bundle, not an array. ## Setting the Correct Aggregator Source You need to set the “ **Source Module** ” field of the aggregator to where the bundles are coming from. This is usually an **Iterator** module, but can also be a search/list/repeater module. ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/5/658850f6135a12cb99f684ea85b83a529e11b97d.png) For more information, please refer to the [Make Academy](https://community.make.com/t/make-academy-course-overview/29699). ## Combining Bundles Using Aggregators Every result (item/record) from trigger/iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, you’ll need to use an aggregator of some sort. [Aggregators](https://www.make.com/en/help/modules/aggregator.html) are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the [**Array aggregator**](https://www.make.com/en/help/tools/flow-control.html#array-aggregator) module. The next popular aggregator is the [**Text Aggregator**](https://www.make.com/en/help/tools/tools.html#text-aggregator) which is very flexible and can apply to many use-cases like building of JSON, CSV, HTML. You can find out more about the other types of aggregator modules here: - [Array aggregator](https://www.make.com/en/help/tools/flow-control.html#array-aggregator) - [Text aggregator](https://www.make.com/en/help/tools/tools.html#text-aggregator) - [Numeric aggregator](https://www.make.com/en/help/tools/tools.html#numeric-aggregator) - [Table aggregator](https://www.make.com/en/help/tools/tools.html#table-aggregator) - [JSON aggregator](https://www.make.com/en/help/tools/json.html#aggregate-to-json) - [CSV aggregator](https://www.make.com/en/help/apps/file-and-document-management/csv.html#create-csv) - [Archive (ZIP) aggregator](https://www.make.com/en/help/apps/built-in-apps/archive.html#create-an-archive-973677) - _other app-specific aggregators_ ## Example Here is an example of how your scenario could look: ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/2/02e20c743c520ef02bee18b0c2160d2d42e9c829.png) This is just an example. Your final solution may or may not look like this depending on your requirements. Hope this helps! Let me know if there are any further questions or issues. — @samliew P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make. ---
**Author:** ![Will4](https://avatars.discourse-cdn.com/v4/letter/w/82dd89/32.png) [@Will4](https://community.make.com/u/Will4)\ **Post date:** [March 3, 2025, 9:54am UTC](https://community.make.com/t/text-aggregator-slack-dont-seem-to-work-properly/71939/4 "2025-03-03T09:54:58Z")
Hey thanks for the response. Still can’t seem to get this to work ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/a/ca5bc684ff4f7c6ef690fa539b3ef4d5b19145dd.png) (I stopped it early, but you can see, the spreadsheet has returned a list of client names, ClickUp has checked 6 of those client names, after going through the filters, 2 of them don’t have tasks and still 2 messages have been sent on Slack rather than 1. Here is what I’m doing currently: 1. Google spreadsheet returns the list of names 2. On ‘List all tasks’ on Clickup, I have set the filters to Statuses “In Progress” and also filter on custom field (Client name). The input here is the output from the Google sheets stage, client name 3. Then, an aggregator is using the ‘list all tasks’ module as the source, and including the task ID as a way of separating results 4. Text aggregator is then taking the data from the array 5. Slack is taking the output of the text aggregator ---
**Author:** ![Will4](https://avatars.discourse-cdn.com/v4/letter/w/82dd89/32.png) [@Will4](https://community.make.com/u/Will4)\ **Post date:** [March 3, 2025, 9:57am UTC](https://community.make.com/t/text-aggregator-slack-dont-seem-to-work-properly/71939/5 "2025-03-03T09:57:04Z")
Google Sheets: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/7/7/77fe085d015fe5f208a10bed2e530ffe7e3f2c64.png) ClickUp: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/a/2a0185d89401b80d6e9c456a50d0830f46c0ac81.png) Aggregator: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/0/3030b9976f465aa1df0578177e9a70bea6c799fd.png) Filter: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/4/b/4bc678baddb1d7dd9262f52e34739da1928efec6.png) Text Aggregator: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/6/06e79ae0621dc60d3ceac212c88afef7b12dfa68.png) Slack: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/f/1f4788a7ea0c072a04f42ec7b6270fee60f66c90.png) ---
**Author:** ![Stoyan\_Vatov](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@Stoyan\_Vatov](https://community.make.com/u/Stoyan_Vatov)\ **Post date:** [March 4, 2025, 12:46pm UTC](https://community.make.com/t/text-aggregator-slack-dont-seem-to-work-properly/71939/6 "2025-03-04T12:46:14Z")
Hey Will, if you want only a single execution on the final module, then you need to aggregate ON the module that is producing multiple bundles. ---
**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:** [March 4, 2025, 2:36pm UTC](https://community.make.com/t/text-aggregator-slack-dont-seem-to-work-properly/71939/7 "2025-03-04T14:36:05Z")
That’s what I said above, and even provided an example of how the scenario could look… [![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/2/02e20c743c520ef02bee18b0c2160d2d42e9c829.png) ](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/2/02e20c743c520ef02bee18b0c2160d2d42e9c829.png) ---
**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:** [June 2, 2025, 1:42pm UTC](https://community.make.com/t/text-aggregator-slack-dont-seem-to-work-properly/71939/8 "2025-06-02T13:42:31Z")