PsFnKHAd

1function Initialize() {
2 
3  var triggers = ScriptApp.getProjectTriggers();
4 
5  for(var i in triggers) {
6    ScriptApp.deleteTrigger(triggers[i]);
7  }
8  
9  ScriptApp.newTrigger("sendNotification")
10  .forSpreadsheet(SpreadsheetApp.getActiveSpreadsheet())
11  .onEdit()
12  .create();
13  
14};
15
16
17/**
18 * 
19 */
20
21
22function sendNotification(e) {
23     
24  if("F" == e.range.getA1Notation()) {
25    if(e.value == "paid") {
26
27
28      
29  //Define Notification Details
30      var recipients = "myemail .... @gmail.com";
31      var subject = "Update"+e.range.getSheet().getName();
32      var body = "cell F has been updated PAID";
33      
34  //Send the Email
35      MailApp.sendEmail(recipients, subject, body);
36    }
37  }
38}