{ "edges": [ { "to": "c897caf3-b83b-46fd-9eb3-a73ea8b563a1", "from": "d6dd5889-309a-4f37-a55a-b4c80425baa2", "toPort": "0", "fromPort": "0" }, { "to": "01532eac-8645-4137-b17e-283a31800072", "from": "0df8d27a-411a-4e4b-be7b-d40ea8c78691", "toPort": "0", "fromPort": "0" }, { "to": "24b92189-7f95-46a8-a65b-426070b99316", "from": "d1630c9e-05c5-43ae-9370-e22a778d86d5", "toPort": "0", "fromPort": "0" }, { "to": "8b759709-dbea-4680-932d-4bffd248e037", "from": "d1630c9e-05c5-43ae-9370-e22a778d86d5", "toPort": "0", "fromPort": "0" }, { "to": "8f13df6c-3418-464d-b333-4ff900c2ebc0", "from": "d1630c9e-05c5-43ae-9370-e22a778d86d5", "toPort": "0", "fromPort": "0" }, { "to": "d2f63287-e0f0-41e2-bc7a-141a8fa05367", "from": "01532eac-8645-4137-b17e-283a31800072", "toPort": "0", "fromPort": "0" }, { "to": "31b44373-0af2-46d4-8b0b-6fd85824bd12", "from": "01532eac-8645-4137-b17e-283a31800072", "toPort": "0", "fromPort": "1" }, { "to": "0df8d27a-411a-4e4b-be7b-d40ea8c78691", "from": "c897caf3-b83b-46fd-9eb3-a73ea8b563a1", "toPort": "0", "fromPort": "0" }, { "to": "d1630c9e-05c5-43ae-9370-e22a778d86d5", "from": "d2f63287-e0f0-41e2-bc7a-141a8fa05367", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "c897caf3-b83b-46fd-9eb3-a73ea8b563a1", "name": "Set - Extract Form Data", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "4276ef9c-3abd-4b5b-8187-56ac307c5a13", "name": "visitorName", "type": "string", "value": "={{ $json.body[0]['Full Name'].first + ' ' + $json.body[0]['Full Name'].last }}" }, { "id": "5cb740d2-679e-4fc8-a6e1-264ee34ba06e", "name": "firstName", "type": "string", "value": "={{ $json.body[0]['Full Name'].first }}" }, { "id": "c99fe4bc-fdc9-4290-9e0d-429917a0606c", "name": "lastName", "type": "string", "value": "={{ $json.body[0]['Full Name'].last }}" }, { "id": "2b5e9fe9-cf86-4c9f-b85b-bb0a459c632d", "name": "visitorEmail", "type": "string", "value": "={{ $json.body[0].Email }}" }, { "id": "ec0336a1-0421-4a51-964d-2a85b245de0a", "name": "visitDate", "type": "string", "value": "={{ $json.body[0]['Visit Date '].year }}-{{ $json.body[0]['Visit Date '].month.padStart(2, '0') }}-{{ $json.body[0]['Visit Date '].day.padStart(2, '0') }}" }, { "id": "23e49d51-97c9-4ae7-b23c-73919c657d09", "name": "visitDateFormatted", "type": "string", "value": "={{ $json.body[0]['Visit Date '].month }}/{{ $json.body[0]['Visit Date '].day }}/{{ $json.body[0]['Visit Date '].year }}" }, { "id": "c89c6db2-c36e-4ead-a06f-35d1d892f367", "name": "purpose", "type": "string", "value": "={{ $json.body[0]['Purpose of Visit'] }}" }, { "id": "03695cab-73b4-4434-b12f-d1e73e2ad0fd", "name": "company", "type": "string", "value": "={{ $json.body[0]['Company/Organization'] }}" }, { "id": "090d4bce-785d-4197-8786-f256e90bdf1c", "name": " photoUrl", "type": "string", "value": "={{ $json.body[0][\"Profile Photo\"] }}" }, { "id": "001b90de-55f0-44fc-9e76-b86a667cac1d", "name": " submissionId", "type": "string", "value": "={{ $now.format('yyyyMMddHHmmss') }}" }, { "id": "72a3157b-8e06-4765-bb21-351b140c3e3e", "name": " timestamp", "type": "string", "value": "={{ $now.toISO() }}" } ] } }, "position": [ 192, 384 ] }, { "id": "01532eac-8645-4137-b17e-283a31800072", "name": "IF - Check Email Valid", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 1, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "email-valid-check", "operator": { "type": "boolean", "operation": "true", "singleValue": true }, "leftValue": "={{ $json.valid }}", "rightValue": "valid" } ] } }, "position": [ 944, 384 ] }, { "id": "d2f63287-e0f0-41e2-bc7a-141a8fa05367", "name": "Function - Generate Visitor ID & QR", "type": "code", "params": { "jsCode": "// Get visitor data from the Set node\nconst visitorData = $('Set - Extract Form Data').item.json;\n\n// Generate unique visitor ID\nconst timestamp = Date.now();\nconst dateStr = new Date().toISOString().split('T')[0].replace(/-/g, '');\nconst visitorId = `VIS-${dateStr}-${timestamp.toString().slice(-6)}`;\n\n// Create QR code data with all visitor information\nconst qrCodeData = JSON.stringify({\n id: visitorId,\n name: visitorData.visitorName,\n email: visitorData.visitorEmail,\n date: visitorData.visitDate,\n purpose: visitorData.purpose,\n company: visitorData.company,\n timestamp: new Date().toISOString(),\n verified: true\n});\n\n// Simple format for basic QR readers (alternative)\nconst qrCodeSimple = `VISITOR|${visitorId}|${visitorData.visitorName}|${visitorData.visitDate}|${visitorData.company}`;\n\n// Generate QR code image URL\nconst qrCodeUrl = `https://api.qrserver.com/v1/create-qr-code/?size=300x300&data=${encodeURIComponent(qrCodeSimple)}`;\n\n// Alternative high-quality QR code API\nconst qrCodeUrlAlt = `https://quickchart.io/qr?text=${encodeURIComponent(qrCodeSimple)}&size=300&margin=2`;\n\n// Return the generated data\nreturn {\n json: {\n visitorId: visitorId,\n qrCodeData: qrCodeData,\n qrCodeSimple: qrCodeSimple,\n qrCodeUrl: qrCodeUrl,\n qrCodeUrlAlt: qrCodeUrlAlt,\n generatedAt: new Date().toISOString()\n }\n};" }, "position": [ 1360, 288 ] }, { "id": "d1630c9e-05c5-43ae-9370-e22a778d86d5", "name": "HTML/CSS to Image", "type": "integration", "params": { "service": "htmlcsstoimage", "operation": "run", "html_content": "=\n\n\n\n\n\n\n

\n \n \n

\n $\"Visitor$ \n

✓

\n \n

ID: {{ $json.visitorId }}

\n \n

\n 📅\n

Visit Date

\n \n

\n 🎯\n

Purpose

\n \n

\n 🏢\n

Company

\n \n

Scan for Entry

\n $\"QR$ \n

\n \n \n

\n\n", "__originalType": "n8n-nodes-htmlcsstoimage.htmlCssToImage" }, "position": [ 1712, 288 ] }, { "id": "24b92189-7f95-46a8-a65b-426070b99316", "name": "Send a message1", "type": "integration", "params": { "sendTo": "={{ $('Set - Extract Form Data').item.json.visitorEmail }}", "message": "=\n\n\n\n\n\n

\n \n \n

Dear {{ $('Set - Extract Form Data').item.json.visitorName }},

\n \n

Great news! Your visitor pass has been verified and is now ready to use. We look forward to welcoming you to our space.

\n \n

📋 Your Visit Details

\n Visitor ID:\n {{ $('Function - Generate Visitor ID & QR').item.json.visitorId }}\n

\n Visit Date:\n {{ $('Set - Extract Form Data').item.json.visitDateFormatted }}\n

\n Purpose:\n {{ $('Set - Extract Form Data').item.json.purpose }}\n

\n Company:\n {{ $('Set - Extract Form Data').item.json.company }}\n

\n \n

Your Digital Visitor Pass

\n $\"Your$ \n

Please save this pass or show this email at reception

\n \n

📱 How to Use Your Pass

Digital: Show this email on your phone at reception
QR Code: Our staff will scan your QR code for instant verification
ID Check: Please bring a valid photo ID for security purposes
Arrival: Check in at the reception desk on arrival

\n \n

🏢 Location & Arrival

Address: MediaJade Coworking, 123 Business Street

Reception Hours: Monday-Friday, 8:00 AM - 6:00 PM

Contact: +1 (555) 123-4567

\n \n

Need to make changes? Please contact our reception team at least 24 hours before your visit.

\n \n

We're excited to host you!

\n \n

Best regards,
\n Reception Team
\n MediaJade Coworking Space

\n \n \n

\n\n", "options": {}, "service": "gmail", "subject": "=🎫 Your Verified Visitor Pass - {{ $('Set - Extract Form Data').item.json.visitDateFormatted }}", "operation": "read" }, "position": [ 2208, 0 ] }, { "id": "8b759709-dbea-4680-932d-4bffd248e037", "name": "Slack - Notify Security Team", "type": "integration", "params": { "text": "=🟢 *New Verified Visitor*\n\n👤 *Name:* {{ $('Set - Extract Form Data').item.json.visitorName }}\n📧 *Email:* {{ $('Set - Extract Form Data').item.json.visitorEmail }}\n📅 *Visit Date:* {{ $('Set - Extract Form Data').item.json.visitDate }}\n🎯 *Purpose:* {{ $('Set - Extract Form Data').item.json.purpose }}\n🏢 *Company:* {{ $('Set - Extract Form Data').item.json.company }}\n🆔 *Visitor ID:* {{ $('Function - Generate Visitor ID & QR').item.json.visitorId }}\n✅ *Status:* Email Verified & Pass Sent\n⏰ *Submitted:* {{ $('Set - Extract Form Data').item.json[' timestamp'] }}\n\n📎 Badge Image: {{ $json.image_url }}", "select": "channel", "service": "slack", "channelId": { "__rl": true, "mode": "list", "value": "YOUR SLACK CHANNEL ID", "cachedResultName": "YOUR SLACK CHANNEL NAME" }, "operation": "read", "otherOptions": {} }, "position": [ 2320, 288 ] }, { "id": "8f13df6c-3418-464d-b333-4ff900c2ebc0", "name": "Google Sheets - Log Visitor", "type": "integration", "params": { "columns": { "value": { "Email": "={{ $('Set - Extract Form Data').item.json.visitorEmail }}", "Status": "Pass Sent", "Company": "={{ $('Set - Extract Form Data').item.json.company }}", "Purpose": "={{ $('Set - Extract Form Data').item.json.purpose }}", "Full Name": "={{ $('Set - Extract Form Data').item.json.visitorName }}", "Timestamp": "={{ $('Set - Extract Form Data').item.json[\" timestamp\"] }}", "Visit Date": "={{ $('Set - Extract Form Data').item.json.visitDate }}", "Visitor ID": "={{ $('Function - Generate Visitor ID & QR').item.json.visitorId }}", "Email Verified": "Yes", "Badge Image URL": "={{ $json.image_url }}" }, "schema": [ { "id": "Timestamp", "type": "string", "display": true, "required": false, "displayName": "Timestamp", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Visitor ID", "type": "string", "display": true, "required": false, "displayName": "Visitor ID", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Full Name", "type": "string", "display": true, "required": false, "displayName": "Full Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Email", "type": "string", "display": true, "required": false, "displayName": "Email", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Visit Date", "type": "string", "display": true, "required": false, "displayName": "Visit Date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Purpose", "type": "string", "display": true, "required": false, "displayName": "Purpose", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Company", "type": "string", "display": true, "required": false, "displayName": "Company", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Email Verified", "type": "string", "display": true, "required": false, "displayName": "Email Verified", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Badge Image URL", "type": "string", "display": true, "required": false, "displayName": "Badge Image URL", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Status", "type": "string", "display": true, "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", "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": [ 2224, 560 ] }, { "id": "0df8d27a-411a-4e4b-be7b-d40ea8c78691", "name": "Verifi Email", "type": "integration", "params": { "email": "={{ $json.visitorEmail }}", "service": "verifiemail", "operation": "run", "__originalType": "n8n-nodes-verifiemail.verifiEmail" }, "position": [ 592, 384 ] }, { "id": "d6dd5889-309a-4f37-a55a-b4c80425baa2", "name": "Webhook", "type": "trigger", "params": { "kind": "n8n-nodes-base.webhook", "path": "visitor-registration", "options": {}, "httpMethod": "POST" }, "position": [ -224, 384 ] }, { "id": "31b44373-0af2-46d4-8b0b-6fd85824bd12", "name": "Stop and Error", "type": "passthrough", "params": { "mode": "noOp", "errorMessage": "Invalid Email" }, "position": [ 1360, 528 ] } ] }

✅ Visitor Pass Verified & Issued

📋 Your Visit Details

Your Digital Visitor Pass

📱 How to Use Your Pass

🏢 Location & Arrival

Automate verified visitor management with email verification, badges & Slack alerts