App Script to get events from Calendar API and insert to Spreadsheet

calendar2sheet.js

// Reference: https://www.youtube.com/watch?v=YDhln3ukH7Y&t=3s

function getEvents() {
  var calId = "[email protected]"; // this is a Google Calendar Id
  var startDate = "9/1/2021 12:00 AM" // Month/Day/Year
  var endDate = "9/13/2021 11:59 PM" // Month/Day/Year
  var nameOfSheet = "getEventsSheet" // You must have Filename and Sheet names (your tabs inner doc)

  // spreadsheet
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName(nameOfSheet);
  
  // calendar 
  var cal = CalendarApp.getCalendarById(calId);
  var events = cal.getEvents(new Date(startDate), new Date(endDate))

  for (var i = 0; i < events.length; i++) {
    var event = events[i]
    var title = event.getTitle();
    var start_time = event.getStartTime();
    var end_time = event.getEndTime();
    var location = event.getLocation();
    var description = event.getDescription();

    // writing sheet
    sheet.getRange(i+2, 1).setValue(title)
    sheet.getRange(i+2, 2).setValue(start_time)
    sheet.getRange(i+2, 3).setValue(end_time)
    sheet.getRange(i+2, 4).setValue(location)
    sheet.getRange(i+2, 5).setValue(description)
  }

  Logger.log("Eventos adicionados na planilha.");
}