
Pull orders, sales, products and refunds from every Shopify store you run into one Google Sheet that refreshes itself hourly, daily, weekly or monthly. You won't export a CSV or copy an API key.

Trusted by Agencies and Users Worldwide





Five steps, and you only do them once.
Yes, as a file. On the Orders page of your Shopify admin, click Export. Up to 50 orders download straight to your computer as a CSV. More than that, or orders by date, and Shopify emails you the file. Then you import it into Sheets yourself, each time you want new numbers. An order with several products takes several lines, with most fields left blank on the extra ones.
Shopify Flow and Zapier add rows instead. Flow's Add row to spreadsheet action and Zapier's New Order trigger can write a row each time an order comes in. You get a running list of orders. Last month's sales by day, product or store are still yours to add up.
We pull the report itself, which is what a client report needs: Shopify's own figures, such as Net sales (gross sales minus discounts and returns), grouped by the columns you picked.
| Option | What lands in your sheet | How it stays current |
|---|---|---|
| SyncWith for Google Sheets | Orders, sales, products and refunds, totalled by the columns you pick | Refreshes itself on your schedule |
| Shopify’s CSV export | Orders, one line per product | You export and import again each time |
| Shopify Flow or Zapier | One new row per order or event | Adds a row when it happens |
Yes. Install SyncWith's Shopify app on each store, and you can report on them together or one at a time. Add Store name as a column so every row says which store it came from. You'll want it: order numbers can repeat from one store to the next.
Hourly, daily, weekly or monthly, whichever you set. Our Shopify reports average a bit more than one refresh a day: in Q3 2026, 4,332 Shopify reports in SyncWith's Google Sheets add-on and Looker Studio connectors refreshed 502,674 times. Shopify was our fourth most connected source that quarter, with 1,549 new connections.

Access all the data from your Shopify stores, and break it down how you want, for example by month, by sales channel, by product, or new vs returning customer

Bring together data from multiple Shopify stores into a single auto-updating report.

Combine Shopify data with other sources to see total ad spend and compare results across channels. Then check your store’s sales against that spend in our ROAS calculator.
Track all your top Shopify metrics in one place! Use Google Sheets to power up your Shopify insights:
Report on key Shopify metrics for client updates or internal reviews.
Track sales by:
Group and pivot your sales reports by any level you need: product, variant, warehouse, or break them down by demographics, country, platform, device, and more.
Know exactly what you're selling and what you're short on
Track inventory by:
Your store is full of data, use SyncWith to leverage that data
Export order details including:
Choose the dimensions you want to report on: time period, customer type, product, variant, warehouse country and more.
Manage single or multiple stores: sales, inventory, orders, and more.
Pull all order data including order number, customer, shipping, fulfillment, sales, returns, discounts and more
Report on sales at any level by net sales, total sales, gross sales, include returns, refunds, discounts, line items, and more.
Track current inventory by product, variant, warehouse, and more.
Report on custom metafields, object properties, options, tags, collections and more
SyncWith is simple to configure and totally free to try!

Select Shopify as the data source and access your account. Select the information you want to import.
Select the destination in your Google Sheet and set the desired frequency of automatic updates.
Save the settings and run your report. Then connect your other top channels to build amazing live dashboards.
“This tool is fantastic and the support is amazing. I wish I learned about it way sooner. I can easily pull data from our business and show our customers how they can get their data with the tool and they don't even need developers. Love this!”

Download the SyncWith for Google Sheets Add-on and get started. Get 35 free report refreshes a month. SyncWith’s pricing scales with your needs, up to unlimited refreshes from any service and reports that never expire.