google script to write from spreadsheet to calendar

google script to write from spreadsheet to calendar

function logProductInfo() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var data = sheet.getDataRange().getValues();
  
//  var today = new Date();
  var today = data[0][7];
  var events = CalendarApp.getDefaultCalendar().getEventsForDay(today);

  events.forEach(function(e){
          
    Logger.log(e.getTitle());
    var title = e.getTitle();
           Logger.log(title.match("zz"));
 
    if (title.match("\:ev\:")) {
    e.deleteEvent(); //deletes ALL events
    }
                 })
  
  for (var i = 3; i < data.length; i++) {
    
    var action = data[i][1];
    var minutes = data[i][2];
    var ts = data[i][4]; //already Date object
    var te = data[i][5];//already Date object

    var date = today;//set up at the beginning of the function
    var startDateAndTime = new Date(date.getFullYear(),(date.getMonth() + 1), date.getDate() - 1, 7, 30);
    


    var writeToCal = {
      action: action,
      ts: new Date(date.getFullYear(), 
                   (date.getMonth()),
                   date.getDate(), 
                   ts.getHours(), 
                   ts.getMinutes()),
     te: new Date(date.getFullYear(), 
                   (date.getMonth()),
                   date.getDate(), 
                   te.getHours(), 
                   te.getMinutes()),
    }                   
  writeToCalendar(writeToCal);
    
  }
}

function writeToCalendar(dto){
  
  var event = CalendarApp.getDefaultCalendar().createEvent(":ev:" + dto.action,dto.ts,dto.te);
  Logger.log(" the event id is: " + event.getId());
}