WooCommerce to Google Sheets
Sync WooCommerce orders, products, and customers to Google Sheets in real time. Bidirectional sync keeps your spreadsheets and store in lockstep - no per-order fees, no Zapier.
Requires WooCommerce add-on ($29/month)
Why WooCommerce Stores Need Sheets Sync
Google Sheets is the operational backbone for small-to-mid-size e-commerce - inventory planning, fulfillment tracking, dashboards, supplier communication. The gap between WooCommerce and Sheets is where data gets lost, decisions get delayed, and manual work piles up.
Current Alternatives and Their Limits
- Zapier: per-order charges, 500 orders/month burns the Starter plan, status changes count as separate tasks
- WPSyncSheets for WooCommerce ($49/yr): one-directional only, no conditional routing, no GDPR tools
- Manual CSV exports: free but entirely manual - acceptable for weekly reporting, not for real-time operations
- Custom Google Sheets API development: full control but significant dev time and ongoing maintenance
How to Connect WooCommerce to Google Sheets
Step-by-step setup guide
- 1
Install SheetLink & Activate WooCommerce Add-on
Install the free SheetLink Forms plugin, then activate the WooCommerce module from SheetLink > Add-ons. Requires a $29/month subscription.
- 2
Deploy Apps Script Webhook
Open your Google Sheet, go to Extensions > Apps Script, paste the WooCommerce-enhanced receiver, deploy as web app, and copy the URL.
- 3
Configure Data Streams
Go to SheetLink > WooCommerce. Toggle data types (Orders, Products, Customers), map fields, and configure order status triggers.
- 4
Enable Bidirectional Sync (Optional)
Toggle two-way sync for inventory, status, or price updates from Sheets back to WooCommerce. Echo suppression prevents infinite loops.
- 5
Test with Sample Order
Place a test order, verify data in your Sheet - check line items, shipping, tax, and customer details.
SheetLinkWP Features for WooCommerce Users
Bidirectional Sync
Changes in Sheets (inventory, prices, order status) push back to WooCommerce. Echo suppression with origin tracking prevents infinite loops.
Order Status Triggers
Configure which status changes trigger sync: fulfillment tracking, full lifecycle, or revenue reporting only.
Line Item Handling
Two modes: flatten (single row with delimited values) or expand (one row per line item with order data repeated).
Product & Customer Sync
Beyond orders - sync product catalog (SKU, stock, prices, attributes) and customer data (spend, orders, addresses).
No Per-Order Fees
Flat $29/month covers unlimited orders, products, and events. Cost stays the same at any volume.
Feature Comparison
| Feature | Zapier | WPSyncSheets | SheetLinkWP |
|---|---|---|---|
| Monthly cost | $29.99–$99+ | ~$4/mo ($49/yr) | $29 |
| Per-order fee | Yes (tasks) | No | No |
| Bidirectional sync | Separate Zaps | No | Yes (echo suppression) |
| Line item handling | Limited | Basic | Flatten or expand |
| Order status triggers | Single trigger | All statuses | Configurable per status |
| Product sync | Separate Zap | Yes | Yes |
| Customer sync | Separate Zap | Limited | Yes |
| Retry queue | Paid tiers | No | Yes |
Frequently Asked Questions
Is the WooCommerce module included in the free SheetLinkWP plugin?
No. It's a paid add-on at $29/month. The free plugin covers form-to-Sheets sync for 7 form plugins.
How does bidirectional sync work?
Changes in Sheets (inventory, status, prices) push to WooCommerce via Apps Script. Echo suppression with origin tracking prevents infinite update loops.
How are WooCommerce line items handled?
Two modes: flatten into a single row with delimited values, or expand with one row per line item (order data repeated on each row).
Does it sync in real time or on a schedule?
Real time. SheetLinkWP hooks into woocommerce_new_order and woocommerce_order_status_changed for immediate delivery.
How does SheetLinkWP compare to WPSyncSheets for WooCommerce?
WPSyncSheets is $49/year and one-directional only. SheetLinkWP is $29/month with bidirectional sync, echo suppression, configurable triggers, and GDPR tools.
Other Supported Integrations
Sync Your Store to Sheets - Both Directions, Real Time
Orders, products, and customers. No per-order fees. Bidirectional sync with echo suppression.