A simple YES in a cell in column A triggers EMAIL
<p>I've searched through the forums and the answer is most likely out there but I need some assistance.</p>

<p>If the letter "Y" is input in column A, I need an automatic email triggered to a predetermined list of people. Ideally, this email would include an automatically generated email body according to the row data (Item, vendor, total, job, etc.).</p>

<p>This is what I have written so far. It sends an email out <em>every</em> time I make a change. I have tried, unsuccessfully, to refine the project's triggers and the <code>if (Index of)</code> bit. </p>

<pre><code>  function sendNotification() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet();
  var cell = ss.getActiveCell().getA1Notation();
  var row = sheet.getActiveRange().getRow();
  var cellvalue = ss.getActiveCell().getValue().toString();
  var recipients = "me@gmail.com";
  var message = '';
  if(cell.indexOf('A')!="Y"){ 
    message = sheet.getRange('D'+ sheet.getActiveCell().getRowIndex()).getValue()
  }
  var subject = 'Update to '+sheet.getName();
  var body = sheet.getName() + ' has been updated. Visit ' + ss.getUrl() + ' to view the changes on row: «' + row + '». New comment: «' + cellvalue + '». For message: «' + message + '»';
  MailApp.sendEmail(recipients, subject, body);
};
</code></pre>