Automated student answer sheet evaluation with Gemini AI and Google Workspace

Description: This workflow automates the entire student exam evaluation process using AI and Google Workspace tools — no manual correction needed!

Teachers simply submit a form with their name and a scanned copy of a student’s answer sheet. The flow then:

Uses Gemini Document Analysis to extract answers from the scanned sheet.

Passes the extracted answers to an AI Evaluation Agent, equipped with the Question Paper and Correct Answer Sheet (connected via Google Docs tools).

The AI cross-checks each student answer, counts correct and incorrect responses, and calculates the total marks.

The results are recorded in two Google Sheets:

A Summary Sheet with overall student performance (Name, Teacher, Total Marks, etc.)

A Detailed Report Sheet logging each question, correct answer, student’s answer, and correctness status.