Send weekly parent progress reports with Google Sheets, GPT-4o mini and Gmail
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 27 nodes and runs on a schedule (cron 0 18 * * 5) (plus 2 other triggers). Along the way it connects Google Sheets, OpenAI, Slack and Gmail and 1 more. It also calls api.pdfshift.io over HTTP.
How it runs
Trigger: On a schedule (cron 0 18 * * 5) (plus 2 other triggers).
- Read Students Sheet (Google Sheets): uses Google Sheets
- Normalize Webhook Data (Code): runs custom JavaScript code
- Slack: uses Slack
- Merge: merges the data from its input branches
- Configurable Alert Thresholds (Edit Fields (Set)): sets 4 fields: attendance_threshold, test_score_threshold, homework_threshold…
- Fetch Previous Week Snapshot (Google Sheets): uses Google Sheets
- Process & Flag Students (Code): runs custom JavaScript code
- AI: Write Parent Narrative (OpenAI): uses OpenAI
- Is Urgent? (3+ Red Flags) (If): checks a condition and branches into true / false
- Append to History Sheet (Google Sheets): append
…plus 14 more steps. See the full node list below.
Services it uses
HTTP calls to: api.pdfshift.io
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 (13)
- Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - Merge
n8n-nodes-base.merge - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - OpenAI
@n8n/n8n-nodes-langchain.openAi - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Gmail
n8n-nodes-base.gmail - Telegram
n8n-nodes-base.telegram - HTTP Request
n8n-nodes-base.httpRequest - Error Trigger
n8n-nodes-base.errorTrigger
From the author
Quick overview This workflow runs every Friday at 18:00 UTC to read student performance data from Google Sheets, generate a personalised parent narrative with OpenAI, render it as a PDF via PDFShift, and send updates through Gmail and Telegram, while logging…