Convert PDF content to an MCQ question bank in Excel with Google Gemini

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 file
email → (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