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

Medium complexity⚡ Trigger9 nodes🏷️ Project Management👁 14 viewsby Robert Breen

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

Google SheetsAI AgentOpenAI Chat ModelStructured Output Parser

Workflow Preview

3) Connect OpenAI (API Key)
1. In n8n → Credentials → New → OpenAI API
2. Paste your OpenAI API key
3. In OpenAI Chat Model, select your credential and a v
1) Connect Google Sheets (OAuth2)
1. In n8n → Credentials → New → Google Sheets (OAuth2)
2. Sign in with your Google account and grant access
3. In each Google Sheets node, select your S
🎓 AI Course Scheduler from Completed Prereqs
Create a Fall 2025 course schedule for each student bas
⚙️ Setup (only 2 steps)
1) Connect Google Sheets (OAuth2)
- In n8n → Credentials → New → Google Sheets (OAuth2),
- In the Google Sheets nodes, select your spre
modelparser
⚡
W
When clicking ‘Execute w…
OpenAI Chat Model2
Structured Output Parser
Scheduling Agent
S
Set Fields
Clear sheet1
Get Student Data
S
Split Schedule
Append Schedule
9 nodes8 edges

How it Works

  1. 1

    Trigger

    The workflow starts with a trigger trigger.

  2. 2

    Process

    Data flows through 9 nodes, connecting agent, googlesheets, lmchatopenai.

  3. 3

    Output

    The workflow completes its automation and delivers the result to the configured destination.

Node Details (9)

GO

Google Sheets

googleSheets

#1
AI

AI Agent

n8n-nodes-langchain.agent

#2
OP

OpenAI Chat Model

n8n-nodes-langchain.lmChatOpenAi

#3
ST

Structured Output Parser

n8n-nodes-langchain.outputParserStructured

#4

How to Import This Workflow

  1. 1Click Download JSON button on the right to save the workflow file.
  2. 2Open your n8n instance. Go to Workflows → New → Import from file.
  3. 3Select the downloaded generate-student-course-schedules-based-on-prerequisites-with-gpt-and-google-sheets file and click Import.
  4. 4Set up credentials for each service node (API keys, OAuth, etc.).
  5. 5Click Test Workflow to verify everything works, then activate it.

Or paste directly in n8n → Import from JSON:

{ "name": "Generate Student Course Schedules Based on Prerequisites with GPT and Google Sheets", "nodes": [...], ...}

Integrations

agentgooglesheetslmchatopenaimanualtriggeroutputparserstructuredsetsplitout

Get This Workflow

Download and import in one click

Download JSONView on n8n.io
Nodes9
Complexitymedium
Triggertrigger
Views14
CategoryProject Management

Created by

Robert Breen

Robert Breen

@rbreen

Tags

agentgooglesheetslmchatopenaimanualtriggeroutputparserstructuredsetsplitout
⚡

New to n8n?

n8n is a free, open-source workflow automation tool. Self-host it or use the cloud version.

Get n8n Free →