UPDATED: 08/27/2021 I’ve updated the public app to handle larger jobs now.
Approximately 3 years ago I wrote a post on using Apps Script to copy events from a calendar feed to your primary Google Calendar. The purpose was to efficiently and accurately get a teacher’s class schedule onto their Google Calendar. Teacher’s schedules are not often conducive to the recurrence options in Google Calendar so I set off looking for a better way. While the solution I developed worked, it required more maintenance on my end than I wanted and it had to be done over the course of an entire day to fully populate a teacher’s calendar while avoiding event creation quota errors.
Having grown as a developer I revisited this idea and created a much more efficient and hands-off approach to accomplishing this goal.
This approach requires that users first add their schedule’s webcal feed to Google Calendar, then establish a date range for copying events. This means once the feed has been added, the app can be used in subsequent years/semesters with no maintenance from me. Here is a demonstration of the app:
You can access and use the app here, but know that it’s not been verified by Google, so you will see those warnings before authorizing the app. If you’d like the source code to further develop and deploy your own solution internally in your own environment please consult the code shared at this GitHub project. This was incredibly helpful for me when building this solution.