Get list of calendar events and put them in a spreadsheet

put-calendar-events-in-sheet.gs

// Compiled using ts2gas 1.6.0 (TypeScript 3.3.3333)
var exports = exports || {};
var module = module || { exports: exports };
var startCol = 1;
var endCol = 2;
var titleCol = 3;
function main() {
    var events = getEventsNext365Days();
    putEventsInSheet(events);
}
function getEventsNext365Days() {
    var now = new Date();
    var future = new Date(now.getTime() + 1 * 365 * 24 * 60 * 60 * 1000);
    return CalendarApp.getEvents(now, future);
}
function putEventsInSheet(events) {
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0];
    events.forEach(function (event, i) {
        var row = i + 2;
        var startCell = sheet.getRange(row, startCol);
        var endCell = sheet.getRange(row, endCol);
        var titleCell = sheet.getRange(row, titleCol);
        startCell.setValue(event.getStartTime().toISOString());
        endCell.setValue(event.getEndTime().toISOString());
        titleCell.setValue(event.getTitle());
    });
}