AI-Powered Lesson Planning with Google Sheets & Telegram

Transform Your IT Instruction with AI-Powered Lesson Planning Automation

TutorOps revolutionizes technical education by automatically generating structured lesson plans for IT instructors using AI and seamless Google Sheets integration. This powerful n8n workflow eliminates manual lesson preparation, letting educators focus on teaching while AI handles the planning logistics.

What This Workflow Does

This intelligent automation streamlines lesson planning through a systematic 6-step process:

• Monitors Google Sheets for pending lesson requests marked with "Pendente" status
• Extracts lesson requirements including topic, duration, skill level, and learning objectives
• Sends structured data to a local Ollama AI model for intelligent content generation
• Generates comprehensive lesson plans in Brazilian Portuguese tailored for technical IT classes
• Updates the original spreadsheet row with generated materials and new status
• Delivers instant Telegram notifications when lesson plans are ready for review

Key Use Cases

Perfect for IT training organizations and technical instructors who need to:

• Generate consistent, structured lesson plans for networking, infrastructure, and IT support courses
• Standardize practical class preparation across multiple instructors
• Maintain centralized documentation of all teaching activities in Google Sheets
• Scale lesson planning operations without increasing manual workload
• Reduce lesson preparation time while maintaining educational quality

Technical Requirements

This workflow leverages cutting-edge automation technology including:

• Google Sheets integration for lesson request management and output storage
• Telegram Bot for instant notification delivery
• Local Ollama AI model (recommended: llama3.2:3b) for cost-effective content generation
• LangChain Agent nodes for intelligent AI processing
• Manual trigger system for instructor-controlled workflow execution

Requires an active n8n instance with Google Sheets and Telegram Bot credentials configured. The workflow uses local AI processing through Ollama, eliminating recurring cloud AI costs while maintaining data privacy.