Monitor at-risk students with Google Sheets, GPT-4o, Gmail, Slack and Telegram
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 16 nodes and runs on a schedule (every week at 07:00) (plus 1 other trigger). Along the way it connects Google Sheets, OpenAI, Slack and Telegram and 1 more.
How it runs
Trigger: On a schedule (every week at 07:00) (plus 1 other trigger).
- Read Student Data from Sheets (Google Sheets): uses Google Sheets
- Slack: uses Slack
- Compute Risk Index (Code): runs custom JavaScript code
- Filter HIGH Risk Students (Code): runs custom JavaScript code
- Filter MEDIUM + HIGH Risk Students (Code): runs custom JavaScript code
- Prepare Trend Log Rows (Code): runs custom JavaScript code
- GPT-4o Personalised Nudge (OpenAI): uses OpenAI
- Build Teacher Digest (Code): runs custom JavaScript code
- Log Trend to Sheets (Google Sheets): append
- Loop Over High-Risk Students (Loop Over Items (Split in Batches)): loops over the items in batches
…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 (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - OpenAI
@n8n/n8n-nodes-langchain.openAi - Slack
n8n-nodes-base.slack - Telegram
n8n-nodes-base.telegram - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Gmail
n8n-nodes-base.gmail - Error Trigger
n8n-nodes-base.errorTrigger
From the author
Quick overview This workflow runs weekly to read student performance data from Google Sheets, calculates a risk index and trend, generates personalised nudge messages with OpenAI for high-risk students, posts a teacher digest to Slack and Telegram, and logs…