{ "edges": [ { "to": "e3691717-b6e1-4acd-ae86-7404e72f7838", "from": "aa630c39-7f85-4808-994b-68c9e3cf03c5", "toPort": "0", "fromPort": "0" }, { "to": "aa630c39-7f85-4808-994b-68c9e3cf03c5", "from": "76062a36-1028-4114-ad51-9df9cfae01d5", "toPort": "0", "fromPort": "0" }, { "to": "e2307c7b-b3ac-4b97-8681-c7fe9e552c5c", "from": "e3691717-b6e1-4acd-ae86-7404e72f7838", "toPort": "0", "fromPort": "0" }, { "to": "852aa684-8b5c-4696-ba24-980bb5a0559b", "from": "863ba140-aacf-4f58-99f3-bf99e7012088", "toPort": "0", "fromPort": "0" }, { "to": "9ec8e2c7-14fa-499d-b359-103dbb86566f", "from": "852aa684-8b5c-4696-ba24-980bb5a0559b", "toPort": "0", "fromPort": "0" }, { "to": "76062a36-1028-4114-ad51-9df9cfae01d5", "from": "9ec8e2c7-14fa-499d-b359-103dbb86566f", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "852aa684-8b5c-4696-ba24-980bb5a0559b", "name": "Make Copy of Template", "type": "integration", "params": { "name": "=eTicket for {{ $json.TIKET }}", "fileId": { "__rl": true, "mode": "list", "value": "1XHUxOVyYThuCU_cNk2ArmfGQt_EZ0O2iJQMROs8aMgo", "cachedResultUrl": "https://docs.google.com/document/d/1XHUxOVyYThuCU_cNk2ArmfGQt_EZ0O2iJQMROs8aMgo/edit?usp=drivesdk", "cachedResultName": "QR Test" }, "options": {}, "service": "googleDrive", "operation": "copy" }, "position": [ 352, 208 ] }, { "id": "9ec8e2c7-14fa-499d-b359-103dbb86566f", "name": "Change Custom Variables", "type": "integration", "params": { "service": "googleDocs", "actionsUi": { "actionFields": [ { "text": "{kode_qr}", "action": "replaceAll", "replaceText": "={{ $('Google Sheets Trigger').item.json.TIKET }}" } ] }, "operation": "update", "documentURL": "={{ $json.id }}" }, "position": [ 656, 208 ] }, { "id": "aa630c39-7f85-4808-994b-68c9e3cf03c5", "name": "Generate PDF", "type": "integration", "params": { "fileId": { "__rl": true, "mode": "id", "value": "={{ $('Change Custom Variables').item.json.documentId }}" }, "options": { "binaryPropertyName": "data", "googleFileConversion": { "conversion": { "docsToFormat": "application/pdf" } } }, "service": "googleDrive", "operation": "download" }, "position": [ 1184, 208 ] }, { "id": "e3691717-b6e1-4acd-ae86-7404e72f7838", "name": "Add PDF To Drive", "type": "integration", "params": { "name": "={{ $('Make Copy of Template').item.json.name }}", "driveId": { "__rl": true, "mode": "list", "value": "My Drive" }, "options": {}, "service": "googleDrive", "folderId": { "__rl": true, "mode": "list", "value": "1tOSzgdJn5x_-GAsqWgCU3isD-4UHQ7rB", "cachedResultUrl": "https://drive.google.com/drive/folders/1tOSzgdJn5x_-GAsqWgCU3isD-4UHQ7rB", "cachedResultName": "eTicket" }, "operation": "read" }, "position": [ 1376, 208 ] }, { "id": "863ba140-aacf-4f58-99f3-bf99e7012088", "name": "Google Sheets Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.googleSheetsTrigger", "options": {}, "pollTimes": { "item": [ { "mode": "everyMinute" } ] }, "sheetName": { "__rl": true, "mode": "list", "value": 474533520, "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-4gs1e_OqrbioOlLfLyBi-8ERyR09NhMxYP9P8nNfLI/edit#gid=474533520", "cachedResultName": "QR Code Data" }, "documentId": { "__rl": true, "mode": "list", "value": "1-4gs1e_OqrbioOlLfLyBi-8ERyR09NhMxYP9P8nNfLI", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-4gs1e_OqrbioOlLfLyBi-8ERyR09NhMxYP9P8nNfLI/edit?usp=drivesdk", "cachedResultName": "Salinan dari QR Codes" } }, "position": [ 64, 208 ] }, { "id": "76062a36-1028-4114-ad51-9df9cfae01d5", "name": "Insert image", "type": "http", "params": { "url": "=https://docs.googleapis.com/v1/documents/{{$json.documentId}}:batchUpdate", "method": "POST", "options": { "response": { "response": { "fullResponse": true, "responseFormat": "text" } } }, "sendBody": true, "authentication": "predefinedCredentialType", "bodyParameters": { "parameters": [ { "name": "requests", "value": "={{ [{ \"insertInlineImage\": { \"uri\": \"https://quickchart.io/qr?format=png&text=$('Google Sheets Trigger').item.json.TIKET\", \"location\": { \"segmentId\": \"\", \"index\": 27 } } }] }}" } ] }, "nodeCredentialType": "googleDocsOAuth2Api" }, "position": [ 896, 208 ] }, { "id": "e2307c7b-b3ac-4b97-8681-c7fe9e552c5c", "name": "Send an Email", "type": "integration", "params": { "html": "=\n\n\n\n\n\n\n

\n \n \n

Hi {{ $('Google Sheets Trigger').item.json.NAMA }},

\n \n

Thank you for registering for our upcoming event! We are thrilled to have you on board.

\n \n

Your official e-Ticket has been successfully generated. You can find your unique Ticket ID below:

\n \n

\n Ticket ID: {{ $('Google Sheets Trigger').item.json.TIKET }}\n

\n \n

For your convenience, we have attached a PDF version of your e-Ticket to this email. Please download and save it to your device, and simply show the QR code at the check-in desk on the day of the event.

\n \n

\n Download e-Ticket PDF\n

\n \n

If you have any questions, feel free to reply to this email.

See you at the event!

\n \n

Best regards,
\n The Event Team

\n \n \n

\n\n", "options": {}, "service": "smtp", "subject": "e-Ticket Resmi Anda untuk Event [Nama Event] 🎟️", "toEmail": "={{ $('Google Sheets Trigger').item.json.Email }}", "fromEmail": "user@example.com", "operation": "read" }, "position": [ 1584, 208 ] } ] }

Your Event e-Ticket 🎟️

Generate and email event e-tickets with QR codes using Google Workspace