ForBobby

spreadsheetSendEmail.js

var TRIGGER_COLUMN = 2;
var EMAILED_COLUMN_VALIDATION = 3;
var EMAILED_COLUMN_VALIDATION_VALUE = "SENT"
var EMAIL_COLUMN = 1;
var SUBJECT = "YOUVE GOT MAIL"
var MESSAGE = "Hello %, \nThis is the UncleBot from Unclesoklaldkfjklasdf\n Game: %"


function myFunction(e) {
  var sheet = SpreadsheetApp.getActiveSheet();
  var val = e.oldValue;
  if(e.range.columnStart == TRIGGER_COLUMN) {
    var row = e.range.rowStart;
    var rowEnd = e.range.rowEnd;
    if(sheet.getRange(row, EMAILED_COLUMN_VALIDATION).getValue() != EMAILED_COLUMN_VALIDATION_VALUE) {
      //send email
      var email = sheet.getRange(row, EMAIL_COLUMN).getValue();
      MailApp.sendEmail(email, SUBJECT, MESSAGE);
      sheet.getRange(row, EMAILED_COLUMN_VALIDATION).setValue(EMAILED_COLUMN_VALIDATION_VALUE);
      //Logger.log("sent an email");

    }
  }else {
  
  
    Browser.msgBox(JSON.stringify(e))
  }
}