Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function loops(){
- // Runs at approximately 8:30am in the timezone of the script
- ScriptApp.newTrigger('loops')
- .timeBased()
- .atHour(8)
- .nearMinute(30)
- .everyDays(1)
- .create();
- var report = SpreadsheetApp.getActive();
- var ss = SpreadsheetApp.getActiveSpreadsheet()
- var emailList = ss.getSheetByName("Email Reminder");
- var data =
- emailList.getRange(3,19,emailList.getLastRow()-1,24).getValues();
- //Logger.log(data);
- data.forEach(function(row,i){
- var id = row[0];
- var customer = row[1];
- var user = row[2];
- var URL = row[3];
- var proposedCount = row[4];
- var pendingCount = row[5];
- if(proposedCount==36){
- MailApp.sendEmail(user, customer, customer + " has been in the
- proposal stage for " + proposedCount + " days." +"n" +"n" + URL +
- "n" + "nThis is a reminder to keep this job in front of you :)" +
- "n" + "nYour friendly neighborhood accountability partner");
- }
- if(pendingCount==15){
- MailApp.sendEmail(user, customer, customer + " has been in the
- pending stage for " + pendingCount + " days." + "n" + "n" + URL +
- "n" + "nThis is a reminder to keep this job in front of you :)" +
- "n" + "nYour friendly neighborhood accountability partner");
- }
- });
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement