Advertisement
Guest User

Untitled

a guest
Jun 24th, 2019
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.18 KB | None | 0 0
  1. function loops(){
  2.  
  3. // Runs at approximately 8:30am in the timezone of the script
  4. ScriptApp.newTrigger('loops')
  5. .timeBased()
  6. .atHour(8)
  7. .nearMinute(30)
  8. .everyDays(1)
  9. .create();
  10.  
  11. var report = SpreadsheetApp.getActive();
  12. var ss = SpreadsheetApp.getActiveSpreadsheet()
  13. var emailList = ss.getSheetByName("Email Reminder");
  14.  
  15. var data =
  16. emailList.getRange(3,19,emailList.getLastRow()-1,24).getValues();
  17. //Logger.log(data);
  18.  
  19. data.forEach(function(row,i){
  20. var id = row[0];
  21. var customer = row[1];
  22. var user = row[2];
  23. var URL = row[3];
  24. var proposedCount = row[4];
  25. var pendingCount = row[5];
  26.  
  27.  
  28. if(proposedCount==36){
  29. MailApp.sendEmail(user, customer, customer + " has been in the
  30. proposal stage for " + proposedCount + " days." +"n" +"n" + URL +
  31. "n" + "nThis is a reminder to keep this job in front of you :)" +
  32. "n" + "nYour friendly neighborhood accountability partner");
  33. }
  34. if(pendingCount==15){
  35. MailApp.sendEmail(user, customer, customer + " has been in the
  36. pending stage for " + pendingCount + " days." + "n" + "n" + URL +
  37. "n" + "nThis is a reminder to keep this job in front of you :)" +
  38. "n" + "nYour friendly neighborhood accountability partner");
  39. }
  40.  
  41. });
  42.  
  43. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement