Quick overview
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 tasks back to the student. How it works Receives a Telegram message from a student describing their exam and study constraints. Uses Google Gemini to extract structured exam details (subject, exam date, chapters, and hours per day) and normalizes the daily hours and days remaining. If required details are missing or the exam date is today/past, sends a Telegram reply asking the student for the missing or corrected information. If details are valid, reads existing study plans from Google Sheets to provide the student’s previous context. Uses Google Gemini to generate a detailed JSON study plan with block-based tasks for the first 7 days and a roadmap for the remaining days. Appends the generated plan to a Google Sheets “Study Plans” tab and sends a formatted “today’s plan” message to the student on Telegram. Logs the completed action to a Google Sheets “Activity Log” tab. Setup Connect Telegram credentials and start a Telegram bot, then message the bot so the Telegram Trigger can receive updates. Add a Google Gemini (Google PaLM) API credential for both AI steps. Create a Google Sheets service account credential and share your target spreadsheet with the service account email. Replace the placeholder Google Sheet ID and ensure the spreadsheet contains tabs named “Study Plans” and “Activity Log” with columns that match the appended fields. An n8n automation workflow template by iamvaar.
iamvaar
web
free
Others in the same category, ranked by how often they are opened.
