{
  "name": "Evaluate OMR answer sheets with Gemini vision AI and Google Sheets",
  "nodes": [
    {
      "id": "6fc105e9-70fb-4b39-94aa-443c6ce55dfe",
      "name": "Analyze image",
      "type": "@n8n/n8n-nodes-langchain.ollama",
      "position": [
        960,
        1936
      ]
    },
    {
      "id": "e98c50f8-98e3-4b94-951c-40a94197cd6b",
      "name": "Merge Answer",
      "type": "n8n-nodes-base.merge",
      "position": [
        1408,
        1888
      ]
    },
    {
      "id": "0d328c98-9fe6-487e-bbb1-cca7a93539dc",
      "name": "Calculate Result",
      "type": "n8n-nodes-base.code",
      "position": [
        1616,
        1856
      ]
    },
    {
      "id": "78f5bed1-1583-4429-ae5b-960be1d44795",
      "name": "Send Result Respond",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        2016,
        1856
      ]
    },
    {
      "id": "21acd37d-0f9b-4475-96a5-794a7497d4e4",
      "name": "Convert User Ans in Formate",
      "type": "n8n-nodes-base.code",
      "position": [
        1216,
        1968
      ]
    },
    {
      "id": "d4f4b88d-30c3-4355-a404-b9000db1d2ea",
      "name": "Set Your Correct Answer",
      "type": "n8n-nodes-base.set",
      "position": [
        1216,
        1824
      ]
    },
    {
      "id": "0bd1adb7-3475-4251-b343-79b2608d800f",
      "name": "Send Student Ans Img",
      "type": "n8n-nodes-base.webhook",
      "position": [
        640,
        1856
      ]
    },
    {
      "id": "52442ffc-824d-432b-aaad-80eab9257104",
      "name": "Append Result in Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1824,
        1856
      ]
    },
    {
      "id": "37946fab-f3c4-41d5-ab75-64570b720429",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        576,
        2128
      ],
      "parameters": {
        "width": 416,
        "height": 256,
        "content": "## Google Sheet\nhttps://docs.google.com/spreadsheets/d/15nvRI8zcJ2n-QBXNk9xyd1GM8Vj7_1lJ3K7vO7Qfq3w/edit?usp=sharing\n\n\n## Webhook Payload :\nForm-Data\nkey-name : file\nValue : Upload Img"
      }
    },
    {
      "id": "a81c3963-b846-440c-90e2-c13bd394713a",
      "name": "Workflow Overview",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        144,
        1696
      ],
      "parameters": {
        "width": 420,
        "height": 528,
        "content": "## How it works\nThis workflow automates OMR (Optical Mark Recognition) answer sheet evaluation. Upload a student's answer sheet image via webhook, and AI analyzes the marked bubbles to extract answers"
      }
    },
    {
      "id": "4ab41919-537e-40a3-b051-e0bbe3a19b65",
      "name": "Input Section",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        576,
        1696
      ],
      "parameters": {
        "width": 264,
        "height": 412,
        "content": "## Input Section\nReceives OMR sheet image via webhook and sets up correct answer key for comparison."
      }
    },
    {
      "id": "b13f3985-fec0-41e0-95fa-5fa7501fcbb1",
      "name": "AI Processing",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        848,
        1696
      ],
      "parameters": {
        "width": 280,
        "height": 412,
        "content": "## AI Processing\nGemini AI analyzes the image to extract student details and marked answers from bubbles."
      }
    },
    {
      "id": "c75ce701-c5ac-441d-a9e2-2d3d2d29e284",
      "name": "Answer Comparison",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1136,
        1696
      ],
      "parameters": {
        "width": 408,
        "height": 412,
        "content": "## Answer Comparison\n\nMerges student answers with correct answers, then calculates score and generates detailed results."
      }
    },
    {
      "id": "2622777b-a6b4-41c9-a33f-58fbaa7707a0",
      "name": "Output Section",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1552,
        1696
      ],
      "parameters": {
        "width": 644,
        "height": 412,
        "content": "## Output Section\nSaves results to Google Sheets and returns JSON response with complete evaluation data."
      }
    }
  ],
  "connections": {
    "Merge Answer": {
      "main": [
        [
          {
            "node": "Calculate Result",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Analyze image": {
      "main": [
        [
          {
            "node": "Convert User Ans in Formate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Calculate Result": {
      "main": [
        [
          {
            "node": "Append Result in Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Student Ans Img": {
      "main": [
        [
          {
            "node": "Analyze image",
            "type": "main",
            "index": 0
          },
          {
            "node": "Set Your Correct Answer",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append Result in Sheet": {
      "main": [
        [
          {
            "node": "Send Result Respond",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Your Correct Answer": {
      "main": [
        [
          {
            "node": "Merge Answer",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert User Ans in Formate": {
      "main": [
        [
          {
            "node": "Merge Answer",
            "type": "main",
            "index": 1
          }
        ]
      ]
    }
  }
}