Move manufacturer records from a Google Sheet into Shopware in one run. Teams keep names, websites, descriptions, and logos up to date without typing the same data twice. Great for ecommerce ops and catalog owners.

Start it with a click. A Settings step stores your Shopware URL and language code. The Google Sheets step reads rows with name, website, description, and logo_url. A Code step builds a Shopware sync request and creates stable media ids using an md5 hash. Split In Batches sends each record to the Shopware sync endpoint to create or update the manufacturer. An If check looks for a logo link and, when present, uploads the image to the right media id with the correct file name and extension. The loop continues until every row is processed.

Prepare a Google Sheet with the four columns and get Shopware client credentials. Set the shopware_url and connect both services in n8n. Expect faster catalog onboarding, fewer mistakes, and clear control of image uploads. This is helpful for supplier imports, rebrands, and store launches, where many entries must be correct and live fast.

• On click start using a Manual Trigger for full control.
• Central Settings store the Shopware URL and default language code to avoid hardcoding.
• Google Sheets reads rows with name, website, description, and logo_url from the chosen sheet.
• Code builds the Shopware sync body and adds translations and stable media ids using an md5 hash.
• Split In Batches processes one manufacturer at a time to manage API load.
• HTTP Request calls the /api/_action/sync endpoint to create or update manufacturer records.
• If checks for a logo_url and only then triggers the media upload call.
• HTTP Request uploads the logo with proper fileName and extension parameters.

• Reduce manual entry from 2 hours to 10 minutes for 100 manufacturers
• Improve data accuracy by 90 percent with one source of truth
• Handle 10 times more imports with batch processing
• Connect Google Sheets and Shopware without CSV files
• Keep brand pages consistent by auto uploading logos

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets and Shopware. See the Tools Required section above for links to create accounts with these services.
3. Create a Google Sheet with the columns name, website, description, and logo_url. Add a few sample rows to test.
4. Open the Google Sheets node in n8n. In the Document field pick your sheet. If credentials are not set, click the Credential dropdown, choose Create new credential, and follow the on screen steps to connect your Google account.
5. In your Shopware admin, create an Integration to get a Client ID and Client Secret. Ensure permissions cover manufacturers and media.
6. In n8n, open Credentials. Create a new OAuth2 credential using the Generic type with Grant Type Client Credentials. Set Access Token URL to https://your-shopware-domain.com/api/oauth/token and enter your Client ID and Client Secret, then save.
7. Assign the Shopware OAuth2 credential to both HTTP Request nodes named Import Manufacturer and Upload Manufacturer Logo.
8. Open the Settings node. Replace the shopware_url with your Shopware domain and adjust the default_language_code if needed.
9. Confirm the Google Sheets node points to the correct document and sheet. Make sure header names match exactly.
10. Click Execute Workflow. Watch the Split In Batches node to see each row processed. When finished, check Shopware admin for new or updated manufacturers.
11. Troubleshoot: If you see 401 errors, verify the Client ID, Client Secret, and token URL. If logos do not upload, confirm logo_url is public and the file extension resolves. If rows are skipped, check header names and empty cells. Adjust batch size if your store rate limits.
12. Optional: Update the default_language_code and Code logic if your store uses a different locale or translation rules.