Generate Student Course Schedules Based on Prerequisites with GPT and Google Sheets — n8n 工作流

中 复杂度⚡ 触发器9 个节点🏷️ Project Management👁 14 次查看作者：Robert Breen

概览

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

使用的节点

Google SheetsAI AgentOpenAI Chat ModelStructured Output Parser

工作流预览

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

工作原理

  1. 1

    触发器

    工作流由 触发器 触发器启动。

  2. 2

    处理

    数据流经 9 个节点, connecting agent, googlesheets, lmchatopenai。

  3. 3

    输出

    工作流完成自动化并将结果发送到配置的目标。

节点详情 (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

如何导入此工作流

  1. 1点击右侧 下载 JSON 按钮保存工作流文件。
  2. 2打开你的 n8n 实例，依次点击 工作流 → 新建 → 从文件导入。
  3. 3选择下载的 generate-student-course-schedules-based-on-prerequisites-with-gpt-and-google-sheets 文件并点击导入。
  4. 4为每个服务节点配置 凭证（API 密钥、OAuth 等）。
  5. 5点击 测试工作流 验证一切正常，然后激活它。

或直接在 n8n → 从 JSON 导入 中粘贴：

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

集成

agentgooglesheetslmchatopenaimanualtriggeroutputparserstructuredsetsplitout

获取此工作流

一键下载并导入

下载 JSON在 n8n.io 上查看
节点9
复杂度medium
触发器trigger
查看次数14
分类Project Management

创建者

Robert Breen

Robert Breen

@rbreen

标签

agentgooglesheetslmchatopenaimanualtriggeroutputparserstructuredsetsplitout
⚡

n8n 新手？

n8n 是一款免费开源的工作流自动化工具，支持自托管或使用云版本。

免费获取 n8n →