Abandoned

Note: This blog has been abandoned, any future updates will be found here: https://phillipgreenii.github.io/

Friday, December 12, 2014

Google Calendar to Google Sheets Bidirectional Sync

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.