Skip to content

Helps synchronize work absences across your Google, Outlook and HR systems

License

Notifications You must be signed in to change notification settings

matthewturner/absence-management

Repository files navigation

Absence Management

Helps synchronize work holidays across your Google, Outlook and HR systems.

image

Usage

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)

Installation

  1. Create a Google Spreadsheet
  2. Import absences.sample.xlsx
  3. Create a script project in your spreadsheet
  4. Add the files in this repo (renaming to .gs extension)
  5. Register the OAuth2 library here
  6. Register your app in the Azure Portal Active Directory
  7. Enter your tenant, client id and secret in the Settings.gs file

About

Helps synchronize work absences across your Google, Outlook and HR systems

Resources

License

Stars

Watchers

Forks

Packages

No packages published