Automate Manufacturer Imports from Google Sheets to Shopware 6

This workflow automates the tedious task of importing manufacturer data from Google Sheets to Shopware 6, enhancing your e-commerce experience. By using this workflow, you can save time and reduce manual errors associated with data entry. It leverages a webhook to trigger the import process, ensuring seamless integration between your records and your online store.

The workflow begins with a manual trigger, allowing you to execute the import whenever you're ready. It then fetches the necessary settings, including your Shopware URL and default language settings. This ensures that all data is formatted correctly and directed to the right destination.

As the workflow processes the input data, it constructs a request body that includes all manufacturer information, such as names, descriptions, and logos. This is done through a custom code node that handles the creation of MD5 hashes for media IDs, ensuring data integrity.

Finally, the workflow concludes by sending the import request to Shopware 6, effectively populating your store with the latest manufacturer data from Google Sheets. This automation not only improves efficiency but also enhances your ability to manage and update product information in real-time.