Evaluate OMR answer sheets with Gemini vision AI and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 8 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Ollama and Google Sheets.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Analyze image (Ollama): work with image
- Set Your Correct Answer (Edit Fields (Set)): sets 1 field: CorrectAnswer
- Convert User Ans in Formate (Code): runs custom JavaScript code
- Merge: merges the data from its input branches
- Calculate Result (Code): runs custom JavaScript code
- Append Result in Sheet (Google Sheets): append
- Send Result Respond (Respond to Webhook): sends the response back to the webhook caller
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Ollama
@n8n/n8n-nodes-langchain.ollama - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - Respond to Webhook
n8n-nodes-base.respondToWebhook - Edit Fields (Set)
n8n-nodes-base.set - Webhook
n8n-nodes-base.webhook - Google Sheets
n8n-nodes-base.googleSheets
From the author
✅ What problem does this workflow solve? Manual checking of OMR (Optical Mark Recognition) answer sheets is time-consuming, error-prone, and difficult to scale—especially for schools, coaching institutes, and exam centers. This workflow automates OMR…