Get Shopify orders into Google Sheets

Last checked 23 Sep 2026

There are three ways to get your Shopify orders into a Google Sheets spreadsheet. Two are free and perfectly good for a one-off look. The third keeps itself up to date.

1. Export your orders from Shopify

In your Shopify admin:

1. Go to Orders, and sort and filter the list to the orders you want.
2. Click Export.
3. Choose which orders to export. For a date range, choose Orders by date and set the start and end dates.
4. Under Export as, choose a file format, then click Export orders.

Up to 50 orders download straight away. Larger exports, and exports by date, are emailed to you and the store owner as a CSV file, and a very large one can take hours.

Source: Exporting orders, Shopify Help Center.

Then in Google Sheets:

1. Open a spreadsheet, and click File, then Import.
2. Upload the CSV file.
3. Choose Insert new sheets or Replace current sheet, then click Import.

Source: Import data sets and spreadsheets, Google Docs Editors Help.

Before you build anything on it, know that an order with several items takes several rows, with most of the order's fields left blank on the extra ones, so counting rows won't count orders. The file also includes your customers' names, email addresses, phone numbers and postal addresses, so be careful who you share it with. And it's a snapshot: keeping it current means exporting and importing again.

2. Add a row for each new order with Shopify Flow

Shopify Flow is a free Shopify app on the Basic, Grow, Advanced and Plus plans. Its Add row to spreadsheet action adds a row to a Google Sheets spreadsheet each time a workflow runs.

Source: Shopify Flow and Add row to spreadsheet, Shopify Help Center.

1. Install Shopify Flow from the Shopify App Store and open it from your admin.
2. Create a workflow that runs when an order is created.
3. Add the Add row to spreadsheet action, and connect Flow to a Google account that can edit the spreadsheet.
4. Enter the spreadsheet's URL, the name of an existing tab, and the row contents as a comma-separated list of order fields.

Flow gives you one row per order. Totals by day or week are formulas you build and maintain yourself. Commas inside your data split into extra columns unless you filter them out, which Shopify's help page explains.

3. A report that keeps itself current, with Fresh Sheets

Fresh Sheets writes your orders into a tab of its own and refreshes it on the schedule you choose, so the figures are already there when you open the file. You can report on:

• Orders, by day, week or month: orders, subtotal, discounts, shipping, tax, total, refunded and net payment.
• Products sold: units and amounts for each product or variant.

Days follow your store's time zone, and test orders are left out. Fresh Sheets reads your orders and your store's name, time zone and currency. It never asks Shopify for a customer's name, email address, postal address or phone number.

Only the store owner, or staff with permission to develop apps, can create the app in step 2. If you work on the store as a collaborator, as agencies usually do, ask the owner to create it and send you the client ID and secret securely.

1. Add Fresh Sheets and connect. Install Fresh Sheets from the Google Workspace Marketplace, open a spreadsheet, and choose Fresh Sheets, then Open sidebar. Click Connect this spreadsheet and sign in with your Google account.
2. Create your store's app in Shopify. In your Shopify admin, go to Settings, then Apps, then Develop apps, then Build apps in Dev Dashboard, and create an app. In a new version, add only the scopes read_orders and read_all_orders, then release it. read_all_orders lets reports reach back further than 60 days. Add nothing else: whoever has the client ID and secret gets whatever access the app has. Install the app on your store, then copy the client ID and client secret from its Settings.
3. Connect the store. In the sidebar, click the Shopify row, which says Connect your store first. On your Connections page, enter your store's myshopify.com address, the client ID and the client secret, and click Connect store. Fresh Sheets checks them with Shopify before saving anything.
4. Build the report. Back in the sidebar, choose Shopify, pick Orders or Products sold, then your fields, date range and tab, and how often it should refresh.

Everything Fresh Sheets reports from Shopify is listed on the Shopify connector page.