A live Google Sheet of your WooCommerce orders is one of the most useful things you can set up for a store. It gives you and your team a shared, filterable view of sales without anyone logging into WordPress, and it feeds reports, fulfillment lists, and accounting. The usual way to build it is Zapier, but that means a per-task bill that grows with every order you take.
This guide shows you how to send WooCommerce orders to Google Sheets directly from WordPress, with no code and no per-task fees. Every new order becomes a row automatically.
What you will need
- A WordPress site running WooCommerce.
- A Google account with access to Google Sheets.
- The Advanced Form Integration plugin, which connects the two. The free version adds one row per order with unlimited orders; sending a separate row for each line item in an order is part of Pro.
Why not just use Zapier?
For a busy store, Zapier’s per-task pricing is exactly the wrong shape: the more you sell, the more you pay just to record your own orders. Advanced Form Integration runs on your own site, so there is no task meter and your order data goes straight from WooCommerce to your sheet. For the full comparison, see our guide to the best Zapier alternative for WordPress.
Step-by-step: WooCommerce to Google Sheets
Step 1: Install Advanced Form Integration
In your WordPress dashboard, go to Plugins, then Add New, search for “Advanced Form Integration,” install it, and activate.
Step 2: Connect your Google account
Open Advanced Form Integration, go to the settings, and authorize Google. You will approve access in Google and be returned to your site. This is a one-time step. Create the spreadsheet you want to use, with a header row for the columns you plan to fill.
Step 3: Create a new integration
Click Add New Integration and choose a trigger (WooCommerce) and an action (Google Sheets).
Step 4: Choose WooCommerce as the trigger
Select WooCommerce as the trigger. You can run the integration on a new order, or tie it to a specific order status such as Processing or Completed, so only orders at that stage are logged.
Step 5: Choose Google Sheets as the action
Select Google Sheets and the “Create Spreadsheet Row” action, then pick the spreadsheet and worksheet you prepared.
Step 6: Map order fields to columns
Match WooCommerce order data to your sheet columns, for example order ID, order total, customer name, email, products, and the order date. You can mix in static text and dynamic tags as needed.
Step 7: Add conditional logic (optional)
If you only want to log certain orders, add a rule, for example only orders above a certain total, or only orders that used a particular payment method.
Step 8: Save and test
Save the integration and place a test order. A new row appears in your sheet in real time. Every run is recorded in the activity log, so if a row ever fails to write you can see why, fix it, and resend with one click.
Free vs Pro for WooCommerce
The free version logs one row per order and places no limit on the number of orders. Pro adds the option to write a separate row for each line item in an order, which is useful when you need product-level reporting for multi-product orders, along with mapping to custom fields. Orders stay unlimited on every plan, so there are no per-task fees.
Frequently asked questions
Will this log past orders too?
The integration runs on new orders (or orders that reach the status you choose) from the moment it is active. It is built to keep your sheet updated going forward.
Can I send orders to more than one sheet?
Yes. Create multiple integrations, for example one sheet for all orders and another, with a condition, for high-value orders only.
Does this slow down checkout?
No. The row is written in the background after the order is placed, so checkout stays fast.
Get started
Keep a live record of every sale without a monthly automation bill. Install Advanced Form Integration free from WordPress.org and connect WooCommerce to Google Sheets in a few minutes.