Om Nom Nom ᗧ• • •
https://developers.google.com/sheets/api/quickstart/python
- Python 2.6 or greater
- pip package management tool
- A Google Account
- Google Sheet Credentials (credentials.json)
pip install --upgrade google-api-python-client google-auth-httplib2 google-auth-oauthlib python-dotenv
| Key | Description |
|---|---|
| SOURCE_EVENT_SHEET_ID | Google Sheet ID of Event Point Log |
| SOURCE_EVENT_SHEET_RANGE | Google Sheet Range of Event Point Log Data excluding headers |
| SOURCE_MENTOR_SHEET_ID | Google Sheet ID of Mentor Point Log |
| SOURCE_MENTOR_SHEET_RANGE | Google Sheet Range of Mentor Point Log Data exluding headers |
| DESTINATION_TOTAL_SHEET_ID | Google Sheet ID of Total Point Log to be displayed |
| DESTINATION_TOTAL_SHEET_RANGE_HEADER | Google Sheet Range of Title headers |
| DESTINATION_TOTAL_SHEET_RANGE_BODY | Google Sheet Range of Total Point data |
| DESTINATION_DONE_SHEET_ID | Google Sheet ID of Inductee emails who finished |
| DESTINATION_DONE_SHEET_RANGE_BODY | Google Sheet Range of Inductee emails who finished |
crontab -e
0 22 * * * cd [hkn-pacman dir] && python pacman.py
- add total event points
- add professional requirement check
- add event list
- add officer list
- add mentor requirement check
- add cron job (10pm daily)
- clean code
- write proper documentation