Grade assignments and email feedback with OpenAI, Google Drive, Sheets, Gmail and Telegram
Ready for 3.0What this workflow does
This AI workflow has 17 nodes and runs on Google Drive events (file created) (plus 2 other triggers). Along the way it connects Slack, OpenAI, Google Drive and Google Docs and 3 more.
How it runs
Trigger: On Google Drive events (file created) (plus 2 other triggers).
- Google Drive: download
- Google Sheets: uses Google Sheets
- Slack: uses Slack
- OpenAI: uses OpenAI
- Code: runs custom JavaScript code
- Code: runs custom JavaScript code
- If: checks a condition and branches into true / false
- Google Docs: get
- Gmail: uses Gmail
- Telegram: uses Telegram
…plus 4 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 (12)
- Error Trigger
n8n-nodes-base.errorTrigger - Slack
n8n-nodes-base.slack - OpenAI
@n8n/n8n-nodes-langchain.openAi - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Google Drive
n8n-nodes-base.googleDrive - Code
n8n-nodes-base.code - Google Docs
n8n-nodes-base.googleDocs - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Telegram
n8n-nodes-base.telegram
From the author
Quick overview This workflow watches a Google Drive folder for new PDF submissions, extracts text and grades each assignment with OpenAI using a Google Docs rubric, logs results to Google Sheets, emails feedback via Gmail, and sends a daily summary to the…