🔬 Convert PDF content to an MCQ question bank in Excel with Google Gemini
⚡ 408 views · 🔬 Document Extraction & Analysis
Description
🚀 Convert PDF to MCQ Question Bank in Excel with AI (Gemini)
Convert any PDF into a structured Multiple Choice Question (MCQ) bank with answer keys and explanations — fully automated using n8n and Google Gemini.
🎯 Use Case
- Teachers & Educators
- Trainers & Course Creators
- HR & Corporate Training Teams
- EdTech Builders
⚙️ Features
- Webhook-based PDF upload
- File validation (max 5MB + file existence check)
- PDF text extraction
- Automatic text chunking
- AI-generated MCQs using Google Gemini
- Clean JSON parsing
- Export to Excel (.xlsx)
- Upload to Google Drive
- Send results via Email & Telegram
🔄 Workflow Steps
- Webhook Trigger
- Validate File
- Conditional Check (Success / Failed)
- Extract Text from PDF
- Chunk Text
- Generate MCQs (Google Gemini)
- Clean JSON Output
- Convert to Excel
- Upload to Google Drive
- Send via Telegram
- Send via Email
🔌 Requirements
- n8n (self-hosted or cloud)
- Google Gemini API Key
- Google Drive credentials
- Email (SMTP / Gmail)
- Telegram Bot Token
📥 How to Use
Send POST request to webhook with form-data:
file→ PDF fileemail→ (optional)telegram_chat_id→ (optional)
📤 Output
- Excel file with MCQs
- Stored in Google Drive
- Delivered via Email / Telegram
⚠️ Notes
- Max file size: 5MB
- Works best with text-based PDFs
- AI output quality depends on input clarity
💡 Ideas for Improvement
- Difficulty level classification
- Multi-language support
- LMS export (Moodle, Google Forms)
- Bulk PDF processing
💰 Commercial Use
This workflow can be used for:
- Internal automation
- Client services
- Digital product monetization
❤️ Support
If you find this useful:
- Upvote on n8n
- Share with others
🔗 Nodes Used
Send Email, Webhook, Telegram, Google Drive, Convert to File, Extract from File
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File