Helps synchronize work holidays across your Google, Outlook and HR systems.
Add absence records to the spreadsheet, marking them as Sick, Bank holiday, Holiday etc.
Use the Calendar menu options to:
- Create/update/delete entries in your Google and Outlook calendars
- Check your HR system (copied in to the [year - HR] worksheet)
- Create a Google Spreadsheet
- Import absences.sample.xlsx
- Create a script project in your spreadsheet
- Add the files in this repo (renaming to .gs extension)
- Register the OAuth2 library here
- Register your app in the Azure Portal Active Directory
- Enter your tenant, client id and secret in the Settings.gs file