Sync WooCommerce Orders to Google Sheets

WooCommerce stores the canonical order data in your WordPress database, but accessing that data for day-to-day operations is surprisingly painful. Want to share today's orders with your fulfillment team? You need to export a CSV, email it, and repeat tomorrow. Want your accountant to reconcile revenue? They need wp-admin access or a manual spreadsheet you update by hand.

Google Sheets eliminates these bottlenecks. A live spreadsheet that updates on every order gives your entire team - operations, accounting, customer service - a single source of truth without anyone needing WordPress access.

For stores doing $10K-$500K per month, Sheets is often the right level of tooling. It is more flexible than WooCommerce's dashboard, cheaper than a dedicated BI platform, and more collaborative than any WordPress plugin's reporting screen.

SheetLinkWP's WooCommerce add-on ($29/month) extends the core plugin with deep WooCommerce integration.

Order data - Order ID, status, date created, date completed, order total, subtotal, tax, shipping cost, discount amount, payment method and transaction ID, coupon codes used, customer note and internal notes.

Line items - Product name, SKU, quantity, line total, variation attributes (size, color, etc.). You can choose flat mode (one row per order with items concatenated) or expanded mode (one row per line item).

Customer data - Billing name, email, phone, billing and shipping addresses, customer lifetime order count and total spend (calculated automatically).

Event triggers - You control which WooCommerce events push data: new order, order updated, order completed, order refunded, or all of the above.

1. Install SheetLink Forms and activate the WooCommerce add-on - Install SheetLink Forms from sheetlinkwp.com. Then log into your SheetLinkWP account, download the WooCommerce add-on, and upload it to your site. Activate both plugins.
2. Create your orders spreadsheet - Create a new Google Sheet. We recommend three tabs: Orders (one row per order), Line Items (one row per product per order), and Customers (deduplicated customer list).
3. Deploy the Apps Script endpoint - In your Google Sheet, go to Extensions > Apps Script, paste the SheetLink connector script, and deploy as a web app. Copy the webhook URL.
4. Configure WooCommerce sync settings - In SheetLink > WooCommerce, paste the webhook URL. Select which order events to listen for, choose which fields to include, and pick your line item mode.
5. Backfill historical orders (optional) - Click the Backfill button to export existing orders to your Sheet. You can filter by date range and order status.
6. Verify with a test order - Place a test order and confirm it appears in your Google Sheet within seconds.

Fulfillment tracking - Share the Orders tab with your warehouse team or 3PL. They can filter by status, sort by date, and mark orders as shipped - all without WooCommerce access. Add a "Tracking Number" column they fill in manually.

Inventory dashboards - Use a pivot table on the Line Items tab to see units sold by product and SKU over any date range. Set up conditional formatting to highlight when a product sells more than X units in a day.

Accountant access - Share a read-only link with your bookkeeper. They get a live feed of order totals, tax collected, refunds processed, and payment methods.

Revenue reporting - Build a summary tab with SUMIFS formulas to calculate daily, weekly, and monthly revenue. Add a chart and you have a real-time revenue dashboard.

SheetLinkWP's optional Two-Way Sync add-on ($29/month) enables changes made in Google Sheets to flow back to WooCommerce. This means you can update an order status, edit a customer's address, or adjust a product price directly in your spreadsheet and have it reflected in your store.

Two-way sync includes echo suppression - when a change originates in Sheets and is pushed to WooCommerce, the resulting WooCommerce webhook does not re-push the same data back to Sheets, preventing infinite loops.

This is useful for teams that prefer working in Sheets but need WooCommerce to stay in sync.