{"product_id":"telegram-exam-study-planner-w-gemini-google-sheets-n8n","title":"Telegram Exam Study Planner w\/ Gemini + Google Sheets (n8n)","description":"\u003ch3\u003eGenerate a real Telegram study plan with Gemini + Google Sheets (and send today’s tasks automatically)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow turns a student’s Telegram message into a structured exam study plan using \u003cb\u003eGoogle Gemini\u003c\/b\u003e, stores it in \u003cb\u003eGoogle Sheets\u003c\/b\u003e, and then replies with \u003cb\u003etoday’s actionable tasks\u003c\/b\u003e on Telegram—so learners always know exactly what to do next.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eReceives a Telegram message\u003c\/b\u003e where the student describes their exam and study constraints.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUses Google Gemini\u003c\/b\u003e to extract and normalize key exam details: \u003ci\u003esubject, exam date, chapters, and hours per day\u003c\/i\u003e, plus calculates daily hours and remaining days.\u003c\/li\u003e\n  \u003cli\u003eIf required information is missing—or if the exam date is \u003cb\u003etoday or in the past\u003c\/b\u003e—it sends a \u003cb\u003eTelegram reply\u003c\/b\u003e requesting corrected or missing details.\u003c\/li\u003e\n  \u003cli\u003eWhen details are valid, it \u003cb\u003ereads existing study plans\u003c\/b\u003e from Google Sheets to preserve the student’s prior context.\u003c\/li\u003e\n  \u003cli\u003eGemini then generates a \u003cb\u003edetailed JSON study plan\u003c\/b\u003e: block-based tasks for the \u003cb\u003efirst 7 days\u003c\/b\u003e and a roadmap for the remaining days.\u003c\/li\u003e\n  \u003cli\u003eThe workflow \u003cb\u003eappends the plan\u003c\/b\u003e to the Google Sheets \u003cb\u003e“Study Plans”\u003c\/b\u003e tab and sends a formatted \u003cb\u003e“today’s plan”\u003c\/b\u003e message to the student via Telegram.\u003c\/li\u003e\n  \u003cli\u003eEvery completed action is recorded in the Google Sheets \u003cb\u003e“Activity Log”\u003c\/b\u003e tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAn exam preparation assistant that listens on Telegram and produces a weekly study roadmap.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators building an “AI study planner” experience with persisted plans and audit logs.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers who want an end-to-end n8n flow: validation → AI planning → storage → user messaging.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eTelegram\u003c\/b\u003e (Telegram Trigger + replies)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Gemini (Google PaLM)\u003c\/b\u003e for extracting exam details and generating a JSON plan\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets\u003c\/b\u003e with a service account (tabs: \u003cb\u003eStudy Plans\u003c\/b\u003e and \u003cb\u003eActivity Log\u003c\/b\u003e)\u003c\/li\u003e\n  \u003cli\u003eAdditional nodes referenced in the workflow: \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003eaggregate\u003c\/b\u003e, \u003cb\u003esticky note\u003c\/b\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eSEO keywords:\u003c\/b\u003e n8n automation workflow, Telegram AI study planner, Google Gemini study plan, Google Sheets task logging, exam planning automation.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45876864942259,"sku":"N8N-18511","price":62.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/d4rl_2gfPLvq8xrfkdJBS_0kUTebMe.png?v=1787303456","url":"https:\/\/buyflowscripts.com\/products\/telegram-exam-study-planner-w-gemini-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}