MoFo All-hands Schedule App Data Processor

This script is designed as a data processor helper for mofo-allhands repo. If you want to use this script as is make sure your Google Spreasheet is based on the Google spreadsheet template we designed.

This Schedule App Data Processor script handles the following tasks

1. takes data from a Google spreadsheet,
2. and converts it to a JSON array where each object has keys corresponding to the spreadsheet column names,
3. then stores that JSON locally and/or automatically commits it to a GitHub repo (your schedule app repo, e.g., [MoFo All-hands schedule app](https://github.com/m ozilla/mofo- allhands)).

To run the script

1. Create a Python virtual environment and install all the required packages. See create a Python virtual environment docs for instructions.
2. Get API creds from GitHub and Google. See authentication docs for instructions.
3. Share your Google Spreadsheet with the Google Service Account that you created in Step 2.
4. Set values for environment variables and run source your-file-name.env
5. Running update_schedule() will execute these methods in succession. You can trigger it from the command line: python update_schedule.py