{"product_id":"n8n-weekly-student-risk-tracker-sheets-gpt-4o-slack-telegram","title":"n8n Weekly Student Risk Tracker: Sheets + GPT-4o + Slack\/Telegram","description":"\u003ch3\u003eWeekly student risk check—powered by Google Sheets, GPT-4o, and Slack\/Telegram\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically reviews weekly student performance in Google Sheets, calculates a risk index and trend, generates personalized encouragement for \u003cstrong\u003eHIGH-risk\u003c\/strong\u003e students using \u003cstrong\u003eOpenAI (GPT-4o mini)\u003c\/strong\u003e, and delivers a teacher digest to \u003cstrong\u003eSlack\u003c\/strong\u003e and \u003cstrong\u003eTelegram\u003c\/strong\u003e, while logging snapshots back into Sheets for history.\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 on a schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads student records\u003c\/strong\u003e from the Google Sheets worksheet named \u003cstrong\u003e“Student Data”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComputes metrics\u003c\/strong\u003e per student: attendance, assignment completion, average test score, a \u003cstrong\u003erisk index\u003c\/strong\u003e, a \u003cstrong\u003erisk level\u003c\/strong\u003e (HIGH\/MEDIUM\/LOW), and a \u003cstrong\u003eweek-to-week score trend\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates nudges for HIGH-risk students\u003c\/strong\u003e using OpenAI (GPT-4o mini). The workflow produces a short, encouraging \u003cem\u003eWhatsApp-style\u003c\/em\u003e message and emails it via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a weekly digest\u003c\/strong\u003e for \u003cstrong\u003eHIGH and MEDIUM\u003c\/strong\u003e risk students and posts it to both a \u003cstrong\u003eSlack\u003c\/strong\u003e channel and a \u003cstrong\u003eTelegram\u003c\/strong\u003e chat.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs historical tracking\u003c\/strong\u003e by appending a dated snapshot of each student’s metrics and risk label to \u003cstrong\u003e“Log Trend”\u003c\/strong\u003e in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles failures\u003c\/strong\u003e: if the workflow fails, an error trigger posts a basic alert message to \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSchools or tutoring teams monitoring student performance without manual weekly reporting.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators building internal education analytics and automated student support.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers deploying a reliable Google Sheets → risk scoring → messaging pipeline in n8n.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/nodes used\u003c\/strong\u003e: \u003cstrong\u003eCode\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e, \u003cstrong\u003eSlack\u003c\/strong\u003e, \u003cstrong\u003eTelegram\u003c\/strong\u003e, \u003cstrong\u003eError Trigger\u003c\/strong\u003e, and a scheduling trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI step\u003c\/strong\u003e: OpenAI node using \u003cstrong\u003eGPT-4o mini\u003c\/strong\u003e to generate personalized nudge messages.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfiguration\u003c\/strong\u003e: update spreadsheet ID and the worksheet names\/IDs for \u003cstrong\u003e“Student Data”\u003c\/strong\u003e and \u003cstrong\u003e“Log Trend”\u003c\/strong\u003e, set Gmail recipients, and adjust the GPT prompt tone if needed.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45872820519091,"sku":"N8N-18476","price":38.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/zuGkFhx6rJKaVBtgBw_iQ_0GUB69Rb.png?v=1787217009","url":"https:\/\/buyflowscripts.com\/products\/n8n-weekly-student-risk-tracker-sheets-gpt-4o-slack-telegram","provider":"N8N Commerce","version":"1.0","type":"link"}