Save New Shopify Products to Google Sheets

The trigger activates whenever you create a new product in your Shopify admin. It automatically captures all product information including the main product details and all variants (different sizes, colors, etc.). No configuration is needed - the trigger connects to your Shopify store through MESA's built-in integration and monitors for new products in real-time.

This step takes the product data from the trigger and loops through each variant to process them one at a time. For example, if you create a t-shirt with Small, Medium, and Large sizes, this loop will run three times - once for each size. The system automatically identifies all variants within the product and prepares the data for individual spreadsheet rows, making your inventory tracking more granular and useful.

The Add Row step creates a new Google Sheets spreadsheet with your chosen name and adds one row for each product variant processed by the loop. You'll configure the spreadsheet name during setup and select which product fields to include as columns (Title, ID, Description, Vendor, Variant Price, SKU, Inventory Quantity, etc.). Each time the workflow runs, it adds new rows with the current product data, building a comprehensive inventory database over time.