{
  "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",
  "tags": [
    "automation",
    "n8n",
    "production-ready",
    "excellent",
    "optimized"
  ],
  "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,
  "pinData": {},
  "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": {
    "2e6d1b94-ffb0-46bf-8197-32865764e753": {
      "main": [
        [
          {
            "node": "error-handler-2e6d1b94-ffb0-46bf-8197-32865764e753",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "error-handler-2e6d1b94-ffb0-46bf-8197-32865764e753-3cafed57",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "error-handler-2e6d1b94-ffb0-46bf-8197-32865764e753-ebeea0ef",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "error-handler-2e6d1b94-ffb0-46bf-8197-32865764e753-639ff933",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "error-handler-2e6d1b94-ffb0-46bf-8197-32865764e753-79055bb2",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "error-handler-2e6d1b94-ffb0-46bf-8197-32865764e753-0bc67295",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "error-handler-2e6d1b94-ffb0-46bf-8197-32865764e753-cd7b6aab",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "error-handler-2e6d1b94-ffb0-46bf-8197-32865764e753-60a836e0",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "error-handler-2e6d1b94-ffb0-46bf-8197-32865764e753-e58fa473",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6c219e67-1547-475a-aa4f-0018d10ccf5f": {
      "main": [
        [
          {
            "node": "error-handler-6c219e67-1547-475a-aa4f-0018d10ccf5f",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "error-handler-6c219e67-1547-475a-aa4f-0018d10ccf5f-c9c6a356",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "error-handler-6c219e67-1547-475a-aa4f-0018d10ccf5f-9713f727",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "error-handler-6c219e67-1547-475a-aa4f-0018d10ccf5f-258b5d76",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "error-handler-6c219e67-1547-475a-aa4f-0018d10ccf5f-d4dc5c51",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "error-handler-6c219e67-1547-475a-aa4f-0018d10ccf5f-adcc5eea",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "error-handler-6c219e67-1547-475a-aa4f-0018d10ccf5f-52982c7f",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "error-handler-6c219e67-1547-475a-aa4f-0018d10ccf5f-be879178",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "error-handler-6c219e67-1547-475a-aa4f-0018d10ccf5f-ffb11a13",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f37d7f57-b86b-4296-9114-0a1b97178bc9": {
      "main": [
        [
          {
            "node": "error-handler-f37d7f57-b86b-4296-9114-0a1b97178bc9-68e67412",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "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."
}