Get all events from a Calendar on a Spreadsheet

I was just asked in a recent scripting session that I delivered, how to get all of the events from a calendar. It can be a little tricky with Javascript dates, so I've quickly thrown together a spreadsheet template that does that.

All you need to do is get the Calendar ID which you can do by going into the calendar settings and copying the link (see image below). Choose two dates and press the button to run! All events between those two dates will appear on the 'Output' sheet.



To get the sheet, you will need to click 'File' and 'Make a copy' of this doc.

It will then be stored in your drive.

Very useful for auditing purposes!

Let me know your thoughts and feedback!