How to Send Only One Summary Email Instead of Multiple (Vacation Overview Automation)

How To
, ,
1

Hi everyone,

I’ve created an automation in Make that pulls vacation data from Google Sheets and sends an overview via Gmail for the upcoming month. The setup works correctly, but I’m facing one issue: I receive multiple emails instead of just one summary email. The number of emails depends on how many records pass through the filter.

:puzzle_piece: Goal:

I want to send only one email that includes a summary of vacations for all employees in the upcoming month.

:hammer_and_wrench: Current Scenario (Modules Overview):

  1. Google Sheets (Search Rows)

Headers:
A2 – Date
B2 – Team
C2 – FullName
D2 – Query
E2 – Amount MH
F2 – Amount MD

  1. Filter
  • Filters rows for the upcoming month
  • Includes only rows where Query = “Dovolená” or “volno”
  1. Array Aggregator

Aggregated fields: Date, Team, FullName, Query, AmountMD
Group by: FullName
Stop processing after an empty aggregation: Yes

  1. Iterator
  • Iterates over aggregated array
  • This is where the problem begins – multiple bundles are created here
  • Result: one email is sent per bundle (e.g., 4 names = 4 emails)
  1. Tools: Numeric Aggregator

Source module: Iterator
Function: SUM
Value: parseNumber(ifEmpty(AmountMD; 0))
Result is correct, but again, it’s calculated separately per bundle

  1. Tools: Text Aggregator

Source module: Numeric Aggregator
Row separator: New row
Group by: (empty)
Value:

  • Total vacation days for {{FullName}}: {{25.result}} days

  1. Gmail (Send an Email)
  • Recipient: Me
  • Content:

**Vacation Summary per Employee:**

{{26.text}}

Regards,
Your Make Automation ```

:warning: Problem:

Everything works except that I receive one email per employee, instead of a single email with all employees’ vacation totals.

:white_check_mark: What I Want:

  • One aggregated summary email
  • That includes all employees and their vacation totals
  • Sent once per run, not once per bundle

If anyone has experience working with aggregating data after an Array Aggregator without using an Iterator, or can help restructure this scenario to output one email, I’d really appreciate your help!

Thanks in advance :folded_hands:

2

The scenario looks like this

image
image1729×339 42.8 KB

3

Hey Daniel,

and when it runs, what does it look like? Most likely, you need to change the source module of the text aggregator to the array aggregator.

1 Like
4

Thank you so much! It worked when i changed the source module of the text aggregator to the array aggregator. I burned so many operation trying to fix it. But all it took was this little change.

I hope it´s going to help other people, because I couldn´t find this issue anywhere, whether using AI tools or old-school googling.

1 Like