newsletter unsubscription tracker / 08 - isAlreadyLogged() helper function.js

08 - isAlreadyLogged() helper function.js

// Helper function to check if an email is already in the sheet
function isAlreadyLogged(email, sheet) {
  var data = sheet.getDataRange().getValues(); // Get all values in the sheet
  for (var i = 0; i < data.length; i++) {
    if (data[i][0] === email) {
      return true; // Return true if email is already logged
    }
  }
  return false; // Return false if the email is not in the sheet
}