Generate student course schedules based on prerequisites with GPT and Google Sheets

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, advisors, degree-planning prototypes

---

✅ What this template does - Reads: StudentID, Name, Program, Year, CompletedCourses (pipe-separated CourseIDs) from Sheet1 - Decides: AI Scheduling Agent chooses 5 courses per student following catalog rules and prerequisites - Writes: Appends StudentID + Schedule strings to schedule worksheet - Credits target: 15–17 total per term - Catalog rules (enforced in the agent prompt): - Use Fall or Both courses for Fall 2025 - Enforce AND prereqs (e.g., CS-102|CS-103 means both) - Priority: Major Core → Major Elective → Gen Ed (include Gen Ed if needed) - No duplicates or already-completed courses - Prefer 200-level progression when prereqs allow

---

⚙️ Setup (only 2 steps)

1) Connect Google Sheets (OAuth2) - In n8n → Credentials → New → Google Sheets (OAuth2), sign in and grant access - In the Google Sheets nodes, select your spreadsheet and these tabs: - Sheet1 (input students) - schedule (output)