I created this to find out about all the events with external attendees happening in my org.
- Get creds, with
calendar.CalendarReadonlyScopeandsheets.SpreadsheetsScopescopes, using this guide - Post deploying this lambda, you need to call the watch events API, with this lambda's function URL as part of the request and all the public calendars you want to watch, for Google to actually send webhooks.
- Event duplicacy: The webhooks from Google unfortunately don't contain ANY info about addition/removal/updation of events - just that something has changed in the events resource of a calendar (id). The logic in this repo gets the list of (hopefully) the most recent events and just writes them all to the spreadsheet. This means there can be duplicacy. While duplicates can be removed using the tools this repo already has, duplicates can also be removed by a 3-click journey on the spreadsheet itself manually or by automating with a macro, so I'm not handling it and indulging my procrastinating self.