Send weekly JEE/NEET parent reports via WhatsApp with OpenAI and Google Sheets

## 🎓 CoachingOS – JEE/NEET Parent Weekly Report For JEE and NEET coaching institutes whose parents only hear about marks at the monthly PTM, and whose faculty find out a whole batch is weak on a topic after the next mock goes badly. ### How it works Every Sunday evening the workflow reads each student's recent test scores and works out subject and topic accuracy, negative-marking share, week-on-week change and batch rank. GPT-4o-mini turns that into a short, honest WhatsApp report for each parent, with a scorecard and a trend chart. When many students in a batch struggle with the same topic, that faculty member gets an alert and an AI remedial plan. The academic head gets one summary. Parents can reply to the report. The AI understands the reply, answers from that week's report, arranges a mentor callback for worried parents, and honours STOP. ### Setup steps 1. Create a Google Sheet with Students (including parent_whatsapp), Test Scores (one row per student, test and topic), Faculty, Report Log, Weak Topics and Callbacks tabs. 2. Connect WhatsApp Business Cloud (trigger and send), Google Sheets, Gmail and OpenAI. 3. Edit Set CoachingOS Config with your institute name, exam pattern and alert thresholds, and replace the REPLACE_WITH_… IDs. 4. Run once manually with a test batch, then activate.