Email When Over 10 Days Since Last Update

A proactive informational alert Email When Over 10 Days Since Last Update.

Code.gs

function emailWhen10(){
  var crm = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("CRM")
  var data = crm.getDataRange().getValues()
  var emailBody = ""

  for (var i=1; i <data.length; i++){

    var client = data[i][0]
    var company = data[i][1]
    var assigned = data[i][4]
    var datesSince = data[i][6] // column G

    if (datesSince > 9 ){
        emailBody += client 
        + " | " + company 
        + " | assigned to: "  + assigned +"\n"

    }
  }

  if (emailBody == "") return;


  MailApp.sendEmail(
    SpreadsheetApp.getActiveSpreadsheet().getOwner().getEmail(),
    "🚨 Over 9 Days!!!! ",
    "Over 9 days since last update: \n\n" + emailBody
  )




}