Add products to Shopify from new Google Sheets rows
Every time a new row is added to a selected Google Sheets spreadsheet, Make (formerly Integromat) will automatically create a new product in Shopify. The template uses this example spreadsheet.
Software used in this automated workflow example
Every time a new row is added to a selected Google Sheets spreadsheet, Integromat will automatically create a new product in Shopify. The template uses this example spreadsheet.
Have you ever imagined a solution for creating products in Shopify automatically, without creating them by hand one by one? Do you wish it would be possible to upload a couple of products to Shopify directly from a spreadsheet?
With this scenario you can enter the products details such as SKU, product quantity, description , title for the products directly into a Google sheet. Even better, you can start adding products continuously to your Google Sheet. Every time you add a new product to the sheet a new product will be created in Shopify. In this scenario, we demonstrate how to automate the process of adding new products.
Using this Shopify product creation automation you will save time and avoid human error. You can also connect your Google sheet to other tools and use them together as a source of products.
New products are created as Draft or Published, you can add variant details or keep it really top level and finish adding further product details inside Shopify.
Step by step instructions
Log in to your Integromat account.
Create a new scenario.
Search for the Google Sheets app and select the Watch for new rows in a table trigger.
Select the spreadsheet you want to use and enter the range of the table.
Select the Create a product in Shopify action.
Select the Shopify connection you want to use.
Enter the product details.
Run the scenario.
Business use case example
This scenario could be used to automatically add products to Shopify from a Google Sheets spreadsheet.