The result of parsing calendar with Google Apps Script tool can be shown in this screenshot:
To import a google calendar in your drive google spreadsheet, just create a spreadsheet document file use Google Apps Script.
Open Google Apps Script from Tool – Script Editor.
Use this script with your google calendar:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 | function myFunction() { var ss = SpreadsheetApp.getActiveSpreadsheet(); //In between the quotations paste your calendar ID var cal = CalendarApp.getCalendarById('j7gov1cmnqr9tvg14k621j7t5c@group.calendar.google.com'); //Change the dates in between the quotations var start = new Date('August 27, 2016'); var end = new Date('September 3, 2019'); //Do not touch any of this stuff var events = cal.getEvents(start, end); Logger.log(events.length); var num = events.length; ss.insertSheet(0); var sheet = ss.getSheets()[0]; for(var i=0; i<num; i++){ sheet.getRange(i+1, 4).setValue(events[i].getStartTime()); sheet.getRange(i+1, 1).setValue(events[i].getTitle()); sheet.getRange(i+1, 3).setValue(events[i].getLocation()); sheet.getRange(i+1, 2).setValue(events[i].getDescription()); sheet.getRange(i+1, 5).setValue(events[i].getEndTime()); } } |
You can see, I used my calendarId from Python Events Calendar:
1 2 | Calendar ID j7gov1cmnqr9tvg14k621j7t5c@group.calendar.google.com |