Generate Google Forms quizzes from Excel files sent via Telegram

Description

📊 Generate Google Forms Quiz from Excel via Telegram (n8n Workflow) Turn your Excel question banks into fully functional Google Forms quizzes automatically — just by sending a file via Telegram. 🚀 Overview This workflow allows users to upload an Excel file containing multiple-choice questions through Telegram. The system processes the file and automatically creates a Google Forms quiz with answer keys. Perfect for: Teachers Trainers HR teams Online course creators ⚙️ Features 📩 Upload Excel via Telegram 📊 Automatic Excel parsing 🧹 Data normalization 📝 Google Form auto creation ✅ Quiz mode with answer keys 🔁 Batch processing with rate limiting 📤 Instant delivery of form link 🧠 How It Works User sends Excel file to Telegram bot Workflow validates file type Excel data is extracted and normalized Google Form is created automatically Questions are inserted with correct answers Form link is sent back to the user 📂 Excel Format | question | option_a | option_b | option_c | option_d | answer | |----------|----------|----------|----------|----------|--------| | What is 2+2? | 3 | 4 | 5 | 6 | B | answer must be: A / B / C / D 🔧 Setup 1. Telegram Bot Create bot via BotFather Add token to n8n 2. Google API Enable: Google Forms API Google Drive API Setup OAuth2 credentials Add scopes: forms.body drive.file 3. n8n Configuration Import workflow Set credentials Activate workflow ⚠️ Notes Excel must follow the correct format Large files may require batching Google API rate limits apply 💡 Use Cases Generate exams in seconds Convert training materials to quizzes Automate assessment workflows 💰 Monetization Idea You can turn this into a SaaS by: Offering a Telegram bot service Limiting free usage (e.g. 20 questions) Charging for unlimited access 🔥 Future Improvements Multi-language support AI question validation Question randomization Section grouping by topic 👨‍💻 Built with n8n Automation made simple. An n8n automation workflow template by Ramdoni.

Categories

Tags

Capabilities

• 3 nodes
• 1 views