Automated Reminder System

reminders.gs

function shareNewsletter() {
  var folder = DriveApp.getFolderById('0B3QaE26f2r25OFZVMGxlM0syRG8')
  var driveFile = DriveApp.getFileById('1mZEQniUTJurXWZeeZLI5zscI_FSNlFM11NHoH8FjeHo');
  var date = new Date(Date.now()+777600000);
  var formattedDate = Utilities.formatDate(date, "GMT+1", "MM/dd/yyyy");
  var doc = driveFile.makeCopy(formattedDate + ' Newsletter Template', folder);
  var url = doc.getUrl();
  var editors = folder.getEditors();
  Logger.log(editors);
  for (var i = 0; i < editors.length; i++){
    var message = 'Dear '+editors[i].getName()+',\n\nThe newsletter template for '+formattedDate+' is ready for editing:\n\n'+url+'\n\nThanks,\nJohn Hinkle';
    MailApp.sendEmail(editors[i].getEmail(), 'Newletter template for '+formattedDate, message)
  }
  SpreadsheetApp.openById('1MUSToNCvPnkv_Ze6RjeKHub3rHh7DuvpRmsOWWWC19k').getSheetByName('newletterIDs').appendRow([doc.getId(),formattedDate,url])
}

function checkEdits(){
  var idSheet = SpreadsheetApp.openById('1MUSToNCvPnkv_Ze6RjeKHub3rHh7DuvpRmsOWWWC19k').getSheetByName('newletterIDs')
  var recentId = idSheet.getRange(idSheet.getLastRow(),1).getValue();
  var url = idSheet.getRange(idSheet.getLastRow(),3).getValue();
  Logger.log(recentId);
  var doc = DocumentApp.openById(recentId).getBody();
  var data = SpreadsheetApp.openById('1MUSToNCvPnkv_Ze6RjeKHub3rHh7DuvpRmsOWWWC19k').getSheetByName('sectionResponsibilties').getDataRange().getValues();
  for (var i = 0; i < data.length; i++){
    if (doc.findText(data[i][0])){
      Logger.log(data[i][1])
      var message = 'You still have not finished updating your section this weeks newsletter. Please do so soon:\n\n'+url+'\n\nThanks,\nJohn Hinkle';
      var subject = 'Please Update the Newsletter';
    } else {
      var message = 'Thank-you for updating the newsletter. Please click below to check if your section is correct before I crete the newsletter\n\n'+url+'\n\nThanks,\nJohn Hinkle';
      var subject = 'Newsletter Update';
    }
    MailApp.sendEmail(data[i][1], subject, message);
  }
}

function checkEdits2(){
  var idSheet = SpreadsheetApp.openById('1MUSToNCvPnkv_Ze6RjeKHub3rHh7DuvpRmsOWWWC19k').getSheetByName('newletterIDs')
  var recentId = idSheet.getRange(idSheet.getLastRow(),1).getValue();
  var url = idSheet.getRange(idSheet.getLastRow(),3).getValue();
  Logger.log(recentId);
  var doc = DocumentApp.openById(recentId).getBody();
  var data = SpreadsheetApp.openById('1MUSToNCvPnkv_Ze6RjeKHub3rHh7DuvpRmsOWWWC19k').getSheetByName('sectionResponsibilties').getDataRange().getValues();
  for (var i = 0; i < data.length; i++){
    if (doc.findText(data[i][0])){
      Logger.log(data[i][1])
      var message = 'This is a remeinder to update your newsletter before tomorrow:\n\n'+url+'\n\nThanks,\nJohn Hinkle';
      var subject = 'Newsletter Updates Due Tomorrow';
      MailApp.sendEmail(data[i][1], subject, message);
    } 
  }
}