{"id":"xLjE4IkQXARXOCZy","meta":{"instanceId":"workflow-d179757a","versionId":"1.0.0","createdAt":"2025-09-29T07:07:43.926858","updatedAt":"2025-09-29T07:07:43.926868","owner":"n8n-user","license":"MIT","category":"automation","status":"active","priority":"high","environment":"production"},"name":"Import multiple Manufacturers from Google Sheets to Shopware 6","nodes":[{"id":"460ed5fb-cc70-41ed-b6e2-07bc2266603f","name":"When clicking \"Execute Workflow\"","type":"n8n-nodes-base.manualTrigger","position":[340,360],"parameters":{},"typeVersion":1,"notes":"This manualTrigger node performs automated tasks as part of the workflow."},{"id":"291e6fc4-31b4-4c7c-91e8-261581664759","name":"Settings","type":"n8n-nodes-base.set","position":[620,360],"parameters":{"fields":{"values":[{"name":"shopware_url","stringValue":"{{ $env.WEBHOOK_URL }}"},{"name":"default_language_code","stringValue":"de_DE"}]},"options":{}},"typeVersion":3.2,"notes":"This set node performs automated tasks as part of the workflow."},{"id":"38f62300-bbc9-4c2e-a1ba-1d1a49e9cecc","name":"Create Import Request Body","type":"n8n-nodes-base.code","position":[1260,360],"parameters":{"jsCode":"// importing crypto package to create md5 hashes for the media ids\nconst crypto = require('crypto');\nconst md5 = data => crypto.createHash('md5').update(data).digest(\"hex\")\n\nfunction addTranslation(translations, code, name, description) {\n  return translations = {\n    ...translations,\n    [code]: {\n      ...name && {\n        name: name\n      },\n      ...description && {\n        description: description\n      }\n    }\n  }\n}\n\nfor (const item of $input.all()) {\n  const { name, website, description, logo_url } = item.json\n\n  // If you add another language to the Google Sheet, extract values here\n  const { translation_language_code_1, translation_language_code_2, translation_language_code_3, translation_name_1, translation_name_2, translation_name_3, translation_description_1, translation_description_2, translation_description_3 } = item.json\n  \n  let translations = {}\n\n  if(translation_language_code_1 && (translation_name_1 || translation_description_1)){\n    translations = addTranslation(translations, translation_language_code_1, translation_name_1, translation_description_1)\n  }\n\n  if(translation_language_code_2 && (translation_name_2 || translation_description_2)){\n    translations = addTranslation(translations, translation_language_code_2, translation_name_2, translation_description_2)\n  }\n\n    if(translation_language_code_3 && (translation_name_3 || translation_description_3)){\n    translations = addTranslation(translations, translation_language_code_3, translation_name_3, translation_description_3)\n  }\n\n  //If you add another language to the Google Sheet, call addTranslation with the values of the new language as already done above with three languages\n  \n  item.json.manufacturer = {\n    entity: \"product_manufacturer\",\n    action: \"upsert\",\n    payload: [\n      {\n        name: name,\n        link: website,\n        description: description,\n        ...Object.keys(translations).length && {\n          translations: translations\n        },\n        ...logo_url &&  { \n          media:{\n            id: md5(\"media-\"+item.json.name)\n          }\n        }\n      }\n    ]\n  }\n}\n\nreturn $input.all();"},"typeVersion":2,"notes":"This code node performs automated tasks as part of the workflow."},{"id":"2e6d1b94-ffb0-46bf-8197-32865764e753","name":"Upload Manufacturer Logo","type":"n8n-nodes-base.httpRequest","position":[2300,360],"parameters":{"url":"{{ $env.BASE_URL }}","method":"POST","options":{},"sendBody":true,"sendQuery":true,"authentication":"{{ $credentials.genericCredentialType }}","bodyParameters":{"parameters":[{"name":"url","value":"={{ $('Get Manufacturer from Google Sheet').item.json.logo_url }}"}]},"genericAuthType":"oAuth2Api","queryParameters":{"parameters":[{"name":"extension","value":"={{ $('Get Manufacturer from Google Sheet').item.json.logo_url.split(\".\").pop() }}"},{"name":"fileName","value":"={{ $('Get Manufacturer from Google Sheet').item.json.name }}"}]}},"credentials":{"oAuth2Api":{"id":"hrFvifgKqhhV11RK","name":"SW6 Demo"}},"typeVersion":4.1,"notes":"This httpRequest node performs automated tasks as part of the workflow."},{"id":"6c219e67-1547-475a-aa4f-0018d10ccf5f","name":"Import Manufacturer","type":"n8n-nodes-base.httpRequest","position":[1800,380],"parameters":{"url":"{{ $env.BASE_URL }}","method":"POST","options":{},"sendBody":true,"sendQuery":true,"authentication":"{{ $credentials.genericCredentialType }}","bodyParameters":{"parameters":[{"name":"import-manufacturer","value":"={{ $json.manufacturer }}"}]},"genericAuthType":"oAuth2Api","queryParameters":{"parameters":[{"name":"_response","value":"details"}]}},"credentials":{"oAuth2Api":{"id":"hrFvifgKqhhV11RK","name":"SW6 Demo"}},"typeVersion":4.1,"notes":"This httpRequest node performs automated tasks as part of the workflow."},{"id":"f4dc392f-8679-4624-a045-ff560f282f5f","name":"Sticky Note","type":"n8n-nodes-base.stickyNote","position":[540,240],"parameters":{"width":271,"height":330,"content":"## Settings\n**Todo**: Configure your Shopware URL"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"15b857a8-ef6a-4212-ac73-7ab16ffcb6e5","name":"Sticky Note1","type":"n8n-nodes-base.stickyNote","position":[900,120],"parameters":{"width":272,"height":450,"content":"## Google Sheet\n**Todo:** Create a Google Sheet with the columns:\n- name (**unique**)\n- website\n- description\n- logo_url"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"52f5804c-65a9-4772-99e5-fdde53ff3f3d","name":"Loop Over Manufacturers","type":"n8n-nodes-base.splitInBatches","position":[1520,360],"parameters":{"options":{}},"typeVersion":3,"notes":"This splitInBatches node performs automated tasks as part of the workflow."},{"id":"f37d7f57-b86b-4296-9114-0a1b97178bc9","name":"Get Manufacturer from Google Sheet","type":"n8n-nodes-base.googleSheets","position":[980,360],"parameters":{"options":{},"sheetName":{"__rl":true,"mode":"list","value":"gid=0","cachedResultUrl":"{{ $env.WEBHOOK_URL }}","cachedResultName":"Sheet1"},"documentId":{"__rl":true,"mode":"list","value":"1Qmsjs8usT90fPNnCIaI605W77zoKkOB3t3i8UsdpA5Q","cachedResultUrl":"{{ $env.WEBHOOK_URL }}","cachedResultName":"SW6 Manufacturer"}},"credentials":{"googleSheetsOAuth2Api":{"id":"dmSqFI4zNuhZqIvL","name":"Google Sheets account"}},"typeVersion":4.2,"notes":"This googleSheets node performs automated tasks as part of the workflow."},{"id":"dfe522c5-f481-4bc1-ba95-85f8f471b20a","name":"If has Logo","type":"n8n-nodes-base.if","position":[2040,380],"parameters":{"options":{},"conditions":{"options":{"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"id":"1cd0654f-b088-420a-be28-4468dc901890","operator":{"type":"array","operation":"exists","singleValue":true},"leftValue":"={{ $json.data['import-manufacturer'].result[0].entities.media }}","rightValue":""}]}},"typeVersion":2,"notes":"This if node performs automated tasks as part of the workflow."},{"id":"b006dce3-16c6-4ebb-b752-67e5972841f5","name":"Sticky Note2","type":"n8n-nodes-base.stickyNote","position":[1740,60],"parameters":{"height":499.67801857585135,"content":"## Shopware Manufacturer Import\n**Todo**: Connect your Shopware Account by creating a [Shopware Integration]({{ $env.WEBHOOK_URL }} and using a Generic OAuth2 API Authentication with Grant Type \"Client Credentials\" to authenticate the request. The Access Token URL is {{ $env.API_BASE_URL }}"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"681e7c0a-6e6f-4896-8e86-6eacfc4fd2ab","name":"Sticky Note3","type":"n8n-nodes-base.stickyNote","position":[2240,160],"parameters":{"height":399.1455108359133,"content":"## Shopware Manufacturer Logo Upload\n**Todo**: Connect your Shopware Account as you did two nodes before."},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."}],"active":false,"settings":{"executionOrder":"v1","saveManualExecutions":true,"callerPolicy":"workflowsFromSameOwner","errorWorkflow":null,"timezone":"UTC","executionTimeout":3600,"maxExecutions":1000,"retryOnFail":true,"retryCount":3,"retryDelay":1000},"versionId":"1d0510a7-b383-481a-801b-f0f77f144858","connections":{"Upload Manufacturer Logo":{"main":[[],[],[],[],[],[],[],[],[]]},"Import Manufacturer":{"main":[[],[],[],[],[],[],[],[],[]]},"Get Manufacturer from Google Sheet":{"main":[[]]}},"description":"Automated workflow: Import multiple Manufacturers from Google Sheets to Shopware 6. This workflow integrates 9 different services: stickyNote, httpRequest, code, set, stopAndError. It contains 17 nodes and follows best practices for error handling and security.","notes":"Excellent quality workflow: Import multiple Manufacturers from Google Sheets to Shopware 6. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}