Reads from our Event Log and RSVP + Sign In spreadsheets to tally up the attendance count.
- Follow Google Spreadsheet API Guidelines for Python https://developers.google.com/sheets/api/quickstart/python to enable account and obtain the credentials on an account that has access to the Event Log and RSVP + Sign In forms. Additionally, make sure you have Python and the necessary packages installed (all at that link).
- Clone this repo, cd into it
- Edit the code at the bottom of tally.py to adjust the functionality you need.
- python tally.py