# Send JEE/NEET weekly WhatsApp parent reports with OpenAI, Google Sheets and Gmail

> Quick overview This workflow runs weekly to analyze JEE/NEET student test performance from Google Sheets, uses OpenAI to draft WhatsApp reports for parents with a trend chart, alerts faculty about batch-wide weak topics by WhatsApp and Gmail, and handles parent replies (questions, callbacks, and STOP) via WhatsApp. How it works 1. Runs every Sunday at 6 PM IST to start the weekly reporting cycle. 2. Loads Students, Test Scores, Faculty, and Report Log data from Google Sheets and applies institute-specific thresholds from the built-in configuration. 3. Calculates per-student weekly performance (overall percentage, subject/topic accuracy, negative-marking loss, week-on-week change, and batch rank) and skips students who already received a report this week or have opted out. 4. Uses OpenAI (gpt-4o-mini) to generate a short parent-friendly WhatsApp message, then builds a scorecard plus a QuickChart trend image URL from recent subject percentages. 5. Sends the WhatsApp text report and trend

- **Domain**: `n8n-workflow-21071.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/21071
- Page (HTML): https://agenstry.com/agents/n8n-workflow-21071.n8n.io
- Documentation: https://n8n.io/workflows/21071