Automated corporate training requests with GPT-4, Jotform & Google Sheets
Needs changesWhat this workflow does
This AI workflow has 12 nodes and runs on Jotform events. Along the way it connects Gmail, Google Sheets, OpenAI Chat Model and Jot Form.
How it runs
Trigger: On Jotform events.
- Parse Training Request (Code): runs custom JavaScript code
- Check Training Budget (Code): runs custom JavaScript code
- AI Training Analysis (AI Agent): runs an AI agent, with model: OpenAI Chat Model
- Extract AI Analysis (Edit Fields (Set)): sets 1 field: aiAnalysis
- Merge Training Analysis (Code): runs custom JavaScript code
- Requires Approval? (If): checks a condition and branches into true / false
- Send Manager Approval (Gmail): uses Gmail
- Send Rejection Email (Gmail): uses Gmail
- Send Employee Confirmation (Gmail): uses Gmail
- Log to Google Sheets (Google Sheets): append or update
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI Training Analysis (v1.6): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Training Analysis (v1.6) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (8)
- Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Jotform Trigger
n8n-nodes-base.jotFormTrigger
From the author
Transform chaotic training requests into strategic skill development - achieving 100% completion tracking, 30% cost reduction through intelligent planning, and data-driven L&D decisions. What This Workflow Does Revolutionizes corporate training management…