DBS SendNotifications

function sendNotification() {

  var spreadsheet = SpreadsheetApp.openById("1SYbyerWWVO5u4IwpLa2_XhngJPz3tVfN_ezHYJb6pOE");
  var fxSheet = spreadsheet.getSheetByName('childFeed');
  var mycell = spreadsheet.getActiveSelection();
  var cellcol = mycell.getColumn();
  var cellrow = mycell.getRow();

  var timeAndDay = new Date();

  var rowData = fxSheet.getSheetValues(1, 5, 7, 2);
  var lastRow = fxSheet.getLastRow();
  var mailBody = "\n";

  for(i=1;i<lastRow-1;i++){
    mailBody = mailBody + rowData[i][0] + " = " + rowData[i][1] + "\n"
  }

  var recipients = "rj@ad-lib.io";
  var subject = "[DBS]FX rate API update";

  var body =
    "Here are the FX rate values as of " + timeAndDay + " " + timeAndDay.getHours() + ":" + timeAndDay.getMinutes() + "\n" +
    mailBody + "\n"+
    "To view them, visit: " + spreadsheet.getUrl();


    MailApp.sendEmail(recipients, subject, body);

  Logger.log(body);
}

function isError_(cell) {
  // Cell is a value, e.g. came from `range.getValue()` or is an element of an array from `range.getValues()`
  const errorValues = ["#N/A", "#REF", "#ERROR" ];
  for (var i = 0; i < errorValues.length; ++i)
    if (cell == errorValues[i])
      return true;

  return false;
}

function logErrors() {
  const vals = SpreadsheetApp.getActive().getSheets()[0].getDataRange().getValues();
  for (var row = 0; row < vals.length; ++row) {
    for (var col = 0; col < vals[0].length; ++col) {
      if (isError_(vals[row][col])) {
        Logger.log("Array element (" + row + ", " + col + ") is an error value.");
      }else{
        Logger.log("Array element (" + row + ", " + col + ") is not an error value.");
      }
    }
  }
}