AI powered auto generate exam questions and answers from Google
This workflow automates the creation of exam questions (both open-ended and multiple-choice) from educational content stored in Google Docs, using AI-powered...
🔌 Nodes & Integrations Used (12)
📖 Implementation & Setup Guide
This workflow automates the creation of **exam questions** (***both open-ended and multiple-choice***) from educational content stored in **Google Docs**, using **AI-powered analysis** and vector database retrieval
This workflow **saves educators hours of manual work** while ensuring high-quality, curriculum-aligned assessments. Let me know if you'd like help adapting it for specific subjects!
---
**Use Cases** - **Educators**: Rapidly generate quizzes, midterms, or flashcards. - **E-learning platforms**: Automate question banks for courses. - **Corporate training**: Create assessments for employee onboarding.
**Technical Requirements**: - **APIs**: Google Gemini, OpenAI, Qdrant, Google Workspace. - **n8n Nodes**: LangChain, Google Sheets/Docs, HTTP requests, code blocks.
This workflow **combines AI efficiency with human-curated quality**, making it a powerful tool for modern education and training.
---
**Advantages of This Workflow**
* ✅ **Fully Automated Exam Generation**: From document to fully formatted quiz content with no manual intervention. * ✅ **Supports Comprehension and Critical Thinking**: Questions are designed to go beyond factual recall, including inference and application. * ✅ **Uses AI and RAG for Accuracy**: Ensures that answers are grounded in the document content, reducing hallucination. * ✅ **Seamless Google Integration**: Pulls content from Google Docs and writes outputs to Google Sheets. * ✅ **Scalable for Any Subject**: Works with any article or content domain as input. * ✅ **Modular and Customizable**: Can be easily adapted to generate different question types or to use other LLMs or storage systems.
---
**How It Works** 1. **Document Ingestion**: - The workflow starts by fetching an educational document (e.g., textbook chapter, lecture notes) from **Google Docs**. - Converts the document to **Markdown** for structured processing.
2. **AI Processing**: - Splits text into chunks and generates **vector embeddings** (via OpenAI) for semantic analysis. - Stores embeddings in **Qdrant** (vector database) for retrieval.
3. **Question Generation**: - **Open-ended questions**: Google Gemini AI creates 10 critical-thinking questions. - **Multiple-choice questions**: Generates 10 MCQs (1 correct + 3 plausible distractors) using **RAG** to validate answers against the vector DB.
4. **Answer Validation**: - For open questions: Retrieves context-aware answers from the vector store. - For MCQs: Ensures distractors are incorrect but believable via AI cross-checking.
5. **Output**: - Saves questions/answers to **Google Sheets** in two tabs: - `Open questions`: Question + AI-generated answer. - `Closed questions`: MCQ + options + correct answer.
---
**Set Up Steps** 1. **Prerequisites**: - **APIs/Accounts**: - Google Workspace (Docs + Sheets). - OpenAI (for embeddings). - Google Gemini (for question generation). - Qdrant (vector DB – self-hosted or cloud). - **n8n Nodes**: Ensure LangChain, Google Sheets/Docs, and HTTP request nodes are installed.
2. **Configure Connections**: - Link credentials for: - **Google Docs/Sheets** (OAuth2). - **OpenAI** (API key). - **Google Gemini** (API key). - **Qdrant** (URL + API key).
3. **Customize Input**: - Replace the default **Google Doc ID** in the "Get Doc" node with your source document. - Adjust **chunk size/overlap** (Token Splitter node) for optimal text processing.
4. **Tweak Question Generation**: - Modify prompts in: - **"Open questions" node**: Adjust criteria (e.g., difficulty, question types). - **"Closed questions" node**: Edit MCQ formatting rules.
5. **Output Settings**: - Update the **Google Sheet ID** in "Write open" and "Write closed" nodes. - Map columns in Google Sheets to match question/answer formats.
6. **Run & Automate**: - Trigger manually ("Test workflow") or schedule periodic runs (e.g., for updated content).
---
**Need help customizing?** [Contact me](mailto:info@n3w.it) for consulting and support or add me on [Linkedin](https://www.linkedin.com/in/davideboizza/).
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
AI_powered_auto_generate_exam_questions_and_answers_from_Google.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related AI Agents Workflows
View All in AI Agents →5 ways to process images PDFs with Gemini AI in n8n
How it works Many users have asked in the support forum about different methods to analyze images and PDF documents with Google Gemini AI in n8n. This workfl...
7 AI Sales Assistant
Production-ready n8n automation template for 7 AI Sales Assistant built by AhiXLight. Seamlessly connects Airtop Tool, Slack, Airtop with 24 configured nodes.
AAVE portfolio professional AI agent Telegram Email GPT 4o
A next-generation AI-powered DeFi health monitor that tracks wallet positions across Aave V3 using GPT-4o and LangChain. It delivers human-readable reports v...
Access control for AI agents RBAC using Airtable and Telegram
Purpose This workflow allows granular control over the access to tools connected to AI Agents (including Multi-Agent setups) using Role Based Access Control....