Staff Schedule

Creates work schedule inside Google Calendar based on Excel Sheet

Roadmap

Step 1: Setting Up Web Server to receive Schedule Email

Status: Not started yet

Task/Issues: None

Step 2: Decrypt Email and Grab the Excel Sheet

Status: Not started yet

Task/Issues: None

Step 3: Prepare Information from Excel Sheet based on Employee ID Number

Status: In-progress

File: main.py

Task/Issues:

• Implement different schedule based on Employee's ID Number

Step 4: Use Google Calendar API to add schedule to Employee's Calendar

Status: Completed

File: insertEvent.py

Task/Issues:

• Booking times before daylight savings will appear off by one hour when booked