{ "edges": [ { "to": "1e3c0f8b-74d5-42df-822a-f04ce0d2c752", "from": "b93f81d0-b3eb-47ca-8c64-ea81b39c4e98", "toPort": "0", "fromPort": "0" }, { "to": "2266119e-b1a5-4472-b993-d47a8bdc3224", "from": "4f25bfb0-1934-4d2b-94e6-f0c9d898d13d", "toPort": "0", "fromPort": "0" }, { "to": "5f95d17f-040d-49d4-8b8c-f6a49ebf039c", "from": "086482ae-80f3-4058-848c-497a6774dcbc", "toPort": "0", "fromPort": "0" }, { "to": "43662678-2cfd-42fc-9023-f37696269795", "from": "2266119e-b1a5-4472-b993-d47a8bdc3224", "toPort": "0", "fromPort": "0" }, { "to": "8107e3ae-b4bb-4a9b-9ab3-843525bfe943", "from": "9d064507-3406-493e-836e-b16c81ad324b", "toPort": "0", "fromPort": "0" }, { "to": "8ab2756a-1239-459b-b9f6-6ec9fd6312f7", "from": "1dc79c9a-895a-471b-8f25-e8a90c20ca42", "toPort": "0", "fromPort": "0" }, { "to": "be72ef00-997a-4826-82b9-c76ffca52cd3", "from": "5f95d17f-040d-49d4-8b8c-f6a49ebf039c", "toPort": "0", "fromPort": "0" }, { "to": "29ef1e50-241e-4c02-bc29-f803cec709b6", "from": "5f95d17f-040d-49d4-8b8c-f6a49ebf039c", "toPort": "0", "fromPort": "1" }, { "to": "b93f81d0-b3eb-47ca-8c64-ea81b39c4e98", "from": "43662678-2cfd-42fc-9023-f37696269795", "toPort": "0", "fromPort": "0" }, { "to": "086482ae-80f3-4058-848c-497a6774dcbc", "from": "8107e3ae-b4bb-4a9b-9ab3-843525bfe943", "toPort": "0", "fromPort": "0" }, { "to": "098338dc-abfd-4b12-b03d-4a9487f9a19d", "from": "8107e3ae-b4bb-4a9b-9ab3-843525bfe943", "toPort": "0", "fromPort": "1" }, { "to": "1dc79c9a-895a-471b-8f25-e8a90c20ca42", "from": "1e3c0f8b-74d5-42df-822a-f04ce0d2c752", "toPort": "0", "fromPort": "0" }, { "to": "4f25bfb0-1934-4d2b-94e6-f0c9d898d13d", "from": "be72ef00-997a-4826-82b9-c76ffca52cd3", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "9d064507-3406-493e-836e-b16c81ad324b", "name": "Webhook Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.webhook", "path": "ceu-certificate", "options": {}, "httpMethod": "POST", "responseMode": "responseNode" }, "position": [ 528, 288 ] }, { "id": "8107e3ae-b4bb-4a9b-9ab3-843525bfe943", "name": "Validate Required Fields", "type": "if", "params": { "conditions": { "string": [ { "value1": "={{$json.body.name}}", "operation": "isNotEmpty" }, { "value1": "={{$json.body.email}}", "operation": "isNotEmpty" }, { "value1": "={{$json.body.courseTitle}}", "operation": "isNotEmpty" }, { "value1": "={{$json.body.CEUsEarned}}", "operation": "isNotEmpty" }, { "value1": "={{$json.body.completionDate}}", "operation": "isNotEmpty" } ] } }, "position": [ 752, 288 ] }, { "id": "098338dc-abfd-4b12-b03d-4a9487f9a19d", "name": "Stop: Incomplete Data", "type": "passthrough", "params": { "mode": "noOp", "options": { "responseCode": 400 }, "respondWith": "json", "responseBody": "={\"success\": false, \"error\": \"Missing required fields\", \"message\": \"Please provide name, email, courseTitle, CEUsEarned, and completionDate\"}" }, "position": [ 960, 480 ] }, { "id": "5f95d17f-040d-49d4-8b8c-f6a49ebf039c", "name": "Check Domain Verified", "type": "if", "params": { "conditions": { "boolean": [ { "value1": "={{ $json.valid }}", "value2": true } ] } }, "position": [ 1136, 272 ] }, { "id": "29ef1e50-241e-4c02-bc29-f803cec709b6", "name": "Stop: Domain Not Verified", "type": "passthrough", "params": { "mode": "noOp", "options": { "responseCode": 400 }, "respondWith": "json", "responseBody": "={\"success\": false, \"error\": \"Invalid email\", \"message\": \"The provided email address could not be verified or is from a disposable domain\"}" }, "position": [ 1392, 480 ] }, { "id": "43662678-2cfd-42fc-9023-f37696269795", "name": "Upload to Google Drive", "type": "integration", "params": { "name": "=CEU_Certificate_{{ $('Webhook Trigger').item.json.body.name.replace(/\\s+/g, '_')}}_{{ $('Generate Certificate ID & QR').item.json.certificateId }}.png", "driveId": { "__rl": true, "mode": "list", "value": "My Drive", "cachedResultName": "My Drive" }, "options": {}, "service": "googleDrive", "folderId": { "__rl": true, "mode": "list", "value": "root", "cachedResultUrl": "https://drive.google.com/drive", "cachedResultName": "YOUR_FOLDER_NAME" }, "operation": "read" }, "position": [ 2016, 256 ] }, { "id": "1e3c0f8b-74d5-42df-822a-f04ce0d2c752", "name": "Notify Organizers (Slack)", "type": "integration", "params": { "text": "=New CEU Certificate Issued\n• Recipient: John Smith\n• Course: Advanced Project Management• CEUs: 3.5 • Hours: 35\n\nCertificate ID Issued On\nCERT-CEU-1763553796549-VNDQJ6 November 19, 2025\n\n{{ $('HTML to PDF').item.json.pdf_url }}\n[ View Certificate PDF ]\n\nSent automatically • 2:15 PM • n8n CEU Bot", "select": "channel", "service": "slack", "channelId": { "__rl": true, "mode": "list", "value": "YOUR_CHANNEL_ID", "cachedResultName": "YOUR_CHANNEL_NAME" }, "operation": "read", "otherOptions": {} }, "position": [ 2416, 256 ] }, { "id": "1dc79c9a-895a-471b-8f25-e8a90c20ca42", "name": "Log to Google Sheets", "type": "integration", "params": { "columns": { "value": { "Name": "={{ $('Webhook Trigger').item.json.body.name }}", "Email": "={{ $('Webhook Trigger').item.json.body.email }}", "Status": "Issued", "PDF URL": "={{ $('HTML to PDF').item.json.pdf_url }}", "Timestamp": "={{new Date().toISOString()}}", "CEUs Earned": "={{ $('Webhook Trigger').item.json.body.CEUsEarned }}", "Course Title": "={{ $('Webhook Trigger').item.json.body.courseTitle }}", "Certificate ID": "={{ $('Generate Certificate ID & QR').item.json.certificateId }}", "Training Hours": "={{$('Webhook Trigger').item.json.body.trainingHours || 'N/A'}}", "Completion Date": "={{ $('Webhook Trigger').item.json.body.completionDate }}", "Instructor Name": "={{ $('Webhook Trigger').item.json.body.instructorName }}", "Verification URL": "={{ $('Generate Certificate ID & QR').item.json.verificationUrl }}", "Company / Provider": "={{ $('Webhook Trigger').item.json.body.companyName }}" }, "schema": [ { "id": "Timestamp", "type": "string", "display": true, "required": false, "displayName": "Timestamp", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Name", "type": "string", "display": true, "required": false, "displayName": "Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Email", "type": "string", "display": true, "required": false, "displayName": "Email", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Course Title", "type": "string", "display": true, "required": false, "displayName": "Course Title", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "CEUs Earned", "type": "string", "display": true, "required": false, "displayName": "CEUs Earned", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Training Hours", "type": "string", "display": true, "required": false, "displayName": "Training Hours", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Completion Date", "type": "string", "display": true, "required": false, "displayName": "Completion Date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Certificate ID", "type": "string", "display": true, "required": false, "displayName": "Certificate ID", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Verification URL", "type": "string", "display": true, "required": false, "displayName": "Verification URL", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "PDF URL", "type": "string", "display": true, "removed": false, "required": false, "displayName": "PDF URL", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Instructor Name", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Instructor Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Company / Provider", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Company / Provider", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Status", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Status", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_DOCUMENT_ID/edit#gid=0", "cachedResultName": "YOUR_SHEET_NAME" }, "documentId": { "__rl": true, "mode": "list", "value": "YOUR_DOCUMENT_ID", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_DOCUMENT_ID/edit?usp=drivesdk", "cachedResultName": "YOUR_DOCUMENT_NAME" } }, "position": [ 2624, 256 ] }, { "id": "8ab2756a-1239-459b-b9f6-6ec9fd6312f7", "name": "Respond to Webhook", "type": "passthrough", "params": { "mode": "noOp", "options": {}, "respondWith": "json", "responseBody": "={\n \"success\": true,\n \"message\": \"CEU Certificate generated and sent successfully\",\n \"certificateId\": \"{{ $('Generate Certificate ID & QR').item.json.certificateId }}\",\n \"certificateUrl\": \"{{ $('HTML to PDF').item.json.pdf_url }}\",\n \"driveUrl\": \"{{$('Upload to Google Drive').item.json.webViewLink}}\"\n}" }, "position": [ 2848, 256 ] }, { "id": "086482ae-80f3-4058-848c-497a6774dcbc", "name": "Verifi Email", "type": "integration", "params": { "email": "={{ $json.body.email }}", "service": "verifiemail", "operation": "run", "__originalType": "n8n-nodes-verifiemail.verifiEmail" }, "position": [ 944, 272 ] }, { "id": "4f25bfb0-1934-4d2b-94e6-f0c9d898d13d", "name": "HTML to PDF", "type": "integration", "params": { "service": "htmlcsstopdf", "operation": "run", "html_content": "=\n\n\n\nCEU Certificate - {{ $json.certificateId }}\n\n\n\n

\n\n

Certificate of Completion

Continuing Education Units (CEUs)

\n\n

This certifies that

\n\n

has successfully completed the training course

on {{ $('Webhook Trigger').item.json.body.completionDate.split(\"-\")[1] + \"/\" + $('Webhook Trigger').item.json.body.completionDate.split(\"-\")[2] + \"/\" + $('Webhook Trigger').item.json.body.completionDate.split(\"-\")[0] }}

\n\n

Awarded

{{ $('Webhook Trigger').item.json.body.CEUsEarned }} CEUs

{{ $('Webhook Trigger').item.json.body.trainingHours || \"—\" }} Contact Hours

\n\n \n\n

\n Certificate ID: {{ $json.certificateId }} • \n Issued: {{ $now.toFormat(\"MMMM d, yyyy\") }} • \n Valid until: {{ $now.plus({years: 2}).toFormat(\"MMMM d, yyyy\") }}\n

\n\n

\n\n", "__originalType": "n8n-nodes-htmlcsstopdf.htmlcsstopdf" }, "position": [ 1584, 256 ] }, { "id": "2266119e-b1a5-4472-b993-d47a8bdc3224", "name": "Download File", "type": "http", "params": { "url": "={{ $json.pdf_url }}", "options": { "response": { "response": { "responseFormat": "file" } } } }, "position": [ 1792, 256 ] }, { "id": "be72ef00-997a-4826-82b9-c76ffca52cd3", "name": "Generate Certificate ID & QR", "type": "code", "params": { "functionCode": "// SINGLE CODE NODE → Certificate ID + QR Code (perfect for n8n 1.117.3)\nconst body = items[0].json.body;\n\n// Generate Certificate ID\nconst certId = `CERT-CEU-${Date.now()}-${Math.random().toString(36).substr(2, 6).toUpperCase()}`;\nconst verificationUrl = `https://training.verify.com/cert?id=${certId}`;\n\n// Direct QR code URL from qrserver.com\nconst qrCodeUrl = `https://api.qrserver.com/v1/create-qr-code/?size=300x300&format=png&margin=10&data=${encodeURIComponent(verificationUrl)}`;\n\nreturn [\n {\n json: {\n ...body,\n certificateId: certId,\n verificationUrl: verificationUrl,\n qrCodeUrl: qrCodeUrl,\n generatedAt: new Date().toISOString()\n },\n // This tells n8n to download the QR image automatically and embed it\n binary: {\n qrCode: {\n data: qrCodeUrl,\n mimeType: \"image/png\",\n fileName: `${certId}-QR.png`,\n fileExtension: \"png\"\n }\n }\n }\n];" }, "position": [ 1360, 256 ] }, { "id": "b93f81d0-b3eb-47ca-8c64-ea81b39c4e98", "name": "Send Email", "type": "integration", "params": { "sendTo": "={{ $('Webhook Trigger').item.json.body.email }}", "message": "=

\n \n \n

Certificate Awarded

Congratulations on your achievement!

\n\n \n

\n \n

\n Dear {{ $('Webhook Trigger').item.json.body.name }},\n

\n\n

\n We are delighted to inform you that you have successfully completed the training program:\n

\n\n

\n {{ $('Webhook Trigger').item.json.body.courseTitle }}\n

\n\n \n

Certificate Details

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

Certificate ID	{{ $('Generate Certificate ID & QR').item.json.certificateId }}
CEUs Earned	{{ $('Webhook Trigger').item.json.body.CEUsEarned }} CEUs
Completion Date	\n {{ $('Webhook Trigger').item.json.body.completionDate.split(\"-\")[2] + \"/\" + \n $('Webhook Trigger').item.json.body.completionDate.split(\"-\")[1] + \"/\" + \n $('Webhook Trigger').item.json.body.completionDate.split(\"-\")[0] }}\n
Contact Hours	{{ $('Webhook Trigger').item.json.body.trainingHours \|\| \"—\" }}

\n\n \n

\n \n Download Your Certificate (PDF)\n \n

\n\n

\n Your certificate has been securely issued and is ready for printing or sharing.\n

\n\n \n

\n Issued on {{ $now.toFormat(\"MMMM d, yyyy\") }} • Certificate ID: {{ $('Generate Certificate ID & QR').item.json.certificateId }}
\n This is an automated message. Please do not reply.\n

", "options": { "appendAttribution": false }, "service": "gmail", "subject": "=✅ Your CEU Certificate - {{ $('Webhook Trigger').item.json.body.courseTitle }}", "operation": "read" }, "position": [ 2208, 256 ] } ] }

Generate verifiable CEU certificates with Google Workspace & QR verification