getEvents.gs

//get events from calendar to sheet
function getEvents() {
 
  var calenDar = CalendarApp.getCalendarById("Your Calendar ID");
  var lastDateOfYear = new Date(new Date().getFullYear(), 11, 31); // JavaScript counts months from 0 to 11. January is 0. December is 11.
  var events = calenDar.getEvents(new Date(), lastDateOfYear); // new Date() = today
  var spreadSheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  
  var lastRow = spreadSheet.getLastRow();
  spreadSheet.getRange(2, 1, lastRow, 5).clearContent();
 
  //add event to sheet
  for(var i = 0; i < events.length; i++) {
    var title = events[i].getTitle();
    var start = events[i].getStartTime();
    var end = events[i].getEndTime();
    var location = events[i].getLocation();
    var description = events[i].getDescription();
    
    spreadSheet.getRange(i+2, 1).setValue(title);
    spreadSheet.getRange(i+2, 2).setValue(start);
    spreadSheet.getRange(i+2, 2).setNumberFormat("dd/mm/yyyy h:mm:ss");
    spreadSheet.getRange(i+2, 3).setValue(end);
    spreadSheet.getRange(i+2, 3).setNumberFormat("dd/mm/yyyy h:mm:ss");
    spreadSheet.getRange(i+2, 4).setValue(location);
    spreadSheet.getRange(i+2, 5).setValue(description);
  }
}