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 the Pro tier ($79/yr or $199 lifetime)
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 Sync module from SheetLink > Add-ons. Included in the Pro tier ($79/yr or $199 lifetime).
- 2
Connect Your Google Sheet
For one-way sync, click Connect Google for the one-click connect and pick or create a spreadsheet with the Google file picker. For bidirectional sync, use the classic method: open your Google Sheet, go to Extensions > Apps Script, paste the WooCommerce-enhanced receiver, deploy as web app, and paste the URL into SheetLink.
- 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
Included in the Pro tier with no per-order fees - 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) | Pro $79/yr (flat) |
| 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. WooCommerce Sync is part of the Pro tier ($79/yr or $199 lifetime). The free plugin covers form-to-Sheets sync for 12 form plugins.
How does bidirectional sync work?
Changes in Sheets (inventory, status, prices) push to WooCommerce via the WooCommerce-enhanced Apps Script receiver - the classic self-hosted connection method. 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's Pro tier ($79/yr or $199 lifetime) includes 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.