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
)
}