Peer Tutoring

Backup code for the Peer Tutoring automation system.

Tutor Migration Instructions

Create a Google Sheet called peertutoring_XXXX-YYYY where XXXX-YYYY is the current school year
Organize peer tutor information in rows in a sheet called Tutors as follows with the header included*:

Name	Email	Day	Consult	Subjects
Noah Trupin	ntrupin23@lawrenceville.org	Monday, Tuesday	TRUE	Math I-III, Honors Computer Programming
...	...	...	...	...

Organize head tutor information in rows in a sheet called Heads as follows with the header included **:

Name	Email
Sam Tang	stang22@lawrenceville.org

* Noah Trupin is an example. The names of the headers don't matter. Data just needs to start in the second row.

** Sam Tang is an example. See previous point about headers.

Order of operations matters. Doing these out of order may cause triggers to not fire or cause the script to not link to the spreadsheet.

Create a new Google Sheet
In Google Sheets, select Tools -> Create a form
In Google Sheets, select Tools -> Script editor
In Apps Script, copy contents of Code.gs to the new Code.gs
Select Triggers -> Add Triggers and configure as follows:
- Choose which function to run: onFormSumbit
- Choose which deployment should run: Head
- Select event source: From spreadsheet
- Select event type: On form submit
Run each function in Code.gs to obtain OAuth permissions