{"id":"eF84e2NyJWTCVClW","meta":{"instanceId":"workflow-6547cba6","versionId":"1.0.0","createdAt":"2025-09-29T07:07:45.546366","updatedAt":"2025-09-29T07:07:45.546381","owner":"n8n-user","license":"MIT","category":"automation","status":"active","priority":"high","environment":"production"},"name":"Create Custom Presentations per Lead","nodes":[{"id":"4cc04b1c-d97d-4d5a-b614-ba22b7b447bd","name":"Download by ID","type":"n8n-nodes-base.googleDrive","position":[-280,160],"parameters":{"fileId":{"__rl":true,"mode":"id","value":"={{ $json.id }}"},"options":{},"operation":"download"},"credentials":{"googleDriveOAuth2Api":{"id":"J7noNRzf26R3DpFF","name":"Jim Privat"}},"typeVersion":3,"notes":"This googleDrive node performs automated tasks as part of the workflow."},{"id":"8d550abf-a5f8-424d-8bfb-d9a9732eb93f","name":"MoveToLeadListFolder","type":"n8n-nodes-base.googleDrive","position":[1060,160],"parameters":{"fileId":{"__rl":true,"mode":"id","value":"={{ $('Create new Sheet').first().json.spreadsheetId }}"},"driveId":{"__rl":true,"mode":"list","value":"My Drive"},"folderId":{"__rl":true,"mode":"id","value":"=1-oMQTyijYXNmt-Dwh748JFjlDZVCu6ii"},"operation":"move"},"credentials":{"googleDriveOAuth2Api":{"id":"J7noNRzf26R3DpFF","name":"Jim Privat"}},"typeVersion":3,"notes":"This googleDrive node performs automated tasks as part of the workflow."},{"id":"4872b5ec-6dda-4920-b6e2-120bdc273c00","name":"Add Presentation ID to Lead List","type":"n8n-nodes-base.googleSheets","position":[1740,160],"parameters":{"columns":{"value":{"Email":"={{ $('Get all Leads').item.json.Email }}","PresentationID":"={{ $json.presentationId }}"},"schema":[{"id":"First Name","type":"string","display":true,"required":false,"displayName":"First Name","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Last Name","type":"string","display":true,"required":false,"displayName":"Last Name","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Full Name","type":"string","display":true,"required":false,"displayName":"Full Name","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Title","type":"string","display":true,"required":false,"displayName":"Title","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Email","type":"string","display":true,"removed":false,"required":false,"displayName":"Email","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Company","type":"string","display":true,"required":false,"displayName":"Company","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Contact Location","type":"string","display":true,"required":false,"displayName":"Contact Location","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Employees","type":"string","display":true,"required":false,"displayName":"Employees","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Phone","type":"string","display":true,"required":false,"displayName":"Phone","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Industry","type":"string","display":true,"required":false,"displayName":"Industry","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Country","type":"string","display":true,"required":false,"displayName":"Country","defaultMatch":false,"canBeUsedToMatch":true},{"id":"State","type":"string","display":true,"required":false,"displayName":"State","defaultMatch":false,"canBeUsedToMatch":true},{"id":"City","type":"string","display":true,"required":false,"displayName":"City","defaultMatch":false,"canBeUsedToMatch":true},{"id":"PresentationID","type":"string","display":true,"removed":false,"required":false,"displayName":"PresentationID","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Keywords","type":"string","display":true,"required":false,"displayName":"Keywords","defaultMatch":false,"canBeUsedToMatch":true},{"id":"row_number","type":"string","display":true,"removed":false,"readOnly":true,"required":false,"displayName":"row_number","defaultMatch":false,"canBeUsedToMatch":true}],"mappingMode":"defineBelow","matchingColumns":["Email"]},"options":{},"operation":"update","sheetName":{"__rl":true,"mode":"id","value":"={{ $('Create new Sheet').first().json.sheets[0].properties.sheetId }}"},"documentId":{"__rl":true,"mode":"id","value":"={{ $('Create new Sheet').first().json.spreadsheetId }}"}},"credentials":{"googleSheetsOAuth2Api":{"id":"tO62CXNbmAYSCBIY","name":"Midgard"}},"typeVersion":4.5,"notes":"This googleSheets node performs automated tasks as part of the workflow."},{"id":"afe225e3-fb82-4091-8310-6645d883c54d","name":"Get all Leads","type":"n8n-nodes-base.googleSheets","position":[840,160],"parameters":{"options":{},"sheetName":{"__rl":true,"mode":"id","value":"={{ $('Create new Sheet').first().json.sheets[0].properties.sheetId }}"},"documentId":{"__rl":true,"mode":"id","value":"={{ $('Create new Sheet').first().json.spreadsheetId }}"}},"credentials":{"googleSheetsOAuth2Api":{"id":"tO62CXNbmAYSCBIY","name":"Midgard"}},"executeOnce":true,"typeVersion":4.5,"notes":"This googleSheets node performs automated tasks as part of the workflow."},{"id":"635c62cf-4369-442b-8fd7-be2e4caa6ebc","name":"Create new Sheet","type":"n8n-nodes-base.googleSheets","position":[0,40],"parameters":{"title":"=Leads_{{ $now.setZone('Europe/Berlin').toFormat('yyyy-dd-MM') }}","options":{},"resource":"spreadsheet","sheetsUi":{"sheetValues":[{"title":"sample_data"}]}},"credentials":{"googleSheetsOAuth2Api":{"id":"tO62CXNbmAYSCBIY","name":"Midgard"}},"typeVersion":4.5,"notes":"This googleSheets node performs automated tasks as part of the workflow."},{"id":"d55c0f32-b74a-484a-b759-9ca1c4cf8d65","name":"Merge Data for new Lead Document","type":"n8n-nodes-base.googleSheets","position":[580,160],"parameters":{"columns":{"value":{},"schema":[{"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":"Full Name","type":"string","display":true,"removed":false,"required":false,"displayName":"Full Name","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Title","type":"string","display":true,"removed":false,"required":false,"displayName":"Title","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Email","type":"string","display":true,"removed":false,"required":false,"displayName":"Email","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Company","type":"string","display":true,"removed":false,"required":false,"displayName":"Company","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Contact Location","type":"string","display":true,"removed":false,"required":false,"displayName":"Contact Location","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Employees","type":"string","display":true,"removed":false,"required":false,"displayName":"Employees","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Phone","type":"string","display":true,"removed":false,"required":false,"displayName":"Phone","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Industry","type":"string","display":true,"removed":false,"required":false,"displayName":"Industry","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Country","type":"string","display":true,"removed":false,"required":false,"displayName":"Country","defaultMatch":false,"canBeUsedToMatch":true},{"id":"State","type":"string","display":true,"removed":false,"required":false,"displayName":"State","defaultMatch":false,"canBeUsedToMatch":true},{"id":"City","type":"string","display":true,"removed":false,"required":false,"displayName":"City","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Keywords","type":"string","display":true,"removed":false,"required":false,"displayName":"Keywords","defaultMatch":false,"canBeUsedToMatch":true}],"mappingMode":"autoMapInputData","matchingColumns":[]},"options":{"useAppend":true},"operation":"append","sheetName":{"__rl":true,"mode":"id","value":"={{ $('Create new Sheet').first().json.sheets[0].properties.sheetId }}"},"documentId":{"__rl":true,"mode":"id","value":"={{ $('Create new Sheet').first().json.spreadsheetId }}"}},"credentials":{"googleSheetsOAuth2Api":{"id":"tO62CXNbmAYSCBIY","name":"Midgard"}},"typeVersion":4.5,"notes":"This googleSheets node performs automated tasks as part of the workflow."},{"id":"9d93741a-93b2-4556-9f2e-2d40617c69ac","name":"New Leads Arrived","type":"n8n-nodes-base.googleDriveTrigger","position":[-800,160],"parameters":{"event":"fileCreated","options":{},"pollTimes":{"item":[{"mode":"everyMinute"}]},"triggerOn":"specificFolder","folderToWatch":{"__rl":true,"mode":"list","value":"1GYT9Z8_BnqqY9dqsMpFWJqjeNVsq_xTY","cachedResultUrl":"{{ $env.WEBHOOK_URL }}","cachedResultName":"__cmath"}},"credentials":{"googleDriveOAuth2Api":{"id":"J7noNRzf26R3DpFF","name":"Jim Privat"}},"typeVersion":1,"notes":"This googleDriveTrigger node performs automated tasks as part of the workflow."},{"id":"174ff078-e06a-47c3-93c2-441667e0f8e5","name":"File Type?","type":"n8n-nodes-base.switch","position":[-560,160],"parameters":{"rules":{"values":[{"outputKey":"YOUR_CREDENTIAL_HERE","conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"operator":{"type":"string","operation":"equals"},"leftValue":"={{ $json.mimeType }}","rightValue":"text/csv"}]},"renameOutput":true},{"outputKey":"YOUR_CREDENTIAL_HERE","conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"id":"c2f2fb50-a750-4870-aff7-11df142a9be5","operator":{"name":"filter.operator.equals","type":"string","operation":"equals"},"leftValue":"={{ $json.mimeType }}","rightValue":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"}]},"renameOutput":true}]},"options":{}},"typeVersion":3.2,"notes":"This switch node performs automated tasks as part of the workflow."},{"id":"23d71fb1-c8f2-4144-a40e-be378aa2043a","name":"Combine Empty New Document with CSV Data","type":"n8n-nodes-base.merge","position":[300,160],"parameters":{"mode":"chooseBranch","useDataOfInput":2},"typeVersion":3,"notes":"This merge node performs automated tasks as part of the workflow."},{"id":"195d7ed6-7dc0-4f49-8256-f47b4c8d426b","name":"Create Custom Presentation","type":"n8n-nodes-base.googleSlides","position":[1520,160],"parameters":{"textUi":{"textValues":[{"text":"{COMPANYNAME}","replaceText":"={{ $('Get all Leads').item.json.Company }}"},{"text":"{Testdurchgestrichen}","replaceText":"={{ $('Get all Leads').item.json['Full Name'] }}"},{"text":"{nichtdurchgestrichen}","replaceText":"={{ $('Get all Leads').item.json['First Name'] }}"}]},"options":{},"operation":"replaceText","presentationId":"={{ $json.id }}"},"credentials":{"googleSlidesOAuth2Api":{"id":"e9cejsZpBHAaXKv0","name":"GSlides Midgard"}},"typeVersion":2,"notes":"This googleSlides node performs automated tasks as part of the workflow."},{"id":"97d47391-20ea-4db7-bdf6-22eebc22a9dd","name":"Sticky Note","type":"n8n-nodes-base.stickyNote","position":[980,60],"parameters":{"color":4,"width":960,"height":340,"content":"# Duplicate Template and Create Custom Presentations"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"acded411-6cdf-489a-bb14-c7c14cdaee23","name":"Sticky Note1","type":"n8n-nodes-base.stickyNote","position":[-320,-120],"parameters":{"color":4,"width":1300,"height":520,"content":"# Create New Google Sheets and Insert Data from CSV file"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"9dd9e32a-5c1b-4faf-8054-63b66f5dd24e","name":"Extract Information from CSV file","type":"n8n-nodes-base.extractFromFile","position":[0,220],"parameters":{"options":{"encoding":"utf-8","delimiter":",","headerRow":true}},"typeVersion":1,"notes":"This extractFromFile node performs automated tasks as part of the workflow."},{"id":"0329eabe-dee1-41fd-a7eb-017343523e40","name":"Copy Presentation Template","type":"n8n-nodes-base.googleDrive","position":[1300,160],"parameters":{"name":"={{ $('Get all Leads').item.json.Company }} X MYCOMPANYNAME_{{ $now.setZone('Europe/Berlin').toFormat('yyyy-dd-MM') }}","fileId":{"__rl":true,"mode":"list","value":"1FtMBECbZY-9gSW6L6DtioOOJv-V9LXduEjZO0pp-NmA","cachedResultUrl":"{{ $env.WEBHOOK_URL }}","cachedResultName":"Stardawn Updated"},"driveId":{"__rl":true,"mode":"list","value":"My Drive"},"options":{},"folderId":{"__rl":true,"mode":"list","value":"1Yu2s72rgOJlz1-tMuzlaeN8UZezYftRT","cachedResultUrl":"{{ $env.WEBHOOK_URL }}","cachedResultName":"Custom Presentations"},"operation":"copy","sameFolder":false},"credentials":{"googleDriveOAuth2Api":{"id":"J7noNRzf26R3DpFF","name":"Jim Privat"}},"typeVersion":3,"notes":"This googleDrive node performs automated tasks as part of the workflow."},{"id":"error-684fcf93","name":"Error Handler","type":"n8n-nodes-base.stopAndError","typeVersion":1,"position":[1000,400],"parameters":{"message":"Workflow execution error","options":{}}}],"active":false,"settings":{"executionOrder":"v1","saveManualExecutions":true,"callerPolicy":"workflowsFromSameOwner","errorWorkflow":null,"timezone":"UTC","executionTimeout":3600,"maxExecutions":1000,"retryOnFail":true,"retryCount":3,"retryDelay":1000},"versionId":"bd03e5b5-be73-444f-a1e6-f037db77a01b","connections":{"Download by ID":{"main":[[]]},"MoveToLeadListFolder":{"main":[[]]},"Add Presentation ID to Lead List":{"main":[[]]},"Get all Leads":{"main":[[]]},"Create new Sheet":{"main":[[]]},"Merge Data for new Lead Document":{"main":[[]]},"New Leads Arrived":{"main":[[]]},"Create Custom Presentation":{"main":[[]]},"Extract Information from CSV file":{"main":[[]]},"Copy Presentation Template":{"main":[[]]}},"description":"Automated workflow: Create Custom Presentations per Lead. This workflow integrates 9 different services: stickyNote, googleDriveTrigger, googleSlides, googleDrive, switch. It contains 24 nodes and follows best practices for error handling and security.","notes":"Excellent quality workflow: Create Custom Presentations per Lead. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}