Currently we extract classes schedule by running a script that parses schedule from Google Sheets. This approach is unreliable due to the main reason: administration does not follow any strict format when updating the schedule, so parsing scripts may fail at any time and it's hard to maintain them.
Instead of parsing Google Sheets, we can get access to the source of all the classes — from Outlook events.
[ ] Get access to Outlook service account
[ ] Figure out a way to scrap classes events using API
Summary
Currently we extract classes schedule by running a script that parses schedule from Google Sheets. This approach is unreliable due to the main reason: administration does not follow any strict format when updating the schedule, so parsing scripts may fail at any time and it's hard to maintain them.
Instead of parsing Google Sheets, we can get access to the source of all the classes — from Outlook events.