Home/ Marketplace/ WordPress/ WooCommerce → Google Sheets
WooCommerce
Google Sheets

Order Reporting

WooCommerce → Google Sheets Integration

Your WooCommerce orders, line by line, in a Google Sheet that keeps itself up to date — and not a single extra plugin running on your WordPress site.

Free Trial
£6.99
per month after 1 month free trial
Start Free Trial
🛒 Platform: WooCommerce 📊 Destination: Google Sheets 🧩 No plugin to install 📱 Full support included ❌ Cancel anytime

What It Does

WooCommerce keeps every order you have ever taken, but getting them out in a shape you can actually work with usually means a CSV export, or yet another plugin running on the same server as your checkout.

This integration reads your orders from the outside, through WooCommerce’s own REST API with a read-only key, and writes them into a Google Sheet you own. Your order history is imported at setup; after that each new order lands on its own, and changes — a refund, a cancellation, an order moving to completed — are reflected rather than left stale.

  • Your order history backfilled into the sheet at setup
  • One row per order, plus an optional line-item tab with SKU, quantity and price
  • Coupon codes and discounts, shipping, tax and totals on every order
  • Order status kept current as orders move through processing and completed
  • Refunds reflected, so the sheet never overstates your takings
  • Your own columns, formulas and extra tabs are left alone

Nothing to Install on Your Site

🧩

No plugin

We connect through the REST API that ships with WooCommerce. Nothing to install, update, or clash with your theme and other plugins.

No load on checkout

Orders are read in small batches from our side, so your server is never running a sync job while customers pay. The first import is paced to stay gentle.

🔒

Read-only by design

The key you create can read orders and nothing else. Delete it in WooCommerce and we are switched off instantly.

How It Works

1
Create a Read-Only KeyIn WooCommerce → Settings → Advanced → REST API, create a key with Read permission. We send exact steps, and a secure link to hand it over — never by email.
2
Your Orders Are ImportedWe agree a start date and fill the sheet in one pass, so it opens with your real history rather than an empty tab.
3
It Stays CurrentNew orders are added within minutes, and status changes and refunds update the rows already there.

Frequently Asked Questions

What's the cost to run this?

£6.99 per month after a free first month. That covers the integration, ongoing updates and support — no per-order or per-row fees on top.

Do I need to install a plugin?

No. We use the REST API that is built into WooCommerce itself, so nothing new runs on your WordPress site. All you do is create a read-only key in your WooCommerce settings, and we walk you through that.

Will it slow my site down?

No. Orders are read in small batches through the API rather than by a job running on your server, and the first import of your history is paced — it can run overnight if your store is large. Your checkout is never waiting on us.

Does it work with HPOS?

Yes. The REST API returns orders the same way whether your store uses High-Performance Order Storage or the older posts table, so nothing changes if you migrate later.

Which orders are included?

Processing, completed and on-hold orders by default, with refunds reflected against the original order. Pending-payment and failed orders are left out so abandoned checkouts do not pad your numbers — if you want them logged, we can add them on a separate tab.

What columns do I get?

The defaults cover what most stores need:

  • Order number, date and status
  • Customer name, email, and billing and shipping country
  • Subtotal, coupon codes and discount, shipping, tax and order total, with currency
  • Payment method
  • Items with SKU, quantity and line total, on a line-items tab

If you report differently, tell us at setup and we will shape the sheet around how you work.

How are refunds handled?

WooCommerce records refunds separately from the original order. We pick them up and reflect them in the sheet, so a refunded order does not keep showing as full revenue. Partial refunds show the amount actually refunded.

Does it work with WooCommerce Subscriptions?

Yes. Each renewal is an ordinary WooCommerce order, so it arrives in the sheet as its own row like any other sale.

What credentials do you need?

Two narrow ones. A read-only WooCommerce REST API key, which can read orders but cannot change prices, stock or settings — you hand it over through a secure link we send you, not by email. And edit access to the single Google Sheet you nominate, nothing else in your Drive. Both can be revoked by you at any time.

Can I add my own columns and formulas?

Yes. New orders are appended as rows and we only write to the columns we own, so anything you add — extra columns to the right, extra tabs, charts, pivot tables — keeps working.

What if I edit or delete a row by accident?

Nothing breaks. Orders are tracked by their WooCommerce order number, not by row position, so sorting, filtering or deleting rows never causes an order to be written twice. If you delete one you wanted, ask and we will put it back.

How does cancellation work?

You can cancel any time with 30 days' notice. The sync carries on during the notice period and then stops. The sheet is yours and stays exactly as it is, with everything already in it.

Who are Receptive?

A UK-based development company — Receptive Ltd — with offices in Cardiff and Cheltenham. Led by Ben Johnson, with over two decades' experience in web development and eCommerce integration, much of it on WooCommerce.

Related Products

Free Trial
£6.99
per month after 1 month free trial
Start Free Trial
🛒 Platform: WooCommerce 📊 Destination: Google Sheets 🧩 No plugin to install 📱 Full support included ❌ Cancel anytime

Want it shaped to your store?

Tell us how you report and we’ll set the sheet up around it. We reply within 24 hours.

Contact Us
WordPress Figma Framer Wix Contentful