Note: This blog has been abandoned, any future updates will be found here: https://phillipgreenii.github.io/google-calendar-to-google-sheets/
Personally, I love both spreadsheets and google calendar and some times it makes sense to keep them in sync. The use case that started me on this was a calendar to keep track of important work dates. Having things show up on my google calendar is great for keeping track of everything, but I have not found any simple way of doing bulk uploads. My solution is to dump into a spreadsheet all of the events (holidays, major releases, ...). There is one place to look. I then added a menu to either push events from the spreadsheet to my calendar or vice versa. The process is manual, but I haven't had any problems. Generally, I view and update events through the calendar. When necessary, I drop into the spreadsheet, pull from the calendar, make my changes, then push back to the calendar. Below is the code I use to make it happen.
