Skip to main content

Generate Google Forms quizzes from Excel files sent via Telegram

Workflow preview

Generate Google Forms quizzes from Excel files sent via Telegram preview
Open on n8n.io

Overview

πŸ“Š 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

  1. User sends Excel file to Telegram bot
  2. Workflow validates file type
  3. Excel data is extracted and normalized
  4. Google Form is created automatically
  5. Questions are inserted with correct answers
  6. 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.