Alert by email when input data on google spreadsheet meets given condition
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