When it comes to sending WooCommerce (Orders, Products,Customers, etc..) to Google Sheets, the free WooCommerce to Google Sheets Addon is the simplest way to get started — no cost, no coding, and set up in under 5 minutes.

We released this free add-on so any WooCommerce store can connect to Google Sheets without needing the Pro version. It works as a bridge between your WooCommerce orders and Google Sheets, using a manual “Click to Sync” action inside your WordPress dashboard.

Whenever you sync, a new row with the order details is added or moved to the appropriate Google Sheet tab based on the order status. If you need entries to sync automatically in real time as orders come in — rather than manually triggering sync — that's where the Pro version comes in (more on the difference below).

GSheetConnector – WooCommerce Google Sheets Connector, Export Orders & Products

Author(s): WesternDeal

Current Version: 1.4.10

Last Updated: August 6, 2026

Direct Download

100%Ratings 3,000+Installs WP 5.3+Requires

How to Connect Google Sheets with WooCommerce (in less than 5 minutes)

Step: 1 – In Google Sheets
* Log into your Google Sheets.
* Create a new sheet and name it. ( You can also select the existing sheet while setting the connection as per Step 3).
* Optionally – Skip this step and create a new sheet from “WP-Admin” Available in PRO version

Step: 2 – In WordPress Admin
* Navigate to WooCommerce > Google Sheet > Integration Tab
* Authenticate with Google using new “Google Access Code” while clicking on “Get Code”
* Make Sure to ALLOW Google Permissions for Google Drive and Google Sheets and then copy the code and paste in Google Access Code field, and Hit Save & Authenticate.
* Now fetch the sheet details by clicking “Click here to fetch Sheet details to be set at WooCommerce settings.”

Step: 3 – Connect with Google Sheet
* Navigate to WooCommerce > Google Sheet > WooCommerce Data Settings.
* Select the appropriate Sheet from the “Google Sheet Name” dropdown box.
* Select WooCommerce Order Status to create Sheet Tabs and add headers to your selected Google Sheet.
* Lastly test by ordering any product and putting it to a different order states ( Processing, Hold, etc)

Free vs Pro: What You Get with an Upgrade

The free version covers manual sync perfectly well for smaller stores or occasional use. If your store processes orders frequently and you want everything synced automatically with zero manual steps, WooCommerce Google Sheet Connector PRO adds:

Real-Time Automatic Sync – Orders sync to Google Sheets the moment they're placed — no manual “Click to Sync” needed.

New Spreadsheets & Sheets – Auto-create a new spreadsheet and sheets based on order status, directly from the settings page.

Freeze Header – Easily freeze the header row (first row) of the sheet from the settings page.

Drag-and-Drop Column Ordering – Rearrange columns without touching Google Sheets manually — everything is handled from the plugin settings.

Enable / Disable Sheet Headers – Set and customize the Sheet Headers row exactly as you need it.

All-in-One Sheet – Combine all customer order status sheets into a single sheet within your spreadsheet.

Multi-Language Support – Available in French, German, and Chinese.

Background Row Color – Alternating row colors calculated automatically by order ID, for easier reading.

Ready for Automatic Sync? Get WooCommerce Google Sheet Connector PRO