How to receive a single email with all necessary data from a Google Sheet instead of a separate email for each row?

How To
, , , ,
1

Hi,

I am trying to create a simple automation. I have a Google Sheet that contains cars whose service life is about to expire. The data from the sheet goes through a router and a filter. If the date matches today’s date, the flow proceeds to send an email with the details of the car that passed through the filter.

If there is only one car in the list, everything works fine. However, if multiple cars match the condition, I receive a separate email for each car.

image
image1431×640 53.8 KB

How can I ensure that I receive a single email containing information about all the cars instead of separate emails for each one?

Thanks for your help

1 Like
2

@Valerii
Hi, I think you need to add an Array aggregator module after the Search Rows module to aggregate the data. If the result of one module is divided into multiple Bundles, the subsequent modules will execute it for each Bundle.

I think you can then use the map function to extract the necessary values from the array and insert them into the body of the Gmail message.

3

Hi,
I tried putting an array aggregator after the router, then using a text aggregator, but unfortunately the result is the same.

1 Like
4

@Valerii
Perhaps the following post may be helpful.