1. Home

Shopify
Shopify to Google Sheets

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.

Ratings
No credit card required.
Shopify to Google Sheets UI

Trusted by Agencies and Users Worldwide

How do you connect Shopify to Google Sheets?

Five steps, and you only do them once.

  1. Install SyncWith for Google Sheets.
  2. Choose Shopify as the source. Shopify sends you to its App Store to install SyncWith's Shopify app: pick your store and click Install app. No custom app to build.
  3. Pick your columns, such as Day, Product title and Product variant SKU, then metrics such as Orders, Net sales and Refunds.
  4. Pick a date range, such as Last 30 days, and how new data is written: replace the sheet each time, or update the rows already there and add new ones below.
  5. Pick how often it refreshes. You're done.

Can you export Shopify orders to Google Sheets without an add-on?

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.

OptionWhat lands in your sheetHow it stays current
SyncWith for Google SheetsOrders, sales, products and refunds, totalled by the columns you pickRefreshes itself on your schedule
Shopify’s CSV exportOrders, one line per productYou export and import again each time
Shopify Flow or ZapierOne new row per order or eventAdds a row when it happens

Can you put several Shopify stores in one sheet?

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.

Two Shopify stores in one Google SheetAn example sheet with the columns Store name, Day, Orders and Net sales. Rows for North Shop and South Shop sit in the same sheet, and the Store name column says which store each row came from.Two stores, one sheetExample rowsStore nameDayOrdersNet sales2North ShopNov 1241$3,1803North ShopNov 1337$2,9054South ShopNov 1218$1,2405South ShopNov 1322$1,515Store name on every row
Example data. Store name, Day, Orders and Net sales are columns in our Shopify source.

How often does a Shopify report refresh?

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.

Shopify Connector for Google Sheets

Shopify dimensions and metrics
Custom reporting

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

Ad accounts
Pull it Together

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

Excel Sheet UI
Merge Sources

    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.

Elevate your Shopify reporting

Track all your top Shopify metrics in one place! Use Google Sheets to power up your Shopify insights:

REPORT ON SALES
Sales insights at a glance

Report on key Shopify metrics for client updates or internal reviews.

Track sales by:

  • Year, month, day, hour
  • Sales channel
  • New vs returning customer
  • Hundreds of other dimensions

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.

TRACK INVENTORY
Stay on top of stock levels

Know exactly what you're selling and what you're short on

Track inventory by:

  • Product
  • Variant SKU
  • Warehouse
EXPORT ORDERS
Pull all your orders into one place

Your store is full of data, use SyncWith to leverage that data

Export order details including:

  • Break sales down by total sales, net sales, gross sales
  • Full customer details, billing and shipping information
  • Pull in fulfillment information including tracking number
  • Custom metafields

Track Shopify Dimensions & Metrics Using SyncWith

Completely customizable

Choose the dimensions you want to report on: time period, customer type, product, variant, warehouse country and more.

Multi Store Reporting

Manage single or multiple stores: sales, inventory, orders, and more.

Orders

Pull all order data including order number, customer, shipping, fulfillment, sales, returns, discounts and more

Sales

Report on sales at any level by net sales, total sales, gross sales, include returns, refunds, discounts, line items, and more.

Inventory

Track current inventory by product, variant, warehouse, and more.

Full fidelity

Report on custom metafields, object properties, options, tags, collections and more

How to Install SyncWith for Google Sheets

SyncWith is simple to configure and totally free to try!

Google Sheets logo
Step 1: Connect to Source

Select Shopify as the data source and access your account. Select the information you want to import.

Step 2: Connect to Destination

Select the destination in your Google Sheet and set the desired frequency of automatic updates.

Step 3: Run & Repeat

Save the settings and run your report. Then connect your other top channels to build amazing live dashboards.

Install SyncWith for Google Sheets

One Add-on for All Your Marketing Channels!

See all Google Sheets Connectors
“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!”
Andy Nadler
Andy Nadler | Accenture
Supercharge Your Shopify Reporting!

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.

Plans Starting at $24.99/month
Try It for Free

No credit card required.

Are beautiful visual dashboards your specialty?
Explore SyncWith Connectors for Looker Studio