title: Send an e-mail when a new line is entered into Google Sheet
body: <p>I have a spreadsheet that is a list of RFIs from a client.  I want to be notified when a new questions is added to column F.  I found this code but I haven't been able to make the correct changes to get exactly what I need.  I have the trigger set to onEdit.</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('F')!=-1){ 
      message = sheet.getRange('F'+ 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>
  
  <p>Ultimately what I need...  an e-mail sent only when a new question is added into column F or when an existing question in column F is changed.  The code above only sends an e-mail when I "run" from inside the script editor, and the e-mail contains data for the active cell rather than the new question in F or the edited question in F.</p>
  
  <p>Any assistance is greatly appreciated,
  Thank you.</p>