Certificate of Completion

{ "edges": [ { "to": "b57d3884-9846-4b1f-9b00-ec378ea386ac", "from": "646e0a7b-2cdc-48c0-8f15-5b7755e9e484", "toPort": "0", "fromPort": "0" }, { "to": "9b7e5242-b3da-4552-b088-d585ffe7bcb0", "from": "646e0a7b-2cdc-48c0-8f15-5b7755e9e484", "toPort": "0", "fromPort": "1" }, { "to": "646e0a7b-2cdc-48c0-8f15-5b7755e9e484", "from": "de9c267d-d005-43d4-bbb3-c33370f9493a", "toPort": "0", "fromPort": "0" }, { "to": "7acdd47b-7014-4e0f-8b44-5acf326412be", "from": "b9b4ba6f-35ca-4733-9d0a-0e2a7da5b56e", "toPort": "0", "fromPort": "0" }, { "to": "e3cc736c-3a91-42d5-9037-5ffcad3e8cab", "from": "429a6ac5-d269-4176-ac81-d65117df54dd", "toPort": "0", "fromPort": "0" }, { "to": "d2f582b7-9d23-43b9-bc05-e50f96ad122f", "from": "b57d3884-9846-4b1f-9b00-ec378ea386ac", "toPort": "0", "fromPort": "0" }, { "to": "c1ec5078-2bc7-4f7d-b413-fa0ca7691a15", "from": "e3cc736c-3a91-42d5-9037-5ffcad3e8cab", "toPort": "0", "fromPort": "0" }, { "to": "37b407ee-9362-402a-b708-5c821e1e1116", "from": "7acdd47b-7014-4e0f-8b44-5acf326412be", "toPort": "0", "fromPort": "0" }, { "to": "b9b4ba6f-35ca-4733-9d0a-0e2a7da5b56e", "from": "d2f582b7-9d23-43b9-bc05-e50f96ad122f", "toPort": "0", "fromPort": "0" }, { "to": "de9c267d-d005-43d4-bbb3-c33370f9493a", "from": "a8b8e036-c01d-4091-b817-43611a1e2643", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "a8b8e036-c01d-4091-b817-43611a1e2643", "name": "Certificate Request Webhook", "type": "trigger", "params": { "kind": "n8n-nodes-base.webhook", "path": "certificate-generator", "options": {}, "httpMethod": "POST", "responseMode": "lastNode" }, "position": [ -2192, 544 ] }, { "id": "d2f582b7-9d23-43b9-bc05-e50f96ad122f", "name": "Generate HTML Certificate", "type": "code", "params": { "jsCode": "// Certificate HTML Generator\nconst items = $input.all();\n\nreturn items.map(item => {\n const data = item.json;\n \n // Generate unique certificate ID if not provided\n const certId = data.certificateId || `CERT-${Date.now()}-${Math.random().toString(36).substr(2, 9).toUpperCase()}`;\n \n // Format date nicely\n const certDate = new Date(data.date).toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'long',\n day: 'numeric'\n });\n \n // HTML Template with inline CSS\n const htmlContent = `\n\n\n\n \n \n Certificate of Completion\n \n\n\n

\n \n \n \n

${data.name}

\n \n

\n has successfully completed the course\n

\n \n

${data.course}

\n \n ${data.duration ? `

Duration: ${data.duration}

` : ''}\n

\n \n \n \n

Certificate ID: ${certId}

\n\n\n `;\n \n return {\n json: {\n ...data,\n certificateId: certId,\n html: htmlContent,\n formattedDate: certDate\n }\n };\n});" }, "position": [ -640, 528 ] }, { "id": "7acdd47b-7014-4e0f-8b44-5acf326412be", "name": "Send Certificate Email", "type": "integration", "params": { "sendTo": "={{ $('Code in JavaScript').item.json.email }}", "message": "=\n\n\n \n\n\n

\n \n \n

We're thrilled to celebrate your achievement! You have successfully completed:

\n \n

Completion Date: {{ $('Generate HTML Certificate').item.json.formattedDate }}

\n \n

Your certificate is ready and available for download. Share your accomplishment with your professional network!

\n \n

\n 📥 Download Certificate\n

\n \n

📋 Certificate Details:

Certificate ID:{{ $('Generate HTML Certificate').item.json.certificateId }}
Recipient:{{ $('Generate HTML Certificate').item.json.name }}
Course: {{ $('Generate HTML Certificate').item.json.course }}
Completion Date: {{ $('Generate HTML Certificate').item.json.formattedDate }}
Duration: ' + $json.duration + '
Instructor: ' + $json.instructor + '

\n \n

💼 Share Your Success:

Don't forget to add this certificate to your LinkedIn profile and share it with your network to showcase your new skills!

\n \n

If you have any questions about your certificate, please don't hesitate to reach out to our support team.

\n \n \n

\n\n", "options": {}, "service": "gmail", "subject": "🎓 Congratulations! Your Certificate of Completion", "operation": "read" }, "position": [ 288, 528 ] }, { "id": "37b407ee-9362-402a-b708-5c821e1e1116", "name": "Log to Google Sheets", "type": "integration", "params": { "columns": { "value": { "Email": "={{ $('Generate HTML Certificate').item.json.email }}", "Course": "={{ $('Generate HTML Certificate').item.json.course }}", "Status": "Sent", "Duration": "={{ $('Generate HTML Certificate').item.json.duration }}", "Instructor": "={{ $('Generate HTML Certificate').item.json.instructor }}", "Generated At": "={{ $now.toISO() }}", "Certificate ID": "={{ $('Generate HTML Certificate').item.json.certificateId }}", "Recipient Name": "={{ $('Generate HTML Certificate').item.json.name }}", "Certificate URL": "={{ $('HTML/CSS to Image').item.json.image_url }}", "Completion Date ": "={{ $('Generate HTML Certificate').item.json.date }}" }, "schema": [ { "id": "Certificate ID", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Certificate ID", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Recipient Name", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Recipient Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Course", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Course", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Email", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Email", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Completion Date ", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Completion Date ", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Generated At", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Generated At", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Certificate URL", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Certificate URL", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Status", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Status", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Instructor", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Instructor", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Duration", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Duration", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [ "Certificate ID" ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "appendOrUpdate", "sheetName": { "__rl": true, "mode": "list", "value": "", "cachedResultUrl": "", "cachedResultName": "Sheet1" }, "documentId": { "__rl": true, "mode": "list", "value": "", "cachedResultUrl": "", "cachedResultName": "Certificates Log" } }, "position": [ 752, 528 ] }, { "id": "429a6ac5-d269-4176-ac81-d65117df54dd", "name": "On Workflow Error", "type": "trigger", "params": { "kind": "n8n-nodes-base.errorTrigger" }, "position": [ -1680, 1216 ] }, { "id": "e3cc736c-3a91-42d5-9037-5ffcad3e8cab", "name": "Format Error Details", "type": "code", "params": { "jsCode": "// Extract error information\nconst errorData = $input.first().json;\n\nreturn [{\n json: {\n errorMessage: errorData.error?.message || 'Unknown error occurred',\n errorNode: errorData.node?.name || 'Unknown node',\n timestamp: new Date().toISOString(),\n workflowId: $workflow.id,\n workflowName: $workflow.name,\n executionId: $execution.id,\n userData: {\n name: errorData.json?.name || 'N/A',\n email: errorData.json?.email || 'N/A',\n course: errorData.json?.course || 'N/A'\n },\n fullError: JSON.stringify(errorData, null, 2)\n }\n}];" }, "position": [ -1472, 1216 ] }, { "id": "c1ec5078-2bc7-4f7d-b413-fa0ca7691a15", "name": "Send Slack Alert", "type": "integration", "params": { "text": "=🚨 **Certificate Generation Failed**\n\n**Error:** {{ $json.errorMessage }}\n**Node:** {{ $json.errorNode }}\n**Time:** {{ $json.timestamp }}\n\n**User Details:**\n• Name: {{ $json.userData.name }}\n• Email: {{ $json.userData.email }}\n• Course: {{ $json.userData.course }}\n\n**Execution ID:** {{ $json.executionId }}\n**Workflow:** {{ $json.workflowName }}", "select": "channel", "service": "slack", "channelId": { "__rl": true, "mode": "list", "value": "C12345", "cachedResultName": "alerts" }, "operation": "read", "otherOptions": {} }, "position": [ -1280, 1216 ] }, { "id": "b9b4ba6f-35ca-4733-9d0a-0e2a7da5b56e", "name": "HTML/CSS to Image", "type": "integration", "params": { "service": "htmlcsstoimage", "operation": "run", "html_content": "={{ $json.html }}", "__originalType": "n8n-nodes-htmlcsstoimage.htmlCssToImage" }, "position": [ -160, 528 ] }, { "id": "de9c267d-d005-43d4-bbb3-c33370f9493a", "name": "Verifi Email", "type": "integration", "params": { "email": "={{ $json.body.email }}", "service": "verifiemail", "operation": "run", "__originalType": "n8n-nodes-verifiemail.verifiEmail" }, "position": [ -1872, 544 ] }, { "id": "646e0a7b-2cdc-48c0-8f15-5b7755e9e484", "name": "If", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "a39497f8-8b8a-4b3a-bc5f-3e8738fa4cbb", "operator": { "type": "string", "operation": "notEmpty", "singleValue": true }, "leftValue": "={{ $('Certificate Request Webhook').item.json.body.name }}", "rightValue": "" }, { "id": "37e0295c-18b2-4d3f-998b-e9d669dd90f7", "operator": { "type": "string", "operation": "notEmpty", "singleValue": true }, "leftValue": "={{ $('Certificate Request Webhook').item.json.body.course }}", "rightValue": "" }, { "id": "6ecb1197-b460-402e-99a1-00edb0d5150c", "operator": { "type": "string", "operation": "notEmpty", "singleValue": true }, "leftValue": "={{ $('Certificate Request Webhook').item.json.body.date }}", "rightValue": "" }, { "id": "3828fe0a-7c6a-449a-b380-c754717e0731", "operator": { "type": "boolean", "operation": "true", "singleValue": true }, "leftValue": "={{ $json.valid }}", "rightValue": "" } ] } }, "position": [ -1392, 544 ] }, { "id": "9b7e5242-b3da-4552-b088-d585ffe7bcb0", "name": "Stop and Error", "type": "passthrough", "params": { "mode": "noOp", "errorMessage": "=\"Missing required fields: name, course, date, or valid email\"" }, "position": [ -1040, 784 ] }, { "id": "b57d3884-9846-4b1f-9b00-ec378ea386ac", "name": "Code in JavaScript", "type": "code", "params": { "jsCode": "// Combine Webhook Data with Email Validation\n// Get the current item (from IF node - email validation data)\nconst emailData = $input.item.json;\n\n// Get the original webhook data from the first node\nconst webhookData = $('Certificate Request Webhook').first().json.body;\n\n// Combine everything\nreturn {\n json: {\n // Certificate data from webhook\n name: webhookData.name,\n course: webhookData.course,\n date: webhookData.date,\n email: webhookData.email,\n instructor: webhookData.instructor || 'Program Director',\n duration: webhookData.duration || '',\n certificateId: webhookData.certificateId || '',\n \n // Email validation results (optional - for logging/debugging)\n emailValidation: {\n valid: emailData.valid,\n provider: emailData.details.mx.provider,\n rfcCompliant: emailData.details.rfcCompliant,\n validMxRecord: emailData.details.validMxRecord,\n disposable: emailData.details.disposable\n }\n }\n};" }, "position": [ -1056, 528 ] } ] }

Certificate of Completion

🎉 Congratulations, {{ $('Generate HTML Certificate').item.json.name }} !

{{ $('Generate HTML Certificate').item.json.course }}

Generate & deliver certificates with VerifiEmail & HTMLcsstoImg to Gmail