Generate school report card PDFs and email them to parents with Gmail
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This workflow has 10 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Gmail and Htmlcsstopdf (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get row(s) (Data table): get
- Loop Over Students (Loop Over Items (Split in Batches)): loops over the items in batches
- Skip Already Sent (If): checks a condition and branches into true / false
- Calculate Grade and Remarks (Code): runs custom JavaScript code
- Build HTML Report Card (Code): runs custom JavaScript code
- Convert HTML to PDF (Htmlcsstopdf): uses Htmlcsstopdf
- Send a message to Parents (Gmail): uses Gmail
- Wait: waits 3 seconds
- Update row(s) (Data table): update
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-htmlcsstopdf is verified or supports 3.0 (used in Convert HTML to PDF).
Nodes used (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Data table
n8n-nodes-base.dataTable - Htmlcsstopdf
n8n-nodes-htmlcsstopdf.htmlcsstopdf - Gmail
n8n-nodes-base.gmail - Wait
n8n-nodes-base.wait
From the author
This n8n workflow automates the complete lifecycle of student report card generation — from fetching raw marks data to delivering polished PDF reports directly to parents via email. It is designed to be scalable, idempotent, and production-ready, making it…