{ "edges": [ { "to": "08598641-28bd-4baa-8c6b-021e5c1485e7", "from": "14b280e9-b95d-4fba-8990-be9881a950fd", "toPort": "0", "fromPort": "0" }, { "to": "d31e2c79-a934-4e43-a867-8698907d28c5", "from": "08598641-28bd-4baa-8c6b-021e5c1485e7", "toPort": "0", "fromPort": "0" }, { "to": "d31e2c79-a934-4e43-a867-8698907d28c5", "from": "43d185ba-e4ea-4abe-b86d-b9d1045e4830", "toPort": "0", "fromPort": "0" }, { "to": "616681e9-bf9d-4713-913f-b84ddeee1d1f", "from": "4f13e912-7e8f-4e4f-9295-9535bcd9ed40", "toPort": "0", "fromPort": "0" }, { "to": "c3db4aa9-ff10-4054-81bb-232bb7c874cd", "from": "4f13e912-7e8f-4e4f-9295-9535bcd9ed40", "toPort": "0", "fromPort": "0" }, { "to": "14b280e9-b95d-4fba-8990-be9881a950fd", "from": "c3db4aa9-ff10-4054-81bb-232bb7c874cd", "toPort": "0", "fromPort": "0" }, { "to": "14b280e9-b95d-4fba-8990-be9881a950fd", "from": "b8e5e740-7d8c-4293-b39d-d119c6aad242", "toPort": "1", "fromPort": "0" }, { "to": "b8e5e740-7d8c-4293-b39d-d119c6aad242", "from": "57962326-14e2-49bb-b46e-40ada76f8d99", "toPort": "0", "fromPort": "0" }, { "to": "57962326-14e2-49bb-b46e-40ada76f8d99", "from": "616681e9-bf9d-4713-913f-b84ddeee1d1f", "toPort": "0", "fromPort": "0" }, { "to": "60648c15-95db-48b4-9eee-3b1666285bfc", "from": "2f920ad0-869f-425f-93cc-ef74b7e4323d", "toPort": "0", "fromPort": "0" }, { "to": "2f920ad0-869f-425f-93cc-ef74b7e4323d", "from": "d31e2c79-a934-4e43-a867-8698907d28c5", "toPort": "0", "fromPort": "1" }, { "to": "4f13e912-7e8f-4e4f-9295-9535bcd9ed40", "from": "60648c15-95db-48b4-9eee-3b1666285bfc", "toPort": "0", "fromPort": "0" }, { "to": "43d185ba-e4ea-4abe-b86d-b9d1045e4830", "from": "7e27628a-143d-4695-a7d5-99c16cf41706", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "7e27628a-143d-4695-a7d5-99c16cf41706", "name": "When clicking 'Test workflow'", "type": "manualTrigger", "params": {}, "position": [ 496, 272 ] }, { "id": "d31e2c79-a934-4e43-a867-8698907d28c5", "name": "Process One at a Time", "type": "passthrough", "params": { "mode": "noOp", "options": { "reset": false } }, "position": [ 1024, 272 ] }, { "id": "2f920ad0-869f-425f-93cc-ef74b7e4323d", "name": "Copy Slides Template", "type": "http", "params": { "url": "=https://www.googleapis.com/drive/v3/files/xxx/copy", "method": "POST", "options": {}, "jsonBody": "={{ JSON.stringify({ name: 'Certificate_' + $json['N.'] }) }}", "sendBody": true, "specifyBody": "json", "authentication": "predefinedCredentialType", "nodeCredentialType": "googleDriveOAuth2Api" }, "position": [ 1280, 288 ] }, { "id": "60648c15-95db-48b4-9eee-3b1666285bfc", "name": "Replace Template Placeholders", "type": "http", "params": { "url": "=https://slides.googleapis.com/v1/presentations/{{ $json.id }}:batchUpdate", "method": "POST", "options": {}, "jsonBody": "={\n \"requests\": [\n {\n \"replaceAllText\": {\n \"containsText\": { \"text\": \"[Name]\", \"matchCase\": false },\n \"replaceText\": \"{{ $('Process One at a Time').item.json['First Name'] }} {{ $('Process One at a Time').item.json['Last Name'] }}\"\n }\n },\n {\n \"replaceAllText\": {\n \"containsText\": { \"text\": \"[Date]\", \"matchCase\": false },\n \"replaceText\": \"{{ $now.format('dd/LL/yyyy') }}\"\n }\n },\n {\n \"replaceAllText\": {\n \"containsText\": { \"text\": \"[N]\", \"matchCase\": false },\n \"replaceText\": \"#{{ $('Process One at a Time').item.json['N.'] }}\"\n }\n }\n ]\n}", "sendBody": true, "specifyBody": "json", "authentication": "predefinedCredentialType", "nodeCredentialType": "googleSlidesOAuth2Api" }, "position": [ 1488, 288 ] }, { "id": "4f13e912-7e8f-4e4f-9295-9535bcd9ed40", "name": "Export to PDF", "type": "http", "params": { "url": "=https://www.googleapis.com/drive/v3/files/{{ $('Copy Slides Template').item.json.id }}/export?mimeType=application/pdf", "options": { "response": { "response": { "responseFormat": "file" } } }, "authentication": "predefinedCredentialType", "nodeCredentialType": "googleSlidesOAuth2Api" }, "position": [ 1712, 288 ] }, { "id": "616681e9-bf9d-4713-913f-b84ddeee1d1f", "name": "Save PDF to Drive", "type": "integration", "params": { "name": "=certificate_{{ $('Process One at a Time').item.json['N.'] }}.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": "1tkCr7xdraoZwsHqeLm7FZ4aRWY94oLbZ", "cachedResultUrl": "https://drive.google.com/drive/folders/1tkCr7xdraoZwsHqeLm7FZ4aRWY94oLbZ", "cachedResultName": "n8n" }, "operation": "read" }, "position": [ 1280, 960 ] }, { "id": "57962326-14e2-49bb-b46e-40ada76f8d99", "name": "Mark as Processed", "type": "integration", "params": { "columns": { "value": { "Sent": "x", "row_number": "={{ $('Process One at a Time').item.json.row_number }}" }, "schema": [ { "id": "N.", "type": "string", "display": true, "removed": false, "required": false, "displayName": "N.", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "First Name", "type": "string", "display": true, "removed": false, "required": false, "displayName": "First Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Last Name", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Last Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Email", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Email", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Sent", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Sent", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "row_number", "type": "number", "display": true, "removed": false, "readOnly": true, "required": false, "displayName": "row_number", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [ "row_number" ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "update", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1fHcfilCPpI4aAiJFQC3cPIAdJMmctMubz3kcOeai1yA/edit#gid=0", "cachedResultName": "Foglio1" }, "documentId": { "__rl": true, "mode": "list", "value": "1fHcfilCPpI4aAiJFQC3cPIAdJMmctMubz3kcOeai1yA", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1fHcfilCPpI4aAiJFQC3cPIAdJMmctMubz3kcOeai1yA/edit?usp=drivesdk", "cachedResultName": "Certifications" } }, "position": [ 1520, 960 ] }, { "id": "c3db4aa9-ff10-4054-81bb-232bb7c874cd", "name": "Send a message", "type": "integration", "params": { "sendTo": "={{$('Process One at a Time').item.json['Email']}}", "message": "=\n \n \n \n \n

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

🎉 Congratulations!

Dear {{$('Process One at a Time').item.json['First Name']}} {{$('Process One at a Time').item.json['Last Name']}},

Congratulations on successfully completing the n8n course!

It has been a pleasure having you on this learning journey. Your commitment and dedication throughout the course have been truly commendable, and we hope the knowledge and skills you gained will make a real difference in your day-to-day work.

Please find attached your official certificate of completion. We encourage you to share it proudly — you've earned it.

Thank you for being part of this program, and we wish you all the best in your automation journey.

Share your achievement on LinkedIn and let the world know!

\n Share on LinkedIn\n

This email was sent by n3w Italia · n3w.it

\n", "options": { "attachmentsUi": { "attachmentsBinary": [ {} ] } }, "service": "gmail", "subject": "Your n8n Certificate", "operation": "read" }, "position": [ 1280, 608 ] }, { "id": "14b280e9-b95d-4fba-8990-be9881a950fd", "name": "Merge", "type": "merge", "params": {}, "position": [ 1984, 944 ] }, { "id": "08598641-28bd-4baa-8c6b-021e5c1485e7", "name": "Wait 10s", "type": "passthrough", "params": { "mode": "noOp", "amount": 10 }, "position": [ 2240, 944 ] }, { "id": "b8e5e740-7d8c-4293-b39d-d119c6aad242", "name": "Delete Temp Slide", "type": "http", "params": { "url": "=https://www.googleapis.com/drive/v3/files/{{ $('Copy Slides Template').item.json.id }}", "method": "DELETE", "options": {}, "authentication": "predefinedCredentialType", "nodeCredentialType": "googleSlidesOAuth2Api" }, "position": [ 1744, 960 ] }, { "id": "43d185ba-e4ea-4abe-b86d-b9d1045e4830", "name": "Read File", "type": "integration", "params": { "options": {}, "service": "googleSheets", "filtersUI": { "values": [ { "lookupColumn": "Sent" } ] }, "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1fHcfilCPpI4aAiJFQC3cPIAdJMmctMubz3kcOeai1yA/edit#gid=0", "cachedResultName": "Foglio1" }, "documentId": { "__rl": true, "mode": "list", "value": "1fHcfilCPpI4aAiJFQC3cPIAdJMmctMubz3kcOeai1yA", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1fHcfilCPpI4aAiJFQC3cPIAdJMmctMubz3kcOeai1yA/edit?usp=drivesdk", "cachedResultName": "Certifications" } }, "position": [ 752, 272 ] } ] }

Generate bulk Google Slides certificates 📜 as PDFs and email them with Gmail