Grade and deliver multi-course assignment feedback with GPT-4o, Google Drive, Slack, and Gmail
Ready for 3.0What this workflow does
This AI workflow has 35 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Postgres, Google Drive, OpenAI Chat Model and Slack and 1 more.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Workflow Configuration (Edit Fields (Set)): sets 10 fields: lmsApiUrl, lmsApiKey, plagiarismThreshold…
- Fetch LMS Assignments (HTTP Request): calls an HTTP API
- Merge: merges the data from its input branches
- Normalize Submission Data (Edit Fields (Set)): sets 10 fields: studentId, studentEmail, studentName…
- Validate Submission (Code): runs custom JavaScript code
- Check Validation Status (If): checks a condition and branches into true / false
- Check Duplicate Submission (Postgres): run a query
- Handle Validation Error (Edit Fields (Set)): sets 3 fields: status, message, timestamp
- Is Duplicate? (If): checks a condition and branches into true / false
- Respond to Form Submission (Respond to Webhook): sends the response back to the webhook caller
…plus 19 more steps. See the full node list below.
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 (18)
- Webhook
n8n-nodes-base.webhook - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Postgres
n8n-nodes-base.postgres - Google Drive
n8n-nodes-base.googleDrive - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Switch
n8n-nodes-base.switch - HTML
n8n-nodes-base.html - Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail - Wait
n8n-nodes-base.wait - Respond to Webhook
n8n-nodes-base.respondToWebhook
From the author
How It Works This workflow automates business intelligence reporting by aggregating data from multiple sources, processing it through AI models, and delivering formatted dashboards via email. Designed for business analysts, operations managers, and executive…