# OMR Answer Sheet Auto-Grader

**Category:** Education  
**Tools:** Code, n8n, Google Sheets  
**Nodes:** 9  
**Built by:** Forgent Systems

Upload a photo of an OMR sheet and get the score back instantly. AI vision reads the marked answers, they're compared with the answer key, and the result is saved to Google Sheets.

![Workflow](preview.webp)

## How it works

1. An image is posted to the webhook.
2. AI vision reads the student's marked answers.
3. The answers are merged with the correct answer key and the score is calculated.
4. The result is returned and appended to the sheet.

## Use cases

- Schools and coaching centers
- Mock tests and entrance prep
- Internal assessments

## Data setup

**Google Sheets** (tab: columns)

- **Students Result → Sheet1**: `Student Name`, `Roll No`, `Class`, `Q.1`, `Q.2`, `Q.3`, `Q.4`, `Q.5`, `Q.6`, `Q.7`, `Q.8`, `Q.9`, `Q.10`, `Q.11`, `Q.12`, `Q.13`, `Q.14`, `Q.15`, `Q.16`, `Q.17`, `Q.18`, `Q.19`, `Q.20`, `Correct`, `Incorrect`, `Score Percentage`

## Setup

1. In n8n open **Workflows → Import from File** and choose `workflow.json`.
2. Connect these credentials:
   - Google Sheets account
   - Ollama account
3. Point the Sheets / Airtable / Drive / Slack nodes at your own resources (structure above).
4. Replace placeholder emails, phone numbers and `YOUR-FORM-ID` links with your own.
5. Times use the America/New_York timezone and dates use MM/DD/YYYY. Adjust if needed.
6. Run a test execution, then activate.

## Nodes

- **Analyze image** — `@n8n/n8n-nodes-langchain.ollama`
- **Merge Answer** — `n8n-nodes-base.merge`
- **Calculate Result** — `n8n-nodes-base.code`
- **Send Result Respond** — `n8n-nodes-base.respondToWebhook`
- **Convert User Ans in Format** — `n8n-nodes-base.code`
- **Set Your Correct Answer** — `n8n-nodes-base.set`
- **Send Student Ans Img** — `n8n-nodes-base.webhook`
- **Append Result in Sheet** — `n8n-nodes-base.googleSheets`
- **Sticky Note** — `n8n-nodes-base.stickyNote`
