Generate Student Course Schedules Based on Prerequisites with GPT and Google Sheets

About

Create a Fall 2025 course schedule for each student based on what they’ve already completed, catalog prerequisites, and term availability (Fall/Both). Reads students from Google Sheets → asks an AI agent to select exactly 5 courses (target 15–17 credits, no duplicates, prereqs enforced) → appends each student’s schedule to a schedule tab. 🧠 Summary Trigger:* Manual — *“When clicking ‘Execute workflow’” I/O:** Google Sheets in → OpenAI decisioning → Google Sheets out Ideal for:** Registrars, ad