This script is made for Google Apps Scripts. It works with a google sheet in order to pull classes and their info and then create google calendar events that the recording hardware in the classrooms use to schedule their recordings It keeps track of which classes were successfully scheduled and which ones were not. If it was unsuccessful it highlights the specific data that it was unable to parse and checks a certain box on that row to indicate what problem it ran into.
It also creates and organizes a spreadsheet to keep track of the scheduled recordings. There are other scripts that my manager made that are then used on that spreadsheet to implement a process through which students who miss class can automatically be students the recording of the class that they missed.
The first two screenshots show the spreadsheet from which the data is pulled. The first is to show the layout,
and the second is to show an example of the error handling.
This third screenshot shows the resulting scheduled classes sheet used to keep track of the recordings and then to connect to the campus
canvas services with further scripts written by my manager.
