I am trying to make Google Sheets send a notification to a particular person/s when one of the fields on column Q is equal to the word "High". I want the email to be sent when it is high because it relates to the priority of the task.

How can I do this?

1 Answer 1


To do this you should use a Google Sheets add-on or Google Apps Script. If you go for using Google Apps Script, you could use an on edit installable trigger,the MailApp or GmailApp services and one of the send methods of those services and JavaScript control statements to handle the rules.

Example (untested):

function sendNotification(e){
  if(e.range.columnStart === 17 and e.range.rowStart > 1){
    MailApp.send('[email protected]','High Priority Task', 'Priority of task on row ' + e.range.rowStart + ' has set to high');


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.