This article provides a complete, practical walkthrough of the Code Manual Import Webhook n8n agent. It connects HTTP Request, Webhook across approximately 1 node(s). Expect a Intermediate setup in 15-45 minutes. One‑time purchase: €29.

What This Agent Does

This agent orchestrates a reliable automation between HTTP Request, Webhook, handling triggers, data enrichment, and delivery with guardrails for errors and rate limits.

It streamlines multi‑step processes that would otherwise require manual exports, spreadsheet cleanup, and repeated API requests. By centralizing logic in n8n, it reduces context switching, lowers error rates, and ensures consistent results across teams.

Typical outcomes include faster lead handoffs, automated notifications, accurate data synchronization, and better visibility via execution logs and optional Slack/Email alerts.

How It Works

The workflow uses standard n8n building blocks like Webhook or Schedule triggers, HTTP Request for API calls, and control nodes (IF, Merge, Set) to validate inputs, branch on conditions, and format outputs. Retries and timeouts improve resilience, while credentials keep secrets safe.

Third‑Party Integrations

• HTTP Request
• Webhook

Import and Use in n8n

1. Open n8n and create a new workflow or collection.
2. Choose Import from File or Paste JSON.
3. Paste the JSON below, then click Import.
4. Show n8n JSON

   Title:  
   Automate Manufacturer Imports from Google Sheets to Shopware 6 Using n8n
   
   Meta Description:  
   Learn how to streamline bulk manufacturer imports into Shopware 6 using a fully automated n8n workflow that pulls data from Google Sheets and handles media uploads, translations, and sync operations.
   
   Keywords:  
   n8n tutorial, Shopware 6 integration, automate manufacturer import, Google Sheets API, Shopware API, Shopware media upload, no-code automation, Shopware translations, sync manufacturers, eCommerce automation
   
   Third-Party APIs Used:
   1. Google Sheets API (via n8n Google Sheets OAuth2 integration)
   2. Shopware 6 API (via Generic OAuth2 API authentication)
   
   ---
   
   Article:
   
   ## Automate Manufacturer Imports from Google Sheets to Shopware 6 Using n8n
   
   Managing and updating manufacturer data manually in an eCommerce platform like Shopware 6 can be a time-consuming and error-prone process. Fortunately, workflow automation platforms like n8n empower users to automate such data management tasks with minimal coding effort.
   
   In this tutorial, we walk through how to build a robust n8n workflow to import multiple manufacturers from a Google Sheet directly into Shopware 6. This includes support for multi-language content, logo/media uploads, and proper syncing with Shopware’s API.
   
   ### Why Automate Manufacturer Imports?
   
   A typical manufacturer entry in your Shopware 6 backend includes a name, description, website link, and optionally, a logo or image. Doing this for multiple records manually doesn’t scale well, especially if you support additional locales. Automating with n8n ensures your product data stays accurate, consistent, and quick to deploy.
   
   ---
   
   ### Overview of the Workflow
   
   The workflow is titled:  
   **“Import multiple Manufacturers from Google Sheets to Shopware 6”**
   
   It handles the following processes:
   
   1. **Trigger execution** manually via n8n’s built-in Manual Trigger node.
   2. **Retrieve configuration settings**, specifically the Shopware URL and default language.
   3. **Read manufacturer data** from a Google Sheet, including optional translations for up to three languages.
   4. **Transform the data** into Shopware-compatible payloads using custom scripting.
   5. **Import manufacturers** into Shopware in batch mode using the `/api/_action/sync` endpoint.
   6. **Upload manufacturer logos**, if present, directly to the Shopware media endpoint.
   
   ---
   
   ### Preparing Your Google Sheet
   
   Before starting:
   
   Create a Google Sheet with these columns:
   
   - `name` (must be unique for each entry)
   - `website`
   - `description`
   - `logo_url` (direct link to the manufacturer logo)
   
   For multilingual support, include up to three sets of the following:
   
   - `translation_language_code_n`
   - `translation_name_n`
   - `translation_description_n`
   
   _(Replace “n” with number 1–3)_
   
   ---
   
   ### Step-by-Step Node Breakdown
   
   1. 🎬 **Manual Trigger**  
      Starts workflow execution when clicked from the n8n interface.
   
   2. 🛠️ **Settings Node**  
      Stores configuration such as Shopware URL and default language code (e.g., `de_DE`). You only need to set this once.
   
   3. 📄 **Google Sheets Node**  
      Authenticated using OAuth2, this node fetches each row of manufacturer data from your prepared Google Sheet.
   
   4. 🧠 **Code Node (JavaScript)**  
      Transforms the raw sheet data into an API-ready JSON structure.  
      - Creates `manufacturer` payloads  
      - Supports multilingual translations  
      - Hashes names to generate consistent media IDs
   
   5. 🔁 **Split In Batches**  
      Loops over each manufacturer so that subsequent actions can be taken per entry.
   
   6. 📦 **HTTP Request - Import Manufacturer**  
      Sends the synced payload via POST to `/api/_action/sync` endpoint on Shopware.
   
   7. 🔍 **IF Node - Check for Logo**  
      Reviews response to determine whether a media entry (logo) is associated with the manufacturer.
   
   8. 🖼️ **HTTP Request - Upload Logo**  
      Uploads manufacturer logos via URL to Shopware’s media API, associating them with the correct manufacturer entry.
   
   ---
   
   ### Requirements and Setup
   
   Before running the workflow, complete these tasks:
   
   ✅ Create a Shopware Integration and note down your Client ID and Secret.  
   ✅ Set up n8n with Generic OAuth2 credentials:  
   - Token URL: `https://your-shopware-domain.com/api/oauth/token`  
   - Grant Type: Client Credentials
   
   ✅ Connect your Google account using n8n’s Google Sheets OAuth2 credentials.
   
   ✅ Customize the “Settings” node with your Shopware base URL.
   
   ✅ Make sure logos are accessible via direct URLs (e.g., from a public Google Drive or S3 bucket).
   
   ---
   
   ### Final Thoughts
   
   This workflow is a shining example of how a no—low-code tool like n8n can streamline eCommerce management tasks. Whether you're a developer or a store manager with light technical skills, this setup removes much of the manual burden of updating product manufacturers. Moreover, it enables multilingual compatibility and centralized media handling—all while syncing directly with Shopware 6’s robust API.
   
   Feel free to modify or expand the workflow to accommodate additional data — such as contact info, categories, or even extending this pattern to suppliers, product imports, or pricing updates.
   
   Automation isn't just about saving time — it's about scaling smarter.
   
   ---
   
   Ready to try it yourself? Clone the workflow, configure your credentials, and let n8n do the heavy lifting.
   
   Happy automating!
   
   ---

5. Set credentials for each API node (keys, OAuth) in Credentials.
6. Run a test via Execute Workflow. Inspect Run Data, then adjust parameters.
7. Enable the workflow to run on schedule, webhook, or triggers as configured.

Tips: keep secrets in credentials, add retries and timeouts on HTTP nodes, implement error notifications, and paginate large API fetches.

Validation: use IF/Code nodes to sanitize inputs and guard against empty payloads.

Why Automate This with AI Agents

AI‑assisted automations offload repetitive, error‑prone tasks to a predictable workflow. Instead of manual copy‑paste and ad‑hoc scripts, your team gets a governed pipeline with versioned state, auditability, and observable runs.

n8n’s node graph makes data flow transparent while AI‑powered enrichment (classification, extraction, summarization) boosts throughput and consistency. Teams reclaim time, reduce operational costs, and standardize best practices without sacrificing flexibility.

Compared to one‑off integrations, an AI agent is easier to extend: swap APIs, add filters, or bolt on notifications without rewriting everything. You get reliability, control, and a faster path from idea to production.

Best Practices

• Credentials: restrict scopes and rotate tokens regularly.
• Resilience: configure retries, timeouts, and backoff for API nodes.
• Data Quality: validate inputs; normalize fields early to reduce downstream branching.
• Performance: batch records and paginate for large datasets.
• Observability: add failure alerts (Email/Slack) and persistent logs for auditing.
• Security: avoid sensitive data in logs; use environment variables and n8n credentials.

FAQs

Can I swap integrations later? Yes. Replace or add nodes and re‑map fields without rebuilding the whole flow.

How do I monitor failures? Use Execution logs and add notifications on the Error Trigger path.

Does it scale? Use queues, batching, and sub‑workflows to split responsibilities and control load.

Is my data safe? Keep secrets in Credentials, restrict token scopes, and review access logs.