Hello Community Members,
I’m struggling to figure out how to get aggregated from a data store search module into a single email.
I’m building a scenario that summarizes emails newsletters. I can summarize the emails, get the data into a data store, use the data store search module to extract the summaries I want and get all of the info into a JSON string.
However, the JSON string with all of the summarized information for each newsletter appears in the last operation. The way I have it configured, and I’ve tried multiple iterations, the scenario sends an email for every operation. How do I grab the JSON string output from the last operation and send only one email?
Any suggestions would be much appreciated.
Thank you!
I guess you can use the Parse JSON module and within it format it as an array. Then create a filter that will only allow the last item in the array pass by using the Bundle Order Position to equal total number of bundles from the module that initially outputted the bundles. Can’t really tell from where the bundles split from by the screenshots provided.
Why are you using the Group By field in the Text Aggregator?
This is the source of all the issues in your scenario.
Simply leave the field blank, or delete the Text Aggregator module.
For further assistance, please provide your scenario blueprint.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
Hi - Here’s my blueprint. I deleted the Text Aggregator module. The scenario still work but I still can’t figure out how to aggregate the output into one email. I don’t see the option to set a filter like LinkYourTech suggested. I’m sure I’m missing something obvious because I’m fairly new to Make and automations. Thanks again for the help.
blueprint.json (48.2 KB)
What is the purpose of the Aggregate to JSON module? Do you want to send JSON in the email body itself? If not, delete the “Aggregate to JSON module”.
- Use a Text Aggregator module before the “Send an Email” module.
- Set the Text Aggregator’s “Source module” field to the Trigger module.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
I’m getting closer. However, I still can’t figure out how to get the scenario to send one email with the aggregated data.
Here’s my latest blueprint.
blueprint 3.json (44.0 KB)
It sends an email for each operation. Only the last operation has the aggregated information that I want to send in the email.
You can see this in the screenshot that the last operation combines the names of 3 newsletter, which is what I want to send in the email.
How do I only choose to send the output of a specific operation, in this case the third operation?
Or, should I be taking a different approach altogether?
Again, really appreciate the guidance and help figuring this out.
Thank you.
You did not complete my two steps mentioned above.
I’m sorry. I thought I followed those steps, but I must be confused.
I added a Text Aggregator between the Data Store Search and before the last Send Email module.
Should I add a second Text Aggregator right before the Email Send module?
I was thinking the source would be the module immediately preceding it. But perhaps you meant the first Watch email trigger?
I apologize if I’m being dense. I’m learning.
Thank you.
Yes. It should be set to the trigger module, because that’s where the bundles are coming from.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
Brilliant - that did the trick. I didn’t realize that the source reference didn’t have to be sequential. I also implemented the bundle filter as LinkYourTech suggested to prevent any info from showing up twice.
Thank you so much for the help and patience.
No problem, glad I could help!
1. If anyone has a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.
2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.
This marks the topic as solved, so that:
- others can save time when catching up with the latest activity here, and
- allows others to quickly jump to the solution if they come across the same problem
To do this, simply click the checkbox at the bottom of the post that answers your question:
3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!
4. Learn more about Make:
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 —
Getting Started
Help Centre Basics
Articles & Videos
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
2 Likes
