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
- Install the Google API Python Client
- Create a new Google Calendar and note the Calendar ID from it's settings.
- Save a copy of the CAS4 Google Sheets document to your Google Drive. Note it's new Document ID.
- Prefill or modify the CAS4 template document as necessary.
- Update generate_timesheets.py with the corresponding CALENDAR ID and DOC ID noted from above.
- Enable the Google Calendar API to allow the script to access calendar events.
- Enable the Google Sheets API to allow the script to access the CAS4 template document.
- Create a new OAuth client ID from the Google API Console Credential page. Follow instructions here.
- Download and save the credentials as
client_secret.json
in this directory
Generating Timesheets
$ python generate_timesheets.py
Authors
- Susheel Varma http://github.com/susheel