/CAS4-Timesheet-Generator

CAS4 Timesheet Generator using Google Calendar and Google Sheets

Primary LanguagePythonOtherNOASSERTION

CAS4 TimeSheet Generator

Simple python script that generates a University of Manchester's CAS4 - Casual Timesheet. It uses Google Calendar to manage daily work entries and a Google Sheets doc as a template to generate a timesheet per week of the year.

Pre-Requirements

  1. Install the Google API Python Client
  2. Create a new Google Calendar and note the Calendar ID from it's settings.
  3. Save a copy of the CAS4 Google Sheets document to your Google Drive. Note it's new Document ID.
  4. Prefill or modify the CAS4 template document as necessary.
  5. Update generate_timesheets.py with the corresponding CALENDAR ID and DOC ID noted from above.
  6. Enable the Google Calendar API to allow the script to access calendar events.
  7. Enable the Google Sheets API to allow the script to access the CAS4 template document.
  8. Create a new OAuth client ID from the Google API Console Credential page. Follow instructions here.
  9. Download and save the credentials as client_secret.json in this directory

Generating Timesheets

$ python generate_timesheets.py

Authors