Save New Shopify Products to Google Sheets

4 min setup

No coding required

Runs automatically

Export your Shopify product catalog to Google Sheets instantly. This workflow sends product names, prices, inventory levels, and descriptions to a spreadsheet whenever you add items in your store. Perfect for inventory tracking, price analysis, and sharing product data with your team without manual copying.

Set this up in 4 minutes →

Product Created

Loop Over Variants

Add Row

Trusted by 1,000+ Shopify merchants — from solo operators to scaling brands.

How it works

3 steps to start sending your Shopify product data to Google Sheets automatically

App connector: Shopify • Time to complete: 0 minutes (Auto-configured)

Why this matters: This step detects when you add new products to your Shopify store and kicks off the entire workflow to capture all product details.

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.

App connector: Loop • Time to complete: 0 minutes (Auto-configured)

Why this matters: Since each product can have multiple variants (like different sizes or colors), this step processes each variant individually to create separate spreadsheet rows for better inventory tracking.

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.

App connector: Google Sheets • Time to complete: 2 minutes

Why this matters: This step creates the actual spreadsheet entries, turning your product data into organized rows and columns for easy analysis and inventory management.

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.

Ready to start sending your Shopify product data to Google Sheets automatically

Get setup in 4 minutes.

Try this template →

Frequently asked questions

Will this create duplicate rows if I update an existing product?

No, this workflow only triggers on newly created products. If you modify an existing product's details or inventory, it won't add new rows to your spreadsheet. You'd need a separate workflow that triggers on "Product Updated" if you want to track changes to existing products.

Can I exclude certain product variants from being added to the spreadsheet?

Yes, during the setup process you can deselect specific fields you don't want included. However, the workflow will still create a row for every variant - you just control which data columns appear. If you want to filter out entire variants (like only including variants above a certain price), you'd need to add a Filter step.

Make this template your own!

Customize this workflow even further:

Filter by product type or vendor

Add conditions to only export specific categories of products, like only "Electronics" or products from certain vendors, keeping your spreadsheets focused on what matters most.

Send notifications when inventory runs low

Connect inventory quantity data to Slack or email notifications, so your team gets alerted when stock levels drop below your specified threshold.

Calculate profit margins automatically

Use MESA's Transform step to compare your product costs with selling prices, adding calculated profit margin columns to help with pricing decisions.

Sync data to multiple destinations

Export the same product data to Airtable for project management, email marketing platforms for automated campaigns, or accounting software for financial tracking.

"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."

PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

Rothy's

Ready to start sending your Shopify product data to Google Sheets automatically?

7-day free trial • 4 min setup • Cancel anytime

Start with this template — It's free

Need help? Our automation experts will help you personalize this workflow for free. Contact support