Create a List of Your Google Calendar Events
Have you ever wanted a simple list of every event on your Google Calendar? Use this Google Sheets template to extract a list of your events.
When you create a copy of the template you will notice a spot in cell B2 on the info tab to paste the id of the Google Calendar you want to make a list of.
In cells B3 and B4 of the info sheet adjust the dates for the list of events you want to review.
You will need to authorize the Add-on script. You may get a screen of doom that has a button that says “Back to Safety.” It is safe. I personally coded this Add-on. Click on the tiny words “advanced” and the tiny words “unsafe” (again, it is safe.) and accept the access permissions. Note you are authorizing YOURSELF access, not anyone else.
That is it! A new sheet will be added with a list of your calendar events and the amount of time the event lasts assuming it is not an all day or multi-day event.