Google Sheets Email Alert Reminder

function sendReminderEmails() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = sheet.getRange(2, 1, sheet.getLastRow() - 1, 8).getValues(); // Assuming data starts from row 2

  var today = new Date();
  
  data.forEach(function(row) {
    var task = row[0];
    var expirationDate = row[1];
    var fileDate = row[2];
    var status = row[3];
    var reminderDates = row.slice(4); // Slice reminder dates

    if (status !== "Complete") {
      for (var i = 0; i < reminderDates.length; i++) {
        var reminderDate = reminderDates[i];
        if (reminderDate !== "" && new Date(reminderDate) <= today) {
          sendEmail(task);
          break; // Stop checking further reminder dates for this row
        }
      }
    }
  });
}

function sendEmail(task) {
  var subject = task + " Reminder";
  var recipient = "email@email.com"; // Change this to your email address
  var body = "This is a reminder for task: " + task;

  MailApp.sendEmail({
    to: recipient,
    subject: subject,
    body: body
  });
}