Alert by email when input data on google spreadsheet meets given condition
![alert by email google sheet change](https://blog.gsmart.in/wp-content/uploads/2019/05/eb36b60b2df4033ed1584d05fb1d4390e376ead004b0144493f7c97ca2edb2_640-116x150.png)
Here is the sample sheet: make a copy of the sheet Suppose you want to receive an email when the status column changes to ‘approved’. Install a trigger first Note that simple trigger does not work since we need to send an email from the trigger. You have to install the trigger. Create a function […]
Continue reading