How to Connect Shopify to Google Sheets

Shopify exports orders to CSV from the admin in about two minutes, which settles most one-off requests. If you need numbers that refresh, you are going through the Admin API, and there is one behaviour worth knowing before you start: by default the API only returns orders from the last 60 days, and it hides the rest silently rather than telling you. This guide covers the CSV route, the free GraphQL method with that scope problem solved, and the cost-based rate limiting that makes large pulls slow if you query carelessly.

The two-minute option: admin CSV export

In your Shopify admin go to Orders (or Products, or Customers), apply any filters you want, and click Export. Small exports download immediately; larger ones are emailed to you as a file, which can take a few minutes. Import the result into Sheets via File → Import.

One structural detail to expect: the orders export writes one row per line item, not per order. An order containing three products becomes three rows, with order-level fields such as the total repeated or left blank on the continuation rows. Summing the total column without deduplicating by order ID will overstate revenue, and this catches people every time.

Shopify to Google Sheets for free (Apps Script + GraphQL)

In your Shopify admin, go to Settings → Apps and sales channels → Develop apps, create an app, and configure its Admin API scopes. You want read_orders and read_products, and critically read_all_orders if you need anything older than 60 days. Install the app to reveal the Admin API access token, which begins shpat_.

Build on the GraphQL Admin API rather than REST. Shopify has made GraphQL the primary interface and has been retiring REST admin endpoints, so REST-based tutorials are on borrowed time. Pagination is cursor-based: ask for up to 250 records, read pageInfo.hasNextPage and pageInfo.endCursor, and pass that cursor as after on the next call.

1function importShopifyOrders() {2  const SHOP  = "your-store.myshopify.com";3  const TOKEN = "shpat_XXXXXXXXXXXXXXXX";   // needs read_all_orders for history4  const API   = "2026-07";                   // pin a version; do not use "latest"5 6  const url = "https://" + SHOP + "/admin/api/" + API + "/graphql.json";7  const rows = [];8  let cursor = null;9 10  // Request only the fields you need. Query cost scales with what you ask11  // for, and a lean query drains the rate-limit bucket far more slowly.12  const query = `13    query Orders($cursor: String) {14      orders(first: 250, after: $cursor, sortKey: CREATED_AT) {15        pageInfo { hasNextPage endCursor }16        nodes {17          name18          createdAt19          displayFinancialStatus20          customer { email }21          currentTotalPriceSet { shopMoney { amount currencyCode } }22        }23      }24    }`;25 26  do {27    const response = UrlFetchApp.fetch(url, {28      method: "post",29      contentType: "application/json",30      headers: { "X-Shopify-Access-Token": TOKEN },31      payload: JSON.stringify({ query: query, variables: { cursor: cursor } }),32      muteHttpExceptions: true,33    });34 35    const body = JSON.parse(response.getContentText());36    if (body.errors) throw new Error(JSON.stringify(body.errors));37 38    const orders = body.data.orders;39    orders.nodes.forEach((o) => {40      rows.push([41        o.name,42        o.createdAt,43        o.displayFinancialStatus,44        o.customer ? o.customer.email : "",       // null for guest checkouts45        o.currentTotalPriceSet.shopMoney.amount,46        o.currentTotalPriceSet.shopMoney.currencyCode,47      ]);48    });49 50    cursor = orders.pageInfo.hasNextPage ? orders.pageInfo.endCursor : null;51    if (cursor) Utilities.sleep(500);   // let the cost bucket refill52  } while (cursor);53 54  const header = ["Order", "Created", "Status", "Email", "Total", "Currency"];55  const ss = SpreadsheetApp.getActiveSpreadsheet();56  const sheet = ss.getSheetByName("Orders") || ss.insertSheet("Orders");57  sheet.clearContents();58  sheet.getRange(1, 1, 1, header.length).setValues([header]);59  if (rows.length) {60    sheet.getRange(2, 1, rows.length, header.length).setValues(rows);61  }62}

Three details in that code worth spelling out. The API version is pinned: Shopify releases quarterly versions and drops support for old ones, so hard-coding a version means your script breaks on a date you choose rather than unpredictably. Money is returned as a MoneySet with separate shop and presentment currencies, which matters the moment you sell in more than one currency. And customer is null on guest checkouts, so reading o.customer.email directly throws on the first guest order in the result.

Limits: Apps Script's six-minute ceiling means a store with tens of thousands of orders needs the import chunked by date range across several runs. Rate limiting is cost-based rather than per-request, so the fix for throttling is usually to request fewer fields rather than to sleep longer.

The Brooked method

Brooked handles the cursor pagination, respects the cost budget so large stores import without tripping throttles, and flattens the nested money and customer objects into plain columns. Orders arrive one row per order, with line items available as a separate table, so revenue totals are correct without deduplication.

Step 1: Install Brooked

Install Brooked from the Google Workspace Marketplace. Free tier includes 100 imports per month, no credit card required.

Step 2: Connect Shopify

Choose Shopify in Brooked, enter your .myshopify.com domain and the Admin API access token from your custom app. If you plan to report on more than the last two months, make sure the app was granted read_all_orders before you install it, since adding the scope later requires reinstalling the app.

Step 3: Schedule the refresh

Set the import to re-run hourly, daily or weekly. Because it re-reads orders rather than listening for order-created webhooks, a scheduled refresh also picks up orders that were edited, refunded or cancelled after they were first placed, which append-on-webhook setups miss entirely.

Brooked AI, Shopify

Live

Ask anything about your Shopify data…

Method comparison

Common use cases

• Revenue reporting: daily sales by product, channel or region in a sheet finance already works from
• Cohort analysis: measure repeat purchase rate and lifetime value across the full order history
• Inventory planning: join stock levels against sales velocity to forecast reorder points
• Ad attribution: combine Shopify orders with ad spend from other sources to compute true ROAS
• Bulk price updates: edit prices in a sheet and write them back rather than clicking through the admin

Troubleshooting common issues

Related Articles

• How to Connect WooCommerce to Google Sheets
• How to Connect Pipedrive to Google Sheets
• How to Connect Monday.com to Google Sheets

Frequently asked questions