Automated course registration evaluation with AI, Gmail, and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 15 nodes and runs when someone submits an n8n form (“API testing and Automation Mastery Program - Enrollment Form”). Along the way it connects OpenAI Chat Model, Google Drive, Pinecone Vector Store and Embeddings Google Gemini and 2 more.
How it runs
Trigger: When someone submits an n8n form (“API testing and Automation Mastery Program - Enrollment Form”).
- Combine User Data (Edit Fields (Set)): sets 1 field: user_context
- Download file (Google Drive): download
- Pinecone Vector Store: stores documents in the Pinecone vector store, with embeddings: Embeddings Google Gemini; document loader: Default Data Loader
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; output parser: Structured Output Parser
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; 2 tools (Pinecone Vector Store, Send a message in Gmail)
- Append row in sheet (Google Sheets): append
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Drive
n8n-nodes-base.googleDrive - Pinecone Vector Store
@n8n/n8n-nodes-langchain.vectorStorePinecone - Embeddings Google Gemini
@n8n/n8n-nodes-langchain.embeddingsGoogleGemini - Default Data Loader
@n8n/n8n-nodes-langchain.documentDefaultDataLoader - Gmail Tool
n8n-nodes-base.gmailTool - Google Sheets
n8n-nodes-base.googleSheets
From the author
📌 Description Automate your course enrollment process with this workflow that handles student submissions, evaluates eligibility, and sends acceptance or rejection emails — all without manual effort. It's perfect for instructors managing multi-week technical…