Fresh Sheets
Start free trialAdd to Google Sheets

Shopify orders in Google Sheets, refreshed on a schedule

Your Shopify orders, and the products and variants sold in them, current before you open the file.

Start free trialOr install the Google Sheets add-on

30 days of Plus, free from sign-up. No card needed.

The report builder's first step, with Shopify chosen as the source and its account picked.

What you can pull from Shopify

Choose orders or products sold, then the fields you want from that report.

Orders
DayWeek startingMonthOrderSales channelPayment statusFulfilment statusCancelledCurrency
OrdersSubtotalDiscountsShippingTaxTotalRefundedNet payment
Products sold
DayWeek startingMonthProductVariantSKUVendorCurrency
Units orderedUnits keptSales before discountsLine discounts (excluding order discounts)

Amounts are in your store's own currency, and days are your store's days. Test orders are left out.

Yesterday's orders, already in the tab

06:20

Shopify, written to Products sold

Canvas tote £1,840.00
Ceramic mug £1,392.00
Linen apron £906.00
Enamel pin £348.00
  • Each report owns a tab, and everything in it is replaced on every refresh. Nothing else in the spreadsheet is touched.

Also works with BigQuery, Excel and Claude.

Shopify orders to Google Sheets, in three steps

  1. In your Shopify admin, create an app with the two order-reading permissions and install it. On the Sources page, choose Connect store and enter the store address, client ID and client secret, then choose Check and save.
  2. Pick orders or products sold, the fields you want, and a date range.
  3. Choose the tab, worksheet or table it writes to, and how often it refreshes.

Try it with your own Shopify data.

Start free trialOr install the Google Sheets add-on

Other ways to do it

Shopify can export your orders as a CSV file from the Orders page of your admin.

Source: Shopify Help: Export orders

Fresh Sheets writes the figures straight into your tab instead.

Guides that use Shopify

Show all 26 Shopify guides

What it can see, and what it cannot

Fresh Sheets connects to Shopify through an app your store creates. In your Shopify admin, go to Settings, then Apps, then Develop apps, which opens Shopify's Dev Dashboard. No code is involved: create the app, give it read access to orders, install it on your store, and copy its client ID and secret into Fresh Sheets. Only the store owner, or staff with permission to develop apps, can create it.

Fresh Sheets requires the scopes read_orders and read_all_orders on that app, and checks its client ID and secret with Shopify before saving them. Credentials Shopify will not give access with, or an app that cannot read orders from any date, are refused and nothing is stored. The second scope, read_all_orders, is what lets reports go back more than 60 days.

Our code only ever reads from Shopify, even if the app you create allows more. It sends Shopify nothing but read queries and a request for a short-lived access token, and it refuses anything else before the request is sent. It never creates, edits or deletes an order, a product or anything else in your store.

It never asks Shopify for a customer's name, email address, postal address or phone number.

Shopify app credentials are stored encrypted and are never shown back to you. You can replace or remove them at any time on the Sources page. Removing them stops the reports that read through them and leaves what they already wrote in your spreadsheets. It does not uninstall the app from your store, which is yours to uninstall there.

Fresh Sheets never changes anything you did not ask it to.

Your data is never sold and never used to train anything.

How we handle your data

Start on Plus, and decide later

Then one report keeps refreshing weekly.

How often depends on your plan: every day on Plus, every 6 hours on Pro and every hour on Max.

See what the paid plans include

Questions

Can you export Shopify orders to Google Sheets?

Yes. Fresh Sheets writes your Shopify orders, or the products sold in them, into a spreadsheet you already have, in a tab you choose, on a schedule, without the file being open.

Are refunds and cancelled orders included?

Cancelled orders are included. In an orders report the Cancelled column tells them apart; a products sold report counts their items too. Refunded shows what has been refunded on an order, counted on the day the order was placed. Test orders are left out.

Which currency?

The store's, summed exactly. If a report mixes currencies, include the Currency column, or the run stops rather than add pounds to dollars.

How often can it refresh?

Daily on Plus, every 6 hours on Pro and every hour on Max. On Free, one report refreshes weekly.

How many orders can a report have?

Up to 10,000 orders a run, and for the products sold report, no more than 250 line items in any one order. A report that would go over either doesn't run, and tells you how to bring it under.

Does it change anything in Shopify?

No. Fresh Sheets only reads from Shopify. It never creates, edits or deletes an order, a product or anything else in your store.

Who can set it up?

The store owner, or staff with permission to develop apps. Collaborator accounts cannot create the app, so if you manage a store for a client, the owner creates it and shares the client ID and secret with you.

Pull from more than one place

Analytics

Advertising

Email

See all connectors

Set up your first Shopify report

Add your app credentials, pick your fields and a tab, and leave it running.

Start free trialOr install the Google Sheets add-on

30 days of Plus, free from sign-up. No card needed.