Generate Student Course Schedules Based on Prerequisites with GPT and Google Sheets — n8n Workflow
Overview
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, adv
Nodes used
Workflow Preview
How it Works
- 1
Trigger
The workflow starts with a trigger trigger.
- 2
Process
Data flows through 9 nodes, connecting agent, googlesheets, lmchatopenai.
- 3
Output
The workflow completes its automation and delivers the result to the configured destination.
Node Details (9)
Google Sheets
googleSheets
AI Agent
n8n-nodes-langchain.agent
OpenAI Chat Model
n8n-nodes-langchain.lmChatOpenAi
Structured Output Parser
n8n-nodes-langchain.outputParserStructured
How to Import This Workflow
- 1Click Download JSON button on the right to save the workflow file.
- 2Open your n8n instance. Go to Workflows → New → Import from file.
- 3Select the downloaded
generate-student-course-schedules-based-on-prerequisites-with-gpt-and-google-sheetsfile and click Import. - 4Set up credentials for each service node (API keys, OAuth, etc.).
- 5Click Test Workflow to verify everything works, then activate it.
Or paste directly in n8n → Import from JSON:
Integrations
Created by
Robert Breen
@rbreen
Tags
New to n8n?
n8n is a free, open-source workflow automation tool. Self-host it or use the cloud version.
Get n8n Free →