{ "edges": [ { "to": "5e7bec79-8951-4388-890c-73e37a6ef8b2", "from": "1eb2b648-b557-42f1-aed5-d6b3f5b6419e", "toPort": "0", "fromPort": "0" }, { "to": "ff60e9dc-464e-4b54-8bbd-1e90874436d5", "from": "5b63e21f-3504-4081-8422-800bda3803b5", "toPort": "0", "fromPort": "0" }, { "to": "96b09356-225b-41dd-8684-b003df5b7f1c", "from": "d7504f9f-ee7e-41b0-8ec3-28acf6b139be", "toPort": "0", "fromPort": "0" }, { "to": "1eb2b648-b557-42f1-aed5-d6b3f5b6419e", "from": "de18b560-5a30-4b26-998f-a701590b4e9d", "toPort": "1", "fromPort": "0" }, { "to": "de18b560-5a30-4b26-998f-a701590b4e9d", "from": "0d26d3cd-509b-4f95-b188-00d41bb17e3c", "toPort": "0", "fromPort": "0" }, { "to": "1eb2b648-b557-42f1-aed5-d6b3f5b6419e", "from": "0d26d3cd-509b-4f95-b188-00d41bb17e3c", "toPort": "0", "fromPort": "0" }, { "to": "d7504f9f-ee7e-41b0-8ec3-28acf6b139be", "from": "ff60e9dc-464e-4b54-8bbd-1e90874436d5", "toPort": "0", "fromPort": "0" }, { "to": "1e9a2800-bab2-47f2-8fff-5f52f0d3e903", "from": "5e7bec79-8951-4388-890c-73e37a6ef8b2", "toPort": "0", "fromPort": "0" }, { "to": "4c34e01e-c47f-4879-a79b-f358b4e774e6", "from": "5e7bec79-8951-4388-890c-73e37a6ef8b2", "toPort": "0", "fromPort": "1" }, { "to": "f8ec0f94-b7c6-43c8-8598-7cb5e324b523", "from": "96b09356-225b-41dd-8684-b003df5b7f1c", "toPort": "0", "fromPort": "0" }, { "to": "5b63e21f-3504-4081-8422-800bda3803b5", "from": "1e9a2800-bab2-47f2-8fff-5f52f0d3e903", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "5e7bec79-8951-4388-890c-73e37a6ef8b2", "name": "IF - Email Valid?", "type": "if", "params": { "conditions": { "boolean": [ { "value1": "={{ $json.valid }}", "value2": "={{ true }}" } ] } }, "position": [ 560, 560 ] }, { "id": "1e9a2800-bab2-47f2-8fff-5f52f0d3e903", "name": "Prepare Certificate Data", "type": "code", "params": { "jsCode": "// Get current item (merged data)\nconst data = $input.first().json;\n\n// Build full name\nconst fullName = `${data[\"Full Name\"].first} ${data[\"Full Name\"].last}`.trim();\n\n// Format date\nconst dateObj = data[\"Select Workshop Date\"];\nconst displayDate = new Date(`${dateObj.year}-${dateObj.month}-${dateObj.day}`).toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'long',\n day: 'numeric'\n});\n\n// QR Code URL\nconst verificationUrl = `https://your-domain.com/verify?email=${encodeURIComponent(data.Email)}&event=${encodeURIComponent(data[\"Select Workshop\"])}`;\n\n// Unique Certificate ID\nconst certificateId = `CERT-${Date.now().toString(36).toUpperCase()}-${Math.random().toString(36).substr(2, 5).toUpperCase()}`;\n\n// Return clean data for HTML\nreturn [\n {\n json: {\n name: fullName,\n email: data.Email,\n event: data[\"Select Workshop\"],\n date: displayDate,\n qrCodeUrl: `https://api.qrserver.com/v1/create-qr-code/?data=${encodeURIComponent(verificationUrl)}&size=200x200&margin=10`,\n verificationUrl: verificationUrl,\n certificateId: certificateId,\n verifiedAt: new Date().toISOString(),\n emailProvider: data.details?.mx?.provider || \"Unknown\",\n isValid: data.valid\n }\n }\n];" }, "position": [ 880, 368 ] }, { "id": "ff60e9dc-464e-4b54-8bbd-1e90874436d5", "name": "Download PDF File", "type": "http", "params": { "url": "={{ $json.pdf_url }}", "options": { "response": { "response": { "responseFormat": "file", "outputPropertyName": "pdfData" } } } }, "position": [ 1536, 368 ] }, { "id": "f8ec0f94-b7c6-43c8-8598-7cb5e324b523", "name": "Send Confirmation Email", "type": "integration", "params": { "sendTo": "={{ $('Prepare Certificate Data').item.json.email }}", "message": "=\n\n\n \n \n\n\n

\n \n

Hi {{ $json['Full Name'] }},

Congratulations! Your registration for:

\n {{ $json.Workshop }}
\n {{ $json.Date }}\n

has been verified and confirmed.

\n\n

\n $\"QR$ \n

Scan on event day for instant check-in

\n\n

Certificate ID: {{ $json['Certificate ID'] }}

Verified Email: {{ $json.Email }}

\n\n

Your official pre-issued certificate is attached as a PDF.

\n\n \n View Certificate Online\n \n

\n \n

\n\n", "options": {}, "service": "gmail", "subject": "=🎉 Your Workshop Seat is Confirmed - {{ $('Prepare Certificate Data').item.json.event }}", "operation": "read" }, "position": [ 2464, 368 ] }, { "id": "96b09356-225b-41dd-8684-b003df5b7f1c", "name": "Log to Google Sheets", "type": "integration", "params": { "columns": { "value": { "Date": "={{ $('Prepare Certificate Data').item.json.date }}", "Email": "={{ $('Prepare Certificate Data').item.json.email }}", "PDF Link": "={{ $json.webViewLink }}", "Workshop": "={{ $('Prepare Certificate Data').item.json.event }}", "Full Name": "={{ $('Prepare Certificate Data').item.json.name }}", "Timestamp": "={{ new Date().toISOString() }}", "QR Code URL": "={{ $('Prepare Certificate Data').item.json.qrCodeUrl }}", "Verified At": "={{ $json.createdTime }}", "Certificate ID": "={{ $('Prepare Certificate Data').item.json.certificateId }}" }, "schema": [ { "id": "Timestamp", "type": "string", "display": true, "required": false, "displayName": "Timestamp", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Full Name", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Full Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Email", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Email", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Workshop", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Workshop", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Date", "type": "string", "display": true, "required": false, "displayName": "Date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Certificate ID", "type": "string", "display": true, "required": false, "displayName": "Certificate ID", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "QR Code URL", "type": "string", "display": true, "removed": false, "required": false, "displayName": "QR Code URL", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "PDF Link", "type": "string", "display": true, "removed": false, "required": false, "displayName": "PDF Link", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Verified At", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Verified At", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [ "Email" ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "appendOrUpdate", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEETS_DOCUMENT_ID/edit#gid=0", "cachedResultName": "Sheet1" }, "documentId": { "__rl": true, "mode": "list", "value": "YOUR_GOOGLE_SHEETS_DOCUMENT_ID", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEETS_DOCUMENT_ID/edit?usp=drivesdk", "cachedResultName": "Workshop Registrations & Certificates" } }, "position": [ 2176, 368 ] }, { "id": "4c34e01e-c47f-4879-a79b-f358b4e774e6", "name": "Log Failed Registrations", "type": "integration", "params": { "columns": { "value": { "Date": "={{ new Date(\n $json[\"Select Workshop Date\"].year + '-' +\n String($json[\"Select Workshop Date\"].month).padStart(2, '0') + '-' +\n String($json[\"Select Workshop Date\"].day).padStart(2, '0')\n).toLocaleDateString('en-US', { year: 'numeric', month: 'long', day: 'numeric' }) }}", "Email": "={{ $json.Email }}", "Status": "Invalid Email", "PDF Link": "Invalid Email", "Workshop": "={{ $json[\"Select Workshop\"] }}", "Full Name": "={{ $json['Full Name'].first + ' ' + $json['Full Name'].last }}", "Timestamp": "={{ $now }}", "QR Code URL": "Invalid Email", "Verified At": "Invalid Email", "Certificate ID": "Invalid Email" }, "schema": [ { "id": "Timestamp", "type": "string", "display": true, "required": false, "displayName": "Timestamp", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Full Name", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Full Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Email", "type": "string", "display": true, "required": false, "displayName": "Email", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Workshop", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Workshop", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Date", "type": "string", "display": true, "required": false, "displayName": "Date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Certificate ID", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Certificate ID", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "QR Code URL", "type": "string", "display": true, "removed": false, "required": false, "displayName": "QR Code URL", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "PDF Link", "type": "string", "display": true, "removed": false, "required": false, "displayName": "PDF Link", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Status", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Status", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Verified At", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Verified At", "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_GOOGLE_SHEETS_DOCUMENT_ID/edit#gid=0", "cachedResultName": "Sheet1" }, "documentId": { "__rl": true, "mode": "list", "value": "YOUR_GOOGLE_SHEETS_DOCUMENT_ID", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEETS_DOCUMENT_ID/edit?usp=drivesdk", "cachedResultName": "Workshop Registrations & Certificates" } }, "position": [ 880, 736 ] }, { "id": "0d26d3cd-509b-4f95-b188-00d41bb17e3c", "name": "JotForm Trigger", "type": "integration", "params": { "form": "YOUR_JOTFORM_FORM_ID", "service": "jotformtrigger", "operation": "run", "__originalType": "n8n-nodes-base.jotFormTrigger" }, "position": [ -224, 544 ] }, { "id": "de18b560-5a30-4b26-998f-a701590b4e9d", "name": "Verifi Email", "type": "integration", "params": { "email": "={{ $json.Email }}", "service": "verifiemail", "operation": "run", "__originalType": "n8n-nodes-verifiemail.verifiEmail" }, "position": [ 0, 752 ] }, { "id": "1eb2b648-b557-42f1-aed5-d6b3f5b6419e", "name": "Merge", "type": "merge", "params": { "mode": "combine", "options": {}, "combineBy": "combineByPosition" }, "position": [ 288, 560 ] }, { "id": "5b63e21f-3504-4081-8422-800bda3803b5", "name": "HTML to PDF", "type": "integration", "params": { "service": "htmlcsstopdf", "operation": "run", "html_content": "=

Certificate of Confirmation

This certifies that

\n \n

has successfully registered for

\n \n

Date: {{ $json.date }}

\n \n

\n $\"QR$ \n

\n \n

\n Certificate ID: {{ $json.certificateId }}
\n Verified Email: {{ $json.email }} ({{ $json.emailProvider }})
\n Scan QR code on event day for instant check-in\n

\n \n

\n Issued: {{ new Date().toLocaleDateString() }} • Powered by n8n Automation\n

", "__originalType": "n8n-nodes-htmlcsstopdf.htmlcsstopdf" }, "position": [ 1200, 368 ] }, { "id": "d7504f9f-ee7e-41b0-8ec3-28acf6b139be", "name": "Upload file", "type": "integration", "params": { "name": "=Confirmed_Attendee_{{ $('Prepare Certificate Data').item.json.name }}_{{ $('Prepare Certificate Data').item.json.date }}.pdf", "driveId": { "__rl": true, "mode": "list", "value": "My Drive", "cachedResultUrl": "https://drive.google.com/drive/my-drive", "cachedResultName": "My Drive" }, "options": {}, "service": "googleDrive", "folderId": { "__rl": true, "mode": "list", "value": "YOUR_GOOGLE_DRIVE_FOLDER_ID", "cachedResultUrl": "https://drive.google.com/drive/folders/YOUR_GOOGLE_DRIVE_FOLDER_ID", "cachedResultName": "Attendee Data" }, "operation": "read", "inputDataFieldName": "pdfData" }, "position": [ 1856, 368 ] } ] }

Workshop Confirmation

Certificate of Confirmation

{{ $json.name }}

{{ $json.event }}

Automated workshop certificate system with JotForm, email verification & Google Workspace