Calendar Event Alert

// Δημιουργία Μενού

function onOpen(){
  const ss = SpreadsheetApp.getActive();
  const menuEntries = [];
  menuEntries.push({name: 'Εισαγωγή σε Ημερολόγιο', functionName: 'scheduleShifts'});
  ss.addMenu('Carousel', menuEntries);
}

// Δημιουργία Event

function scheduleShifts() {
var spreadsheet = SpreadsheetApp.getActiveSheet();
    var calendarID = spreadsheet.getRange("B2").getValue();
    var eventCal = CalendarApp.getCalendarById(calendarID);
    const signups = spreadsheet.getRange("A4:D110")
    .getValues()
    .filter(row => row.every(String));

for (x=0; x<signups.length;x++)

{
    var shift = signups[x];
    var startTime = shift[0];
    var action= shift[2];
    var description= shift[1];
    var endTime= shift[3];
    eventCal.createEvent(action, startTime, endTime, { description: shift[1] } ).setColor(4)
}
}