Automate hour checking for National Honors Society (NHS) Students.
We have 300+ students participating in NHS each year, so manually accumulating hours is infeasible. Furthermore, the hours need to be sorted by non-NHS and NHS-specific hours, with different criteria based on grade level. This was the motivation to create this code—make the process simpler not just for the students, but also for the NHS leadership to verify, calculate, and award people's community service.
This script pulls data from current and last year spreadsheets, calculates roll-over hours for current seniors, manipulates data, and sends an automated email to students with their hours on request. This was written in Google Apps Script and is meant to be run with Google Sheets.
NOTE: Idenitifying information has been redacted, you will have to change the spreadsheets IDs yearly.
Created by Vivek Mehta, (NHS President, Class of 2025)
I noticed a lot of other people would benefit from a template to grab data from Google Sheets and send automated emails, so I created a template for that. The template/instructions.md file has detailed instructions on how to use the template.
This project is licensed under the MIT License - see the LICENSE file for details.