Email bot to automate Peertutor & Wrting Lab scheduling for Kent School
October 2020
Explore the docs »
View Demo
·
Report Bug
·
Request Feature
This emailBot is a demonstration project used in my automation proposal made to Kent School Library in November 2020. The main idea in this proposal was to change ARC(Writing Lab)'s sign-up system from handwriting on whiteboard to simple google forms/sheets.
Instead of students having to travel across the campus to write their name on library's whiteboard, using simple python scripts and google forms can make ARC reservation as easy as click of a button.
Of course, when they want to make a reservation, they will have to check what timeslot/tutor/teacher are available.
Rather than tediously visiting library several times a day to check the whiteboard, students can check the real-time timetable anywhere anytime using their phone.
This google sheet can only be editted by scripts to prevent others from changing schedules to their advantage. (Trust me, it happened a lot)
ARC-checker.py runs every five minutes to check for any new form submissions. If a new submission is found, the script will simply compare with google sheets to check if a desired timeslot is available, and send a confirmation/rejection email to both students and tutor/teacher.
This project dates back to April 2019 when I was a senior at Kent. The original idea was to use chatbots using iMessages to perform the same function, but I was set back with several obstacles regarding school's web server security and questionable stability upon my graduation. This demonstration was simply to spark new ideas to current members of Kent Coding Club rather than a serious attempt to change Kent School Library's on-going system. However, I do hope that a more efficient signup system is implemented someday whether it's by another student, faculty member, or myself.
Tyler Kim - taewook.kim@columbia.edu
Project Link: https://github.com/tylertaewook/kentschool-emailbot