Import Multiple Manufacturers from Google Sheets to Shopware 6

This n8n workflow streamlines the process of importing manufacturer data from a Google Sheet into a Shopware 6 e-commerce platform. It allows for bulk creation of new manufacturers, ensuring your product data stays synchronized and up-to-date.

What it does

This workflow performs the following key steps:

1. Triggers Manually: The workflow is initiated manually, allowing you to control when the import process runs.
2. Reads Data from Google Sheets: It fetches manufacturer data from a specified Google Sheet.
3. Transforms Data: The retrieved data is processed and formatted to match the expected structure for Shopware 6 API calls. This includes mapping column names and potentially adding default values.
4. Checks for Existing Manufacturers: For each manufacturer, it makes an API call to Shopware 6 to check if a manufacturer with the given name already exists.
5. Conditionally Creates New Manufacturers:
   • If a manufacturer does not exist, the workflow proceeds to create it in Shopware 6 via an API call.
   • If a manufacturer already exists, it skips the creation step for that specific entry.
6. Loops Through Manufacturers: The workflow processes manufacturers in batches, ensuring efficient handling of large datasets.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Google Sheets Account: Access to a Google Sheet containing your manufacturer data.
• Shopware 6 Instance: A Shopware 6 e-commerce platform.
• Shopware 6 API Access: API credentials (e.g., API key, secret, and base URL) for your Shopware 6 instance with permissions to create manufacturers.
• Google Sheets Credential: An n8n credential configured for your Google Sheets account.
• HTTP Request Credential (for Shopware 6 API): An n8n credential (likely a "Header Auth" or "OAuth2" type) configured for your Shopware 6 API.

Setup/Usage

1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Google Sheets Node (ID: 18):
   • Select your Google Sheets credential.
   • Specify the Spreadsheet ID and Sheet Name where your manufacturer data is located.
   • Ensure the column headers in your Google Sheet match the expected fields for manufacturer data (e.g., "name", "link", etc.).
3. Configure HTTP Request Nodes (ID: 19 - for Shopware API calls):
   • Select your Shopware 6 API credential.
   • For checking existing manufacturers: Update the URL to your Shopware 6 API endpoint for listing manufacturers (e.g., YOUR_SHOPWARE_URL/api/manufacturer).
   • For creating new manufacturers: Update the URL to your Shopware 6 API endpoint for creating manufacturers (e.g., YOUR_SHOPWARE_URL/api/manufacturer).
   • Adjust the request body in the "Edit Fields" (Set) node (ID: 38) and the "HTTP Request" nodes (ID: 19) to correctly map your Google Sheet data to the Shopware 6 manufacturer API payload.
4. Review "Edit Fields" (Set) Node (ID: 38):
   • This node is crucial for transforming the data from Google Sheets into the format expected by Shopware 6.
   • Adjust the expressions to map your Google Sheet column names to Shopware 6 API fields (e.g., {{ $json.name }} for the manufacturer name).
5. Review "If" Node (ID: 20):
   • This node determines if a manufacturer already exists. Ensure the condition accurately checks the response from the Shopware 6 API call (e.g., checking if the API returned an existing manufacturer or an empty result).
6. Review "Code" Node (ID: 834):
   • This node likely contains custom logic for data manipulation or API response processing. Review and adjust the JavaScript code if necessary to fit your specific data structure or requirements.
7. Execute the Workflow: Click "Execute Workflow" to run the import process. It's recommended to test with a small subset of data first.