AI-Powered Student Course Scheduler with Prerequisites & Google Sheets

This n8n workflow reads student data (ID, Name, Program, Year, CompletedCourses) from a Google Sheets 'Sheet1' tab. It leverages an OpenAI GPT agent to intelligently generate personalized Fall 2025 course schedules, selecting exactly 5 courses that total 15-17 credits. The AI strictly enforces catalog rules: only Fall or Both-term courses, AND prerequisites (e.g., CS-102|CS-103 requires both), prioritizes Major Core > Major Elective > Gen Ed, avoids duplicates or completed courses, and prefers 200-level progression.

The generated schedule (StudentID + course list) is appended to a 'schedule' tab in the same spreadsheet. Triggered manually, it's ideal for education admins, registrars, or advisors prototyping degree planning. Benefits include massive time savings on manual scheduling, error-free prerequisite compliance, and scalable handling of multiple students via batch processing.

Use cases: University advising offices for term planning, online course platforms for enrollment automation, or high school counselors simulating college loads. Setup requires only Google Sheets OAuth2 credentials and OpenAI API key, with nodes for reading rows, AI prompting, and appending outputs. No coding needed—fully configurable prompts ensure adaptability to any course catalog.