Google Script - Sync Google Calendar to Spreadsheet by Specific Date Range
(This is m odified from Davepar’s project and examples at GitHub https://github.com/Davepar/gcalendarsync which can do a sync either direction.) I had a colleague ask if she could easily copy calendar events into a spreadsheet for a log. We discussed using the Agenda view in calendar, but she needed to do some calculations and data analysis with the information so a spreadsheet was the obvious landing place for the information. After finding (and previously using) Davepar's script to create Calendar events from a Sheet, it made sense to revisit it and break it down the other way. After doing that, it made sense to let the user input the desired date range on the spreadsheet. Here's the result: (Feel free to grab the Script if you want to make your own modifications- this one is an easy one with only 1 line of code to update.) Directions : Part 1 - Set Up the Calendar: Create a new Google Calendar (in the dropdown next to "My calendars" in the le...