{ "edges": [ { "to": "7854bc56-4241-41b9-8249-5fab7391de4b", "from": "e4bbd1c0-2b4b-4f6e-9c25-19b573956635", "toPort": "0", "fromPort": "0" }, { "to": "7854bc56-4241-41b9-8249-5fab7391de4b", "from": "7ee8ade0-1d98-4c82-8c35-7bb2b5131bc7", "toPort": "0", "fromPort": "0" }, { "to": "7ee8ade0-1d98-4c82-8c35-7bb2b5131bc7", "from": "7a11d27e-bda9-4c5b-b3e3-2e9779bd5061", "toPort": "0", "fromPort": "0" }, { "to": "1150d65b-c682-4211-bda0-6f1bf92b0e02", "from": "c86b339b-008e-490b-b745-3d521843122c", "toPort": "0", "fromPort": "0" }, { "to": "7854bc56-4241-41b9-8249-5fab7391de4b", "from": "c86b339b-008e-490b-b745-3d521843122c", "toPort": "0", "fromPort": "1" }, { "to": "c86b339b-008e-490b-b745-3d521843122c", "from": "7854bc56-4241-41b9-8249-5fab7391de4b", "toPort": "0", "fromPort": "1" }, { "to": "8f91fb96-bf7d-4f07-aa09-d92fb80e8d97", "from": "7732d783-427b-4fb2-b791-9f1c0105e753", "toPort": "0", "fromPort": "0" }, { "to": "e4bbd1c0-2b4b-4f6e-9c25-19b573956635", "from": "214009eb-41d7-4ecc-b446-b3f421e4cf10", "toPort": "0", "fromPort": "0" }, { "to": "7732d783-427b-4fb2-b791-9f1c0105e753", "from": "b7cd1bc0-d852-4175-9cbe-7f5ff610c051", "toPort": "0", "fromPort": "0" }, { "to": "7a11d27e-bda9-4c5b-b3e3-2e9779bd5061", "from": "8f91fb96-bf7d-4f07-aa09-d92fb80e8d97", "toPort": "0", "fromPort": "0" }, { "to": "b7cd1bc0-d852-4175-9cbe-7f5ff610c051", "from": "1150d65b-c682-4211-bda0-6f1bf92b0e02", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "214009eb-41d7-4ecc-b446-b3f421e4cf10", "name": "Run Workflow Manually", "type": "manualTrigger", "params": {}, "position": [ -1312, 576 ] }, { "id": "7854bc56-4241-41b9-8249-5fab7391de4b", "name": "Loop Over Students", "type": "passthrough", "params": { "mode": "noOp", "options": {} }, "position": [ -816, 576 ] }, { "id": "c86b339b-008e-490b-b745-3d521843122c", "name": "Skip Already Sent", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 1, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "condition-skip-sent", "operator": { "type": "string", "operation": "notEquals" }, "leftValue": "={{ $json['Status'] }}", "rightValue": "Sent" } ] } }, "position": [ -512, 592 ] }, { "id": "1150d65b-c682-4211-bda0-6f1bf92b0e02", "name": "Calculate Grade and Remarks", "type": "code", "params": { "mode": "runOnceForEachItem", "jsCode": "const item = $input.item.json;\n\n// ─── SUBJECT MARKS ───────────────────────────────────────────\n\nconst subjects = {\n 'Math': parseInt(item['Math'] || 0),\n 'Science': parseInt(item['Science'] || 0),\n 'English': parseInt(item['English'] || 0),\n 'Hindi': parseInt(item['Hindi'] || 0),\n 'SST': parseInt(item['SST'] || 0)\n};\n\nconst maxPerSubject = parseInt(item['Max_Per_Subject'] || 100);\nconst totalSubjects = Object.keys(subjects).length;\nconst maxMarks = maxPerSubject * totalSubjects;\nconst totalMarks = Object.values(subjects).reduce((a, b) => a + b, 0);\nconst percentage = ((totalMarks / maxMarks) * 100).toFixed(1);\n\n// ─── GRADE & COLOR ───────────────────────────────────────────\nlet grade, gradeColor, gradeBg, remark;\n\nif (percentage >= 90) {\n grade = 'A+';\n gradeColor = '#1b5e20';\n gradeBg = '#e8f5e9';\n remark = 'Outstanding performance! Truly exceptional dedication and hard work this term.';\n} else if (percentage >= 75) {\n grade = 'A';\n gradeColor = '#1565c0';\n gradeBg = '#e3f2fd';\n remark = 'Excellent work. A consistent and hardworking student. Keep it up!';\n} else if (percentage >= 60) {\n grade = 'B';\n gradeColor = '#e65100';\n gradeBg = '#fff3e0';\n remark = 'Good performance. Focused attention on weaker subjects will bring further improvement.';\n} else if (percentage >= 45) {\n grade = 'C';\n gradeColor = '#6a1b9a';\n gradeBg = '#f3e5f5';\n remark = 'Satisfactory. Regular study habits and parental support will help improve results.';\n} else {\n grade = 'D';\n gradeColor = '#b71c1c';\n gradeBg = '#ffebee';\n remark = 'Needs significant improvement. Please schedule a meeting with the class teacher at the earliest.';\n}\n\n// ─── SUBJECT RESULTS ─────────────────────────────────────────\nconst passMarkPct = 0.33; // 33% to pass each subject\nconst subjectResults = Object.entries(subjects).map(([name, marks]) => ({\n name,\n marks,\n max: maxPerSubject,\n pct: ((marks / maxPerSubject) * 100).toFixed(0),\n pass: marks >= (maxPerSubject * passMarkPct),\n passColor: marks >= (maxPerSubject * passMarkPct) ? '#2e7d32' : '#c62828',\n passBg: marks >= (maxPerSubject * passMarkPct) ? '#e8f5e9' : '#ffebee',\n passLabel: marks >= (maxPerSubject * passMarkPct) ? 'Pass' : 'Fail'\n}));\n\n// ─── ATTENDANCE STYLING ──────────────────────────────────────\nconst attendance = parseFloat(item['Attendance'] || 0);\nconst attendanceColor = attendance >= 85 ? '#1b5e20' : attendance >= 75 ? '#e65100' : '#b71c1c';\n\nreturn {\n ...item,\n calc_subjects: JSON.stringify(subjectResults),\n calc_totalMarks: totalMarks,\n calc_maxMarks: maxMarks,\n calc_percentage: parseFloat(percentage),\n calc_grade: grade,\n calc_gradeColor: gradeColor,\n calc_gradeBg: gradeBg,\n calc_remark: remark,\n calc_attendance: attendance,\n calc_attendanceColor: attendanceColor,\n calc_term: item['Term'] || 'Term 2',\n calc_year: item['Academic_Year'] || '2024-25'\n};" }, "position": [ -256, 480 ] }, { "id": "b7cd1bc0-d852-4175-9cbe-7f5ff610c051", "name": "Build HTML Report Card", "type": "code", "params": { "mode": "runOnceForEachItem", "jsCode": "const d = $input.item.json;\nconst subjects = JSON.parse(d.calc_subjects);\n\n// ─── BUILD SUBJECT TABLE ROWS ─────────────────────────────────\nconst tableRows = subjects.map(s => `\n \n ${s.name}\n ${s.marks} / ${s.max}\n ${s.pct}%\n \n ${s.passLabel}\n \n `).join('');\n\n// ─── FULL HTML REPORT CARD ────────────────────────────────────\nconst html = `\n\n\n\n\n\n\n

\n\n \n \n\n \n

Student Name

${d['Student_Name'] || ''}

Class & Section

Class ${d['Class'] || ''} — Section ${d['Section'] || ''}

Roll Number

${d['Roll_No'] || ''}

Examination

${d.calc_term}, ${d.calc_year}

\n\n \n

📊 Subject-wise Performance

\n \n \n \n \n \n \n \n \n \n \n ${tableRows}\n \n \n \n \n \n \n \n

Subject	Marks Obtained	Percentage	Result
Total / Grand Total	${d.calc_totalMarks} / ${d.calc_maxMarks}	${d.calc_percentage}%	\n Grade ${d.calc_grade}\n

\n\n \n

${d.calc_grade}

${d.calc_percentage}% — ${d.calc_totalMarks} / ${d.calc_maxMarks}

Overall Performance • ${d.calc_term} ${d.calc_year}

\n\n \n

${d.calc_grade}

Grade

${d.calc_percentage}%

Overall %

${d.calc_attendance}%

Attendance

\n\n \n

📝 Class Teacher's Remark

${d.calc_remark}

\n\n \n

Class Teacher

Exam Controller

Principal

\n\n \n

\n This is a system-generated report • Generated on ${new Date().toLocaleDateString('en-IN', { day: 'numeric', month: 'long', year: 'numeric' })} • For queries contact the school office\n

\n\n

\n\n`;\n\n// Convert HTML string to binary so Gotenberg can receive it\nconst binaryData = await this.helpers.prepareBinaryData(\n Buffer.from(html, 'utf8'),\n 'report_card.html',\n 'text/html'\n);\n\nreturn {\n json: {\n ...$input.item.json,\n reportHtml: html // This sends the full HTML as a text property\n }\n};" }, "position": [ 0, 480 ] }, { "id": "e4bbd1c0-2b4b-4f6e-9c25-19b573956635", "name": "Get row(s)", "type": "passthrough", "params": { "mode": "noOp", "filters": { "conditions": [ { "keyName": "Status", "condition": "isEmpty" } ] }, "matchType": "allConditions", "operation": "get", "dataTableId": { "__rl": true, "mode": "list", "value": "zQlRqq5eqJ5cvvhT", "cachedResultUrl": "/projects/YORR4xM3FFToOHnO/datatables/zQlRqq5eqJ5cvvhT", "cachedResultName": "Jainam-Email-parent-Reportcard" } }, "position": [ -1072, 576 ] }, { "id": "7732d783-427b-4fb2-b791-9f1c0105e753", "name": "Convert HTML to PDF", "type": "integration", "params": { "service": "htmlcsstopdf", "operation": "run", "html_content": "={{ $json.reportHtml }}", "__originalType": "n8n-nodes-htmlcsstopdf.htmlcsstopdf", "dynamic_params": { "params": [] } }, "position": [ 256, 480 ] }, { "id": "7ee8ade0-1d98-4c82-8c35-7bb2b5131bc7", "name": "Update row(s)", "type": "passthrough", "params": { "mode": "noOp", "columns": { "value": { "Status": "Sent", "Sent_At": "={{ $now.toFormat('dd/MM/yyyy HH:mm:ss') }}", "Report_URL": "={{ $('Convert HTML to PDF').item.json.pdf_url }}" }, "schema": [ { "id": "Student_Name", "type": "string", "display": true, "removed": true, "readOnly": false, "required": false, "displayName": "Student_Name", "defaultMatch": false }, { "id": "Parent_Name", "type": "string", "display": true, "removed": true, "readOnly": false, "required": false, "displayName": "Parent_Name", "defaultMatch": false }, { "id": "Parent_WhatsApp", "type": "number", "display": true, "removed": true, "readOnly": false, "required": false, "displayName": "Parent_WhatsApp", "defaultMatch": false }, { "id": "Parent_Email", "type": "string", "display": true, "removed": true, "readOnly": false, "required": false, "displayName": "Parent_Email", "defaultMatch": false }, { "id": "Class", "type": "number", "display": true, "removed": true, "readOnly": false, "required": false, "displayName": "Class", "defaultMatch": false }, { "id": "Section", "type": "string", "display": true, "removed": true, "readOnly": false, "required": false, "displayName": "Section", "defaultMatch": false }, { "id": "Roll_No", "type": "number", "display": true, "removed": true, "readOnly": false, "required": false, "displayName": "Roll_No", "defaultMatch": false }, { "id": "Term", "type": "string", "display": true, "removed": true, "readOnly": false, "required": false, "displayName": "Term", "defaultMatch": false }, { "id": "Academic_Year", "type": "string", "display": true, "removed": true, "readOnly": false, "required": false, "displayName": "Academic_Year", "defaultMatch": false }, { "id": "Math", "type": "number", "display": true, "removed": true, "readOnly": false, "required": false, "displayName": "Math", "defaultMatch": false }, { "id": "Science", "type": "number", "display": true, "removed": true, "readOnly": false, "required": false, "displayName": "Science", "defaultMatch": false }, { "id": "English", "type": "number", "display": true, "removed": true, "readOnly": false, "required": false, "displayName": "English", "defaultMatch": false }, { "id": "Hindi", "type": "number", "display": true, "removed": true, "readOnly": false, "required": false, "displayName": "Hindi", "defaultMatch": false }, { "id": "SST", "type": "number", "display": true, "removed": true, "readOnly": false, "required": false, "displayName": "SST", "defaultMatch": false }, { "id": "Max_Per_Subject", "type": "number", "display": true, "removed": true, "readOnly": false, "required": false, "displayName": "Max_Per_Subject", "defaultMatch": false }, { "id": "Attendance", "type": "number", "display": true, "removed": true, "readOnly": false, "required": false, "displayName": "Attendance", "defaultMatch": false }, { "id": "Status", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "Status", "defaultMatch": false }, { "id": "Report_URL", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "Report_URL", "defaultMatch": false }, { "id": "Sent_At", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "Sent_At", "defaultMatch": false } ], "mappingMode": "defineBelow", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false }, "filters": { "conditions": [ { "keyName": "Roll_No", "keyValue": "={{ $('Loop Over Students').item.json.Roll_No }}" } ] }, "options": {}, "operation": "update", "dataTableId": { "__rl": true, "mode": "list", "value": "zQlRqq5eqJ5cvvhT", "cachedResultUrl": "/projects/YORR4xM3FFToOHnO/datatables/zQlRqq5eqJ5cvvhT", "cachedResultName": "Jainam-Email-parent-Reportcard" } }, "position": [ 992, 480 ] }, { "id": "8f91fb96-bf7d-4f07-aa09-d92fb80e8d97", "name": "Send a message to Parents", "type": "integration", "params": { "sendTo": "={{ $('Get row(s)').item.json.Parent_Email }}", "message": "=Dear {{ $('Build HTML Report Card').item.json.Parent_Name }},

\n Please find attached the digital progress report for {{ $('Build HTML Report Card').item.json.Student_Name }} for {{ $('Build HTML Report Card').item.json.Term }}.

\n Quick Summary:
\n - Grade: {{ $('Build HTML Report Card').item.json.calc_grade }}\n - Score: {{ $('Build HTML Report Card').item.json.calc_percentage }}%

\n You can view/download the report here: View Report Card

\n Regards,
\n Principal
\n School_Name", "options": {}, "service": "gmail", "subject": "=Progress Report: {{ $('Build HTML Report Card').item.json.Student_Name }}, Class: {{ $('Get row(s)').item.json.Class }}{{ $('Get row(s)').item.json.Section }},{{ $('Get row(s)').item.json.Academic_Year }}", "operation": "read" }, "position": [ 496, 480 ] }, { "id": "7a11d27e-bda9-4c5b-b3e3-2e9779bd5061", "name": "Wait 3 Seconds", "type": "passthrough", "params": { "mode": "noOp", "amount": 3 }, "position": [ 736, 480 ] } ] }

Generate school report card PDFs and email them to parents with Gmail