{"product_id":"jee-neet-weekly-whatsapp-reports-n8n-openai-google-sheets","title":"JEE NEET Weekly WhatsApp Reports n8n: OpenAI, Google Sheets","description":"\u003ch3\u003eWeekly JEE\/NEET Performance WhatsApp Reports with OpenAI + Google Sheets (n8n)\u003c\/h3\u003e\n\u003cp\u003eTurn your institute’s weekly JEE\/NEET test analysis into automated parent-friendly WhatsApp reports. This n8n workflow reads student results from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, uses \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e to draft messages and remedial plans, sends scorecards with a trend chart, alerts faculty on weak batch topics via \u003cstrong\u003eWhatsApp and Gmail\u003c\/strong\u003e, and handles parent replies—including \u003cstrong\u003equestions\u003c\/strong\u003e, \u003cstrong\u003ecallbacks\u003c\/strong\u003e, and \u003cstrong\u003eSTOP\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly\u003c\/strong\u003e every Sunday at \u003cstrong\u003e6 PM IST\u003c\/strong\u003e to start the reporting cycle.\u003c\/li\u003e\n  \u003cli\u003eLoads \u003cstrong\u003eStudents\u003c\/strong\u003e, \u003cstrong\u003eTest Scores\u003c\/strong\u003e, \u003cstrong\u003eFaculty\u003c\/strong\u003e, and \u003cstrong\u003eReport Log\u003c\/strong\u003e from Google Sheets, applying institute-specific \u003cstrong\u003ethresholds\u003c\/strong\u003e from the built-in configuration.\u003c\/li\u003e\n  \u003cli\u003eCalculates per-student weekly performance, including \u003cstrong\u003eoverall percentage\u003c\/strong\u003e, \u003cstrong\u003esubject\/topic accuracy\u003c\/strong\u003e, \u003cstrong\u003enegative-marking loss\u003c\/strong\u003e, \u003cstrong\u003eweek-on-week change\u003c\/strong\u003e, and \u003cstrong\u003ebatch rank\u003c\/strong\u003e. It skips students who already received a report for the week or opted out.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e to generate a \u003cstrong\u003eshort WhatsApp message\u003c\/strong\u003e for parents, then creates a \u003cstrong\u003escorecard\u003c\/strong\u003e plus a \u003cstrong\u003eQuickChart\u003c\/strong\u003e trend image URL based on recent subject percentages.\u003c\/li\u003e\n  \u003cli\u003eSends the WhatsApp text + trend chart image to each parent and logs the event back to the \u003cstrong\u003eGoogle Sheets Report Log\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIdentifies \u003cstrong\u003ebatch-level weak topics\u003c\/strong\u003e, generates a remedial plan with OpenAI, alerts faculty via \u003cstrong\u003eWhatsApp and Gmail\u003c\/strong\u003e, logs alerts in the \u003cstrong\u003eWeak Topics\u003c\/strong\u003e sheet, and sends a weekly summary to the academic head via WhatsApp.\u003c\/li\u003e\n  \u003cli\u003eAutomatically processes \u003cstrong\u003eincoming WhatsApp replies\u003c\/strong\u003e: matches the parent number to the student and latest logged report, uses OpenAI to classify intent, then responds accordingly (including honoring \u003cstrong\u003eSTOP\u003c\/strong\u003e).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAcademies and coaching centers sending weekly JEE\/NEET progress updates without manual effort.\u003c\/li\u003e\n  \u003cli\u003en8n operators automating WhatsApp communications tied to Google Sheets test analytics.\u003c\/li\u003e\n  \u003cli\u003eInstitutes needing faculty alerts for weak batch topics with a generated remedial plan.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/tools:\u003c\/strong\u003e Code, Gmail, Switch, WhatsApp, Sticky Note, Google Sheets\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI:\u003c\/strong\u003e OpenAI (gpt-4o-mini) for parent message drafting, weak-topic remedial plan creation, and reply intent classification\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCharting:\u003c\/strong\u003e QuickChart trend image URLs\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46232378441907,"sku":"N8N-21071","price":75.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/nwPy79LXUyVAnGZf3bBc-_iEX5PUHW.png?v=1792141491","url":"https:\/\/buyflowscripts.com\/products\/jee-neet-weekly-whatsapp-reports-n8n-openai-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}