AI-Powered Degree Audit System with Google Sheets & GPT-5

This workflow performs AI-powered degree audits for senior students listed in a Google Sheets 'Senior_data' sheet. It reads rows containing StudentID, Name, Program, Year, and CompletedCourses, then uses an OpenAI Chat Model (GPT-5 compatible) to evaluate progress against hard-coded requirements for 10 programs including Computer Science BS, Business Administration BBA, Psychology BA, and others. The AI generates a concise summary of missing items like major core courses, Gen Eds, electives, and upper-division credits.

Benefits include rapid, consistent audits for registrars and advisors, reducing manual review time from hours to minutes. It supports student success teams prototyping dashboards and EdTech builders testing AI-assisted SIS features. Triggered manually, it processes each student row, computes missing requirements, and appends or updates the sheet with an 'AI Degree Summary' column, optionally mapping raw 'Missing' arrays.

Use cases: University registrars auditing seniors pre-graduation; advisors providing quick feedback; prototype development for AI-enhanced student information systems. Example output flags specifics like 'GEN-REMAIN | 6 credits' or 'CS-EL-REM | 6 credits', enabling targeted advising.