Import Multiple Manufacturers from Google Sheets to Shopware 6
This workflow is designed to automatically import manufacturer information from Google Sheets to the Shopware 6 e-commerce platform, supporting multilingual translation and logo uploads, thereby streamlining the bulk management process. Data security is ensured through OAuth2 authentication, and custom code nodes are used to flexibly construct requests, enhancing the efficiency and accuracy of the imports. It is suitable for e-commerce operators and IT automation engineers, helping businesses quickly achieve data synchronization, reduce human errors, and improve work efficiency.
Workflow Name
Import Multiple Manufacturers from Google Sheets to Shopware 6
Key Features and Highlights
This workflow enables the automatic import of multiple manufacturer records from Google Sheets into the Shopware 6 e-commerce platform. It supports handling multilingual translation fields and automatic uploading of manufacturer logos, significantly simplifying the bulk management of manufacturer data. The workflow employs OAuth2 authentication to ensure data security and uses custom code nodes to flexibly construct import request payloads, balancing high customization with automation.
Core Problems Addressed
- Manual entry of manufacturer information is tedious and error-prone
- Managing multilingual manufacturer data is complex
- Manufacturer logo upload processes are fragmented and inefficient
- A unified and automated solution is needed for synchronizing manufacturer data
Use Cases
- Bulk importing and maintaining manufacturer data on e-commerce platforms
- Unified management of manufacturer information in multilingual e-commerce environments
- Enterprises requiring seamless synchronization of external spreadsheet data (Google Sheets) with Shopware 6
- Rapidly building automated workflows for manufacturer data import to reduce manual intervention
Main Workflow Steps
- Manually trigger the workflow to start execution
- Configure Shopware 6 access URL and default language parameters
- Read manufacturer data from a specified Google Sheets spreadsheet, including name, official website, description, and multilingual translation fields
- Use a custom code node to generate the import request payload required by Shopware, supporting multilingual translations and MD5 generation for logo identification
- Iterate through each manufacturer record and call the Shopware synchronization API to batch import manufacturer entries
- Check for the presence of logo URLs; if available, invoke Shopware’s media upload API to complete logo uploading
- Loop through all manufacturer entries to ensure both data and logos are successfully imported
Systems and Services Involved
- Google Sheets: Source of manufacturer base data
- Shopware 6: E-commerce platform receiving manufacturer data and logo uploads
- OAuth2 API Authentication: Secures Shopware API calls
- n8n Automation Platform: Builds and executes the entire workflow
- Custom Code Nodes: Handle complex data transformations and request payload construction
Target Users and Value
- E-commerce operators: Simplify manufacturer data management and improve efficiency
- IT automation engineers: Quickly build automated Shopware data import solutions
- Multilingual e-commerce platform managers: Conveniently maintain multilingual manufacturer information
- Enterprise management: Reduce human errors and ensure data accuracy and consistency
- Any user seeking seamless synchronization of Google Sheets data into Shopware 6’s manufacturer module
This workflow significantly enhances the automation and accuracy of manufacturer data import, helping enterprises save substantial time and labor costs while modernizing data management.