Our district now wants a weekly compliance snapshot; exporting from PowerSchool and using a conditional-format template in Sheets cut it to 8 minutes per grade. Anyone got an even faster flow — maybe a script that flags missing doses on import?
I cut it to about 2 minutes/grade with a Google Apps Script that runs on import, pulls immunization fields via the PowerSchool REST API, compares to a tiny per-grade rules tab, and writes a “Needs: MMR2/DTaP5” note per student — like a bouncer list for shots. Docs if you want to mirror the fetch: PowerSource, but caveat that field names vary so you’ll need a quick mapping. Happy to share the snippet.