Auto Password Reset Gmail

reset.gs

function resetPassword() {
  var ss = SpreadsheetApp.getActive();
  var cell = ss.getSheetByName('counter').getRange(1, 1)
  var counter = cell.getValue();
  cell.setValue(counter+1);
  var data = ss.getSheetByName('Emails').getDataRange().getValues()
  if (counter % 6 === 0){
    for (var i = 0; i < data.length; i++){
      var email = data[i][0];
      Logger.log(email);
      try{
      var user = AdminDirectory.Users.get(email);
      user.changePasswordAtNextLogin = true;
      var response = AdminDirectory.Users.update(user, email);
      Logger.log('success');
      }
      catch(e){
        Logger.log('fail');
        Logger.log(e);
      }
    }
  } else {
    Logger.log(counter)
  }
    
}

function emailReminder(){
  var ss = SpreadsheetApp.getActive();
  var cell = ss.getSheetByName('counter').getRange(1, 1)
  var counter = cell.getValue();
  var data = ss.getSheetByName('Emails').getDataRange().getValues()
  if (counter % 6 === 0){
    for (var i = 0; i < data.length; i++){
      var email = data[i][0];
      Logger.log(email);
      MailApp.sendEmail(email, 'Password Reset on Monday', 'Just a reminder that on Monday you will need to change your Gmail password. The system will automatically ask you to do this. No action is currently required by you.');
    }
  }
}