This n8n workflow streamlines the process of importing products from a Google Sheet into a Shopify store. Designed for ease of use, it fetches product data, checks for existing products in Shopify, creates new products with detailed information, and manages inventory levels automatically. The workflow is ideal for store managers, developers, or marketers who want to efficiently bulk upload or update product inventories, especially in testing or staging environments.
The process begins with a manual trigger to start the workflow, which then fetches product data from a specified Google Sheet using OAuth2 credentials. It retrieves store location data once for inventory adjustments. For each product entry, the workflow queries Shopify via GraphQL to determine if the product already exists by its handle (slug). If the product does not exist, it creates a new product with all relevant details, including title, description, vendor, category, status, and a placeholder image.
Next, the workflow enables inventory tracking on the created product variants and sets the available stock at the store’s primary location. This automation ensures that new products are added efficiently, with inventory levels accurately updated, making it a powerful tool for managing large product catalogs with minimal manual effort.
This setup is particularly useful for launching new product lines, updating stock in bulk, or synchronizing Google Sheets with Shopify in a staged environment, ensuring consistency and saving time on manual entry.
Reviews
There are no reviews yet.