Create realistic exam study plans via Telegram with Gemini and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 19 nodes and runs on Telegram events (message). Along the way it connects Telegram, Google Sheets and Google Gemini Chat Model.
How it runs
Trigger: On Telegram events (message).
- Set Study Details (Edit Fields (Set)): sets 2 fields: chat_id, request
- Extract Exam Details AI (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat AI; output parser: Parse Exam Details
- Calculate Remaining Days (Edit Fields (Set)): sets 7 fields: exam_date, chapters, hours_per_day…
- If: checks a condition and branches into true / false
- Request Missing Details on Telegram (Telegram): uses Telegram
- Read Plans from Sheets (Google Sheets): uses Google Sheets
- Aggregate: combines items into one
- Generate Study Plan AI (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat AI Secondary; output parser: Parse Daily Plan
- Prepare Study Plan Entry (Edit Fields (Set)): sets 11 fields: timestamp, chat_id, subject…
- Save Plan to Google Sheets (Google Sheets): append
…plus 4 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Telegram Trigger
n8n-nodes-base.telegramTrigger - Edit Fields (Set)
n8n-nodes-base.set - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - If
n8n-nodes-base.if - Telegram
n8n-nodes-base.telegram - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini
From the author
Quick overview Youtube Video: https://youtu.be/7mFGYw7qAwU This workflow uses Telegram, Google Gemini, and Google Sheets to extract exam details from a student message, generate a realistic study plan, save it for future reference, and send today’s actionable…