Hello All


We have a sheet pulling data from different sources every 1 min and "Signal" cells that show "1" when the required conditions are met.

Like this:
lgJa3Vu.png

We just want to send an email to the specific row address with its subject and body.

How do we do it?