title: Script to send email to specific cell within a column every time the cell next to it gets updated
body: <p>I hope this haven't been asked before I'm trying to do what the title says.</p>
  
  <p>In this particular example I got email list on column A, and I want that email address to receive a notification when the cell next to it gets updates to "Yes"</p>
  
  <p>So far I got this:</p>
  
  <pre><code>function Initialize() {
  
    var triggers = ScriptApp.getProjectTriggers();
  
    for(var i in triggers) {
      ScriptApp.deleteTrigger(triggers[i]);
    }
  
    ScriptApp.newTrigger("sendNotification")
    .forSpreadsheet(SpreadsheetApp.getActiveSpreadsheet())
    .onEdit()
    .create();
  
  };
  
  
  /**
   * 
   */
  
  
  function sendNotification(e) {
  
  
    if("B2" == e.range.getA1Notation() ) {
  
      if(e.value == "Yes") {
  
  
  
        var recipients = "IDK what to put in here";
        var subject = "There's an update to your request";
        var body = "We resolved your issue!";
  
  
        MailApp.sendEmail(recipients, subject, body);
      }
    }
  }
  </code></pre>