Sheet Helper

This script is responsible for bridging notifier, handle_submissions, and attendance_checker scripts to google sheets when used. Depends on googleapiclient package and credentials.json file for the corresponding account. The process to get credentials defined in detail here.

Tips & Pitfalls

• Parameters widely used in other scripts that show the spreadsheet location, as well as the inner sheet IDs, should be updated to match the main google sheet. These parameters are spreadsheet_id, section1_sheet_id, and section2_sheet_id.
• This script also contains some coloring options for updating the sheet as well.