AI-Powered Exam Grading with Vector Search

# Automated exam grading and Q&A using documents from Google Drive

This workflow automates the processing of educational and exam materials stored in Google Drive and provides AI-powered evaluation of student answers based on official mark schemes. Ideal for educators, edtech platforms, and developers building RAG systems or AI assistants.

## Who it´s for
- Teachers looking to automate grading of exam responses.
- Educational platforms needing scalable student answer evaluation.
- Companies building knowledge search and analysis systems from cloud-stored documents.
- Developers creating agents with access to vector databases.
- Academic institutions integrating AI feedback into learning workflows.

## What the automation does
- Monitors a Google Drive folder for newly uploaded PDF/TXT files.
- Extracts text, splits it into context-aware chunks, and generates embeddings via OpenAI.
- Stores vector representations in Supabase for fast retrieval.
- On manual trigger, accepts user questions processed by an AI agent using hybrid search (vector + keyword).
- Generates answers using Google Gemini with context from the knowledge base.
- Evaluates student exam answers against pre-loaded official grading criteria.

## What´s included
- Ready-to-use n8n workflow with LangChain and Supabase support.
- Trigger logic: file creation in Google Drive and manual execution.
- Integrations with Google Drive, Supabase, OpenAI, Google Gemini, and HTTP API.
- Basic setup and adaptation guide.

## Requirements for setup
- n8n instance with external API access.
- Active Google account with Drive API enabled.
- Supabase project with vector-enabled table.
- API keys from OpenAI and Google Gemini.
- Access to HTTP API for internal component communication.

## Benefits and outcomes
- Reduces exam grading time to seconds per response.
- Unified knowledge base that auto-updates when new documents are added.
- Accurate information retrieval from large texts without manual scanning.
- Objective assessment of student answers based on fixed criteria.
- Scalability: one template handles hundreds of documents and queries.
- Flexible architecture—easily adaptable to other evaluation tasks.

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat