Hi all, I’m trying to create a Make scenario that compiles daily news summaries from a Google Sheet using GPT and sends the output via Outlook in a single email. But instead, the email module triggers once per GPT response, so I get six separate emails instead of one combined message.
Here’s how my current setup looks:
- Google Sheets – Search Rows
- OpenAI (Chat Completion) – to format and summarize each section
- Text Aggregator – to combine all the formatted sections
- Outlook – Send Email
The issue: Outlook sends an email after every GPT output, instead of waiting for the aggregator to finish compiling all six.
What I’ve tried:
- Added a filter before the Outlook module to only proceed when
Bundle position = Total bundles – but those variables aren’t visible after the Text Aggregator.
- Switched between Iterator + Text Aggregator and Text Aggregator only.
- Tried chaining modules differently, but the result is always multiple emails.
I’m just looking for a simple way to ensure Outlook waits until all six GPT outputs are aggregated before triggering. Is this a limitation with how Text Aggregator works? Do I need an Array Aggregator before the Text Aggregator instead?
Thanks in advance for any advice or workarounds!
Here’s a short video showing the behavior and current setup:
(your uploaded video link will appear here after posting)
Hey there,
always aggregate the module producing the extra bundles. In your case that is the Search Rows module.
Welcome to the Make community!
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, or even the trigger 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:
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 and actual input data.
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.
