{"product_id":"telegram-school-admin-bot-with-deepseek-google-sheets-n8n-workflow","title":"Telegram School Admin Bot with DeepSeek \u0026 Google Sheets (n8n Workflow)","description":"\u003ch3\u003eRun school administration from one Telegram chat—automatically.\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eTelegram School Admin Bot with DeepSeek \u0026amp; Google Sheets (n8n Workflow)\u003c\/strong\u003e turns teacher absence reporting and principal announcements into a fully logged, approval-based automation. From quick cover assignment to AI-written bilingual circulars (English + Hindi) approved in Telegram and emailed to parents—everything is tracked in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives requests\u003c\/strong\u003e either when a \u003cstrong\u003eTelegram message\u003c\/strong\u003e arrives or daily at \u003cstrong\u003e8:00 AM\u003c\/strong\u003e via an n8n schedule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIdentifies the sender\u003c\/strong\u003e by looking up the Telegram chat ID in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (Users and Teachers). If unknown, it sends a \u003cstrong\u003eregistration message\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses DeepSeek\u003c\/strong\u003e to extract the request intent and key details from Telegram (absence vs. announcement), then routes the workflow accordingly.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAbsence handling:\u003c\/strong\u003e reads the \u003cstrong\u003eTimetable\u003c\/strong\u003e and existing \u003cstrong\u003eSubstitutions\u003c\/strong\u003e from Google Sheets, ranks available teachers, and sends \u003cstrong\u003eTelegram approval prompts\u003c\/strong\u003e to top candidates per period; escalates to the principal when no one accepts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs coverage outcomes\u003c\/strong\u003e in the \u003cstrong\u003eSubstitutions\u003c\/strong\u003e sheet and sends a consolidated \u003cstrong\u003ecover-plan summary\u003c\/strong\u003e to both requester and principal in Telegram.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAnnouncement handling (Principal\/Admin only):\u003c\/strong\u003e DeepSeek drafts \u003cstrong\u003eEnglish and Hindi circulars\u003c\/strong\u003e, requests Telegram approval, then emails matching parents via \u003cstrong\u003eGmail\u003c\/strong\u003e using addresses from the \u003cstrong\u003eStudents\u003c\/strong\u003e sheet and logs sends to the \u003cstrong\u003eCirculars\u003c\/strong\u003e sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily 8 AM briefing:\u003c\/strong\u003e provides the principal a summary of \u003cstrong\u003eattendance, fees, and substitutions\u003c\/strong\u003e from Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTeachers report absences instantly; bot coordinates teacher cover approvals per period.\u003c\/li\u003e\n  \u003cli\u003ePrincipal requests AI-assisted bilingual announcements, approves them in Telegram, and sends them to parents via Gmail.\u003c\/li\u003e\n  \u003cli\u003eAdmin gets a daily 8 AM operational briefing backed by Google Sheets logs.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Telegram, DeepSeek, Google Sheets, Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003eswitch\u003c\/code\u003e, \u003ccode\u003etelegram\u003c\/code\u003e, \u003ccode\u003egmail\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46288989978803,"sku":"N8N-21680","price":73.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/6Pj0RhJhpqq3M3PPj9lST_POkvmdFM.png?v=1793005723","url":"https:\/\/buyflowscripts.com\/products\/telegram-school-admin-bot-with-deepseek-google-sheets-n8n-workflow","provider":"N8N Commerce","version":"1.0","type":"link"}