Automatic Email Sending Add-on with Word Detection

emailsending.js

// Word Based Email Alert System
// Kurt Kaiser, 2019

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];
var lastRow = sheet.getLastRow();
var lastColumn = sheet.getLastColumn();

// Go through recent submission, check for alert word
function checkSubmission() {
  for (var i = 1; i & lt; lastColumn; i++) {
    Logger.log(sheet.getRange(lastRow, i).getValue());
    if ("Friday" == sheet.getRange(lastRow, i).getValue()) {
      return true;
    }
  }
}

function sendAlertEmail() {
  MailApp.sendEmail({
    to: "[email protected]",
    subject: "Alert - Friday Requested",
    body: "Someone has requested Friday."
  })
}

// ----------------------------------------

function main() {
  if (checkSubmission()) {
    sendAlertEmail();
  }
}