Effortlessly Import Manufacturers into Shopware 6 from Google Sheets
detail.loadingPreview
Automate the tedious process of adding new manufacturers to your Shopware 6 store. This workflow seamlessly imports manufacturer data, including logos and multilingual translations, directly from a Google Sheet, saving you valuable time and reducing manual errors.
About This Workflow
Tired of manually entering manufacturer details into your Shopware 6 backend? This n8n workflow streamlines the entire process. It reads your manufacturer data from a Google Sheet, processes it to create the necessary API payloads for Shopware, and handles the import of logos and multilingual descriptions. By leveraging the power of automation, you can ensure your product catalog is always up-to-date with accurate manufacturer information, enabling a richer shopping experience for your customers and a more efficient backend for your team.
Key Features
- Google Sheets Integration: Easily connect to your existing Google Sheets for manufacturer data.
- Automated Data Processing: Converts your spreadsheet data into Shopware's required API format.
- Logo Upload: Automatically uploads and associates manufacturer logos from provided URLs.
- Multilingual Support: Facilitates the import of manufacturer names and descriptions in multiple languages.
- Upsert Functionality: Updates existing manufacturers or creates new ones efficiently.
How To Use
- Configure Shopware URL: In the 'Settings' node, update
shopware_urlwith your Shopware 6 instance URL. - Prepare Google Sheet: Create a Google Sheet with columns like
name(unique identifier),website,description,logo_url, and optional translation columns (translation_language_code_1,translation_name_1,translation_description_1, etc.). - Connect Google Sheets: In the 'Get Manufacturer from Google Sheet' node, configure your Google Cloud credentials and specify the Sheet ID and range.
- Set Up Shopware API Credentials: In the 'Upload Manufacturer Logo' and 'Import Manufacturer' nodes, configure your Shopware 6 API credentials (e.g., OAuth2 API).
- Map Logo URL: Ensure the
logo_urlcolumn in your Google Sheet contains valid URLs to the manufacturer logos. - Execute Workflow: Click the 'Execute Workflow' button to start the import process. Monitor the node executions for any errors or successful imports.
Apps Used
Workflow JSON
{
"id": "eb8a6157-b08c-4414-ae2e-688dae5c0acc",
"name": "Effortlessly Import Manufacturers into Shopware 6 from Google Sheets",
"nodes": 12,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: eb8a6157-b08c...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.