How to Connect WooCommerce to Google Sheets

WooCommerce has a capable REST API, and connecting it to Sheets is straightforward once two self-hosted quirks are out of the way: the API returns 404 on every route if WordPress permalinks are set to Plain, and many shared hosts strip the Authorization header so valid credentials arrive as 401. This guide covers both, plus pagination, line-item structure, and the free CSV route.

The built-in option: CSV export

WooCommerce ships a product CSV exporter at Products → All Products → Export, which handles the catalogue including custom meta. Orders are the gap: core WooCommerce has no built-in order exporter, so store owners typically add a free plugin for that. Import the resulting file into Sheets via File → Import.

WooCommerce to Google Sheets for free (Apps Script + REST API)

Generate credentials under WooCommerce → Settings → Advanced → REST API → Add key. Choose Read permission for reporting, and copy the consumer key (ck_…) and consumer secret (cs_…) immediately, since the secret is only shown once.

Before writing any code, confirm two things. Under Settings → Permalinks, the structure must not be Plain, or /wp-json/ does not exist at all; set it to Post name and re-save to flush the rewrite rules. And confirm the store is served over HTTPS: WooCommerce accepts basic auth over HTTPS, but over plain HTTP it requires OAuth 1.0a request signing, which is far more work.

1function importWooOrders() {2  const STORE  = "https://yourstore.com";3  const KEY    = "ck_XXXXXXXXXXXX";4  const SECRET = "cs_XXXXXXXXXXXX";5 6  // Query-string auth avoids hosts that strip the Authorization header.7  // It is acceptable over HTTPS; never do this over plain HTTP.8  const auth = "consumer_key=" + KEY + "&consumer_secret=" + SECRET;9 10  const rows = [];11  let page = 1;12 13  while (true) {14    const url = STORE + "/wp-json/wc/v3/orders"15      + "?per_page=100&page=" + page          // 100 is the maximum16      + "&after=2026-01-01T00:00:00"          // narrow the window where you can17      + "&" + auth;18 19    const response = UrlFetchApp.fetch(url, { muteHttpExceptions: true });20    if (response.getResponseCode() !== 200) {21      throw new Error(response.getResponseCode() + ": " + response.getContentText());22    }23 24    const orders = JSON.parse(response.getContentText());25    if (!orders.length) break;26 27    orders.forEach((o) => {28      // One row per order, with line items summarised. Writing one row per29      // line item instead would repeat the order total and inflate revenue.30      rows.push([31        o.number,32        o.date_created,33        o.status,34        o.billing.email,35        o.total,                                    // string, not a number36        o.currency,37        o.line_items.map((li) => li.name + " x" + li.quantity).join("; "),38        o.line_items.reduce((n, li) => n + li.quantity, 0),39      ]);40    });41 42    if (orders.length < 100) break;43    page++;44  }45 46  const header = ["Order","Created","Status","Email","Total","Currency","Items","Units"];47  const ss = SpreadsheetApp.getActiveSpreadsheet();48  const sheet = ss.getSheetByName("Orders") || ss.insertSheet("Orders");49  sheet.clearContents();50  sheet.getRange(1, 1, 1, header.length).setValues([header]);51  if (rows.length) {52    sheet.getRange(2, 1, rows.length, header.length).setValues(rows);53  }54}

Two details worth noting. WooCommerce returns monetary values as strings, so o.total lands as text and needs coercing before Sheets will sum it. And the decision the code makes explicitly, one row per order with items summarised, is the one that keeps revenue totals correct; flattening to one row per line item repeats the order total on every row.

Limits: Apps Script stops at six minutes, so large stores need chunking with after and before across runs. Paging deep into a big order table also gets slow on modest hosting, since each page is a database query on the store itself.

The Brooked method

Brooked handles the pagination, coerces monetary strings to numbers so totals sum correctly, and imports orders and line items as separate related tables so you can report at either grain without double counting. Products, customers and coupons import the same way.

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 WooCommerce

Choose WooCommerce in Brooked and enter your store URL with the consumer key and secret. Use a Read-only key unless you intend to write back. Confirm permalinks are not set to Plain first, since that single setting breaks every REST route.

Step 3: Schedule the refresh

Set the import to re-run hourly or daily. A scheduled re-read also picks up orders whose status changed after they were placed, refunds and cancellations in particular, which webhook-driven append-only feeds never revisit.

Brooked AI, WooCommerce

Live

Ask anything about your WooCommerce data…

Method comparison

Common use cases

• Sales reporting: daily and monthly revenue by product, category or coupon
• Inventory planning: join stock levels against sales velocity to set reorder points
• Customer analysis: repeat purchase rates and lifetime value from order history
• Bulk price updates: edit prices in a sheet and write them back rather than clicking through wp-admin
• Multi-store roll-ups: combine several WooCommerce stores into one reporting table

Troubleshooting common issues

Related Articles

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

Frequently asked questions