AI-Powered Degree Audit System with Google Sheets & GPT

This n8n workflow enables registrars and advisors to perform fast, AI-powered degree audits for senior students. It reads student data—including StudentID, Name, Program, Year, and CompletedCourses—from a Google Sheets tab named 'Senior_data'. An OpenAI Chat Model (GPT-5 compatible) then acts as an intelligent agent, comparing completed courses to hard-coded requirements for 10 popular programs like Computer Science BS, Business Administration BBA, Psychology BA, and Nursing BSN. The AI generates a concise 'AI Degree Summary' highlighting missing major core courses, Gen Eds, electives, upper-division credits, and more.

The workflow triggers manually via 'Execute workflow' and processes each student row individually. It leverages structured prompts to ensure consistent outputs, optionally parsing them with a Structured Output Parser for clean JSON like {'Missing': ['GEN-REMAIN | 6 credits', 'CS-EL-REM | 6 credits']}. Results are written back to the same sheet using 'Append or update' by StudentID, populating columns for the summary and raw missing array—ideal for quick reviews or dashboard prototypes.

Benefits include massive time savings (manual audits take hours per student; this is seconds), consistency across advisors, and scalability for hundreds of students. Use cases span university registrars needing bulk checks, student success teams prototyping SIS features, and EdTech builders testing AI-assisted auditing. It's customizable: tweak requirements, add programs, or integrate with SIS APIs for production use.

Programs supported: Computer Science BS, Business Administration BBA, Psychology BA, Mechanical Engineering BS, Biology BS (Pre-Med), English Literature BA, Data Science BS, Nursing BSN, Economics BA, Graphic Design BFA.