email_meeting_reminder.gs

// Project trigger is available in UI.
function SendEmail() {
  var agendaSheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0];
  var emailTempSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Email Template")
  var startRow = 2;
  
  var emailTemp = emailTempSheet.getDataRange().getValues()
  var address = emailTemp[0][1]
  var subject = emailTemp[1][1]
  var meetingTP = emailTemp[2][1]
  var meetingD = emailTemp[3][1]
  
  var agenda = agendaSheet.getDataRange().getValues();
  var today = new Date();
  var tomorrow = new Date();
  tomorrow.setDate(today.getDate()+1)
      
  for (var i = startRow; i < agenda.length; i++){
  date = Utilities.formatDate(agenda[i][0], "GMT", "MM/dd/yyyy")
    if (date == Utilities.formatDate(tomorrow, "GMT-8", "MM/dd/yyyy")){
      speaker = agenda[i][1]
      topic = agenda[i][2]
      links = agenda[i][3]
      subject += " - "+date
      meetingContent = "This week, "+ speaker + " will present '" + topic + "'. "
      if (links!=""){
        meetingContent += "Related links: "+links+"."
      }
      msg = meetingTP + "\n\n" + meetingContent + "\n\n" + meetingD
      MailApp.sendEmail(address, subject, msg)
    }
  }
}