Export WooCommerce orders and customers to a Google Sheet — manually with date-range filters (free), or on a schedule, in real-time on new order, with custom column mapping (PRO).
CSV export is fine for once a quarter. For everything else — weekly reports, live VAs, accountant feeds, marketing dashboards — you want orders to just appear in a Google Sheet. Without paying for Zapier per task.
Every Monday "let me pull last week's orders" — open admin, download CSV, upload to Sheets, fix encoding. PRO's scheduled export removes the whole ritual.
Real-time order → Sheet via Zapier costs ~€20/month per ~1000 orders. PRO does the same thing for €0/order via WP cron + direct Sheets API.
You already have formulas referencing column A, C and F. PRO's column mapping lets you reshape the export so columns line up — no manual reshuffling after every export.
52 weekly export files per year is noise. PRO's append-mode means one growing sheet — diff-able, searchable, sortable, with no version chaos.
All inside WP-admin under WooCommerce → Sheets Export.
Connect
One-time OAuth 2.0 with your own Google Cloud project. Spreadsheets scope only — the plugin can't see your Drive, only its own files.
Export (free)
Pick Orders or Customers, set a date range, click Export. A fresh sheet opens with formatted headers, frozen first row, dark header background.
Automate (PRO)
Add a schedule (daily/weekly/monthly), a target sheet ID for append-mode, a column map for renaming headers, and turn on real-time append on new order. Set once, runs forever.
No upsell tax on basic functionality — every column, every filter, every status is in the free version.
The core feature, no limits.
"Last week's orders, every Monday."
Live order feed in Sheets.
woocommerce_checkout_order_processedOne growing sheet, not 52 files.
Shape the export to your template.
Built on standard WooCommerce + Google APIs.
wc_get_orders() onlyFree + PRO run on standard WordPress + WooCommerce + your own Google Cloud project. The PRO updater talks to the OCW License Server — that's the only external dependency PRO adds.
Free is for occasional, manual exports. PRO is for shops where the Sheet is part of the workflow.
OCW Orders to Sheets for WooCommerce
Manual export, no limits.
Free forever · 1 site
No signup, just your own Google Cloud project.
OCW Orders to Sheets for WooCommerce PRO
For shops that live in Sheets.
per year · 1 site · excl. VAT
Per year. Instant access after payment. Cancellable annually.
Answers to the questions I get most often.
Do I need a Google service account?
No. The plugin uses standard OAuth 2.0 with your own Google Cloud project. Create a project, enable the Sheets API, generate OAuth credentials, paste them in the settings. The plugin only gets the spreadsheets scope — it can't read your Drive or other sheets you didn't create with it.
What's the difference between scheduled and real-time?
Scheduled runs once a day/week/month and produces one sheet with all orders in that period. Real-time appends a row to a configured sheet on every individual order, within seconds of checkout. You can use both at the same time.
Will real-time append slow down checkout?
The Google Sheets API call adds ~300–600 ms after the order is already processed (we hook into woocommerce_checkout_order_processed, which runs after the order is saved). If the API call fails, the order still completes normally.
What happens if my OAuth token expires?
The plugin automatically refreshes the access token using the long-lived refresh token Google issued during initial connection. You only need to re-authorize if you revoke access in your Google account or change the Client Secret.
Can I move a PRO license to another domain?
Yes. Clear the key on the old site (this triggers /deactivate on the license server) and enter it on the new site. Single Site = 1 active domain at a time.
Does the column mapping affect real-time append too?
It applies to the manual export and scheduled export flows. Real-time append currently uses a fixed 13-column order row format so it can write a single row fast; column mapping for real-time is on the roadmap.
This is how OCW Orders to Sheets for WooCommerce shows up in the WordPress.org plugin directory and in your plugins list — look for the teal-and-pink OCW style.
