Text Aggregator + Slack don't seem to work properly

[Will4]

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?

[Will4]

[samliew]

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.

For more information, please refer to the Make Academy.

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 are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the 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
• Text aggregator
• Numeric aggregator
• Table aggregator
• JSON aggregator
• CSV aggregator
• Archive (ZIP) aggregator
• other app-specific aggregators

Example

Here is an example of how your scenario could look:

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 will save you lots of time and frustration using Make.

[Will4]

Hey thanks for the response. Still can’t seem to get this to work

(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

[Will4]

Google Sheets:

ClickUp:

Aggregator:

Filter:

Text Aggregator:

Slack: