WPSyncSheets For WooCommerce automatically exports and syncs your WooCommerce orders, products, customers, and coupons to Google Sheets in real time. Every new order, product, customer, or coupon is added to your connected spreadsheet the moment it is created, so your store data is always current wi
PricingFree downloadThe WordPress.org download is free. Pro versions, add-ons or external services may cost extra.
CompatibilityRequires WordPress 5.3 and PHP 7.4.
SourceWordPress plugins · Nov 21, 2026
01 / Source details
Aboutthistool.
WPSyncSheets For WooCommerce automatically exports and syncs your WooCommerce orders, products, customers, and coupons to Google Sheets in real time. Every new order, product, customer, or coupon is added to your connected spreadsheet the moment it is created, so your store data is always current without a single manual export.
If you are looking for a WooCommerce Google Sheets Connector that keeps each data type in its own tab inside a single spreadsheet, this plugin is built for that job. Use it to back up store data, share live reports with your team, migrate WooCommerce content between sites, or feed your accounting and analytics workflows.
Demo | Sample Sheets | Docs | Support | Pro
🚀 Why Use This Plugin?
➜ Real-time export of WooCommerce orders to Google Sheets ➜ Separate, automatically created sheet tabs for each data type ➜ Share without giving admin access — send a sheet link to your accountant, VA, or supplier ➜ Local CSV & Excel (.xlsx) import and export ➜ Bulk-friendly — read and filter thousands of rows in Sheets instead of paging through wp-admin ➜ Interactive setup wizard and one-click Google Sheets connection ➜ 100% HPOS compatible , multisite ready
WPSyncSheets For WooCommerce Features
WooCommerce to Google Sheets Integration Connect WooCommerce with Google Sheets and export store data in real time. Create a new spreadsheet or select an existing one, and let the plugin add a dedicated tab for orders, products, customers, and coupons, each with a complete set of default columns. Data is synced using secure Google authentication, and no Google account or Drive data is stored by the plugin author.
Export WooCommerce Orders by Status Export order data based on WooCommerce order status so processing, completed, pending, cancelled, and refunded orders can be tracked separately. The built-in “Click to Sync” action pushes all of your existing orders into the connected sheet in one go, and every new order after that is appended automatically.
Export Product Types, Customers & Coupons Export simple, variable, grouped, and external products , including product images and variations, along with your full customer and coupon lists. Bulk export is supported for every data type, so an entire catalogue or customer base can be moved into Google Sheets in a single run.
CSV & Excel Import Export with Validation Preview Import and export WooCommerce orders, products, customers, and coupons as local CSV or Excel (.xlsx) files. A smart validation preview shows valid versus error row counts before anything is written to your store, and chunked background processing keeps large files from triggering server timeouts (504 errors).
Modern Dashboard & Guided Setup An interactive setup wizard walks you through the Google connection, and the dashboard inside WordPress admin shows each data type with its current sheet, header configuration, and sync status. Every sheet includes all default headers for its data type, with their default names and order.
To test the demo store: add any product to the cart, proceed to checkout, place the order with real or test billing details, then click “View Your Orders in Spreadsheet” to see the data land in Google Sheets.
📌 How to Use this Plugin
Step 1 – Install & Activate Install and activate the plugin. You will find the WPSyncSheets For WooCommerce menu in your WordPress admin.
Step 2 – Connect Google Open the API Integration tab and connect your Google account, either with the one-click connection or with your own Client ID, Secret Key, and Token. Make sure to ALLOW the Google Drive and Google Sheets permissions when prompted.
Step 3 – Configure Export Settings Create new or select existing spreadsheet to use, then enable the data types you want (orders, products, customers, coupons). Each sheet includes all default headers.
Step 4 – Click to Sync Use “Click to Sync” to send existing WooCommerce data to Google Sheets. From that point on, every new order, product, customer, or coupon is added to the connected sheet automatically.
📖 Step-by-Step Guides
Written walkthroughs for the most common WooCommerce and Google Sheets workflows:
How to Export WooCommerce Orders to Google Sheets Automatically
How to Import WooCommerce Orders to Google Sheets
Real-Time Sync of WooCommerce Order Status to Google Sheets
Bulk Product and Order Management in WooCommerce
How to Bulk Edit WooCommerce Product Prices for a Sale
How to Use Google Sheets as Your WooCommerce Inventory Control Center
Google Sheets vs the WooCommerce Default Dashboard: Which Is Better for Store Management?
How to Automatically Sync WordPress Data to Google Sheets
How to Build a Marketing Dashboard from WordPress Data Using Google Sheets
How to Turn Your WordPress Data into AI-Powered Insights with Google Sheets
Browse every tutorial on the WPSyncSheets Blog .
🔒 Upgrade to Pro
Unlock two-way syncing with WPSyncSheets For WooCommerce Pro :
✅ All free features – data export, bulk export, CSV/Excel import export ✅ Import orders, products, customers, coupons & events from Google Sheets to WooCommerce ✅ Bulk import of orders, products, coupons, customers, and events ✅ Auto field mapping between WooCommerce and Google Sheets ✅ Additional sheet headers from plugins, custom fields and metadata ✅ Choose, rename and reorder sheet headers ✅ Add, modify, and delete store data directly inside Google Sheets ✅ Scheduled imports and exports at your own intervals ✅ Advanced filters to selectively import or export data ✅ Date range sync – send only the records from a selected date range ✅ Category-wise product sheets, and import of product categories, tags and attributes from Google Sheets ✅ Custom field data from ACF Lite or Pro ✅ Visual graphs generated inside Google Sheets ✅ Freeze headers and change row background colours ✅ Compatible with 45+ popular WooCommerce and WordPress plugins ✅ Multisite support
Pro sample sheets: Products Sold Bar Graph | Total Orders Line Graph
You can check out the user guide to set up the plugin, or watch the videos below.
How to Export WooCommerce Orders?
How to Export WooCommerce Products?
How to Export WooCommerce Customers?
How to Export WooCommerce Coupons?
📣 Trusted by Over 10,000+ Customers
Trusted by online retailers, developers, and marketing teams globally to streamline WooCommerce data management. Subscribe to the WPSyncSheets Newsletter for tips, updates, and exclusive discounts.
Other WPSyncSheets Plugins
WPSyncSheets also offers Google Sheets integrations for Contact Form 7, Gravity Forms, WPForms, Ninja Forms, Fluent Forms, Formidable Forms, Elementor forms, Document Library Pro and WordPress posts and pages. See the WPSyncSheets website for the full list.
External services
This plugin connects to the following external services. No data is sent to any of them until you take the action described.
Google Sheets API and Google Drive API
Used to create spreadsheets and sheet tabs, write and update rows, and list the spreadsheets you have shared with the plugin. WooCommerce order, product, customer and coupon data that you enable for export is sent to the spreadsheet you select, each time a record is created or updated and when you run a manual or test sync. The plugin requests only the drive.file scope, so it can access spreadsheets it created or that you explicitly picked. The Google Picker script (apis.google.com) is loaded on the plugin settings and setup wizard screens so you can choose a spreadsheet. Provider: Google LLC. Google Terms of Service , Google APIs Terms of Service , Google Privacy Policy .
WPSyncSheets OAuth relay (api.wpsyncsheets.com)
Used only when you choose the one-click “Connect with Google” option. It registers your site so Google can return you to it after authorization, exchanges the authorization code for tokens, refreshes access tokens when they expire, and revokes the connection when you disconnect. It sends your site URL, home URL, the plugin version, a random installation ID generated by the plugin, and the OAuth code or refresh token issued by Google. It is not used when you connect with your own Google client ID and secret. Provider: Creative Werk Designs (WPSyncSheets). Terms and Conditions , Privacy Policy .
WPSyncSheets feedback service (feedback.wpsyncsheets.com)
Used only if you choose to submit the optional feedback form shown when deactivating the plugin, and only after you tick the consent box. It sends the reason you selected, your message, the plugin name and version, the site administrator email address and the site URL. Provider: Creative Werk Designs (WPSyncSheets). Terms and Conditions , Privacy Policy .
Source code
All JavaScript and CSS shipped with this plugin is unminified, human-readable source; there is no build step. The bundled assets/js/wpsslw-ui.js is an unmodified custom build of jQuery UI 1.12.1 (its source is at github.com/jquery/jquery-ui ). PHP libraries under lib/vendor are installed with Composer from lib/composer.json ; run composer install --no-dev inside lib/ to rebuild them.
See it in action
Screenshots & previews.
Google API Integration SettingsWooCommerce Order Export SettingsWooCommerce Product Export SettingsWooCommerce Customer Export SettingsWooCommerce Coupon Export SettingsWooCommerce Order Enable SettingsWooCommerce Product Enable SettingsWooCommerce Customer Enable SettingsWooCommerce Coupon Enable SettingsWooCommerce Order Default Sheet HeadersWooCommerce Product Default Sheet HeadersWooCommerce Customer Default Sheet HeadersWooCommerce Coupon Default Sheet HeadersGeneral SettingsGoogle Spreadsheet Orders
02 / Source details
Gettingstarted.
01Upload the entire wpsyncsheets-woocommerce folder to the /wp-content/plugins/ directory, OR go to Plugins > Add New > Search and search for “WPSyncSheets For WooCommerce”.
02Activate the plugin through the Plugins screen ( Plugins > Installed Plugins ).
03Open the WPSyncSheets For WooCommerce menu in your WordPress admin and connect your Google account from the Google API Settings tab, allowing both Google Drive and Google Sheets permissions.
For basic usage, have a look at the plugin’s Documentation .
03 / Source details
Frequently asked questions.
My new orders are not showing up in the connected Google Sheet.
This is usually a connection or permission problem. Check that the Google account is still authenticated, that both Google Drive and Google Sheets permissions were allowed during authentication, and that the correct spreadsheet and order statuses are selected in the export settings. Re-authenticating from the Google API Settings tab resolves most cases.
Can the plugin export WooCommerce products with images?
Yes, the plugin can export WooCommerce products with images from your WooCommerce store to Google Sheets.
Does the plugin support the export of variation products?
Yes, the plugin supports the export of variation products from your WooCommerce store into Google Sheets.
Does the plugin export WooCommerce customers and coupons?
Yes, the plugin can export WooCommerce customers and coupons into Google Sheets.
Can I export only orders with a specific status?
Yes. Order export can be filtered by WooCommerce order status, so you can keep processing, completed, or refunded orders in their own view.
Can I import CSV or Excel files into WooCommerce?
Yes. The plugin supports local CSV and Excel (.xlsx) import and export for orders, products, customers, and coupons, with a preview step that shows valid and error row counts before the import runs.
My import keeps failing or times out on large files.
Imports run through chunked background processing specifically to avoid server timeouts (504 errors) on large files. If an import still stalls, split the file into smaller batches and check your host’s PHP execution time and memory limits.
Can I choose, rename or reorder the sheet headers?
The free version always includes all default sheet headers for orders, products, customers, and coupons, with their default names and order. Choosing which headers to include, renaming and reordering sheet headers, renaming order status sheets, and adding extra headers from plugins, custom fields or metadata are available in the Pro Version .
Is the plugin compatible with HPOS (High-Performance Order Storage)?
Yes, the plugin is 100% HPOS compatible.
Does the plugin support multisite?
Yes, the plugin supports multisite exports to Google Sheets.
Does the plugin export posts, pages, and custom post types?
No. For that, use WPSyncSheets For Core , which imports and exports WordPress posts and pages via Google Sheets.
Can the plugin import orders or products from Google Sheets into WooCommerce?
Not in the free version, which exports from WooCommerce to Google Sheets and supports local CSV/Excel files. Importing orders, products, customers, coupons, and events from Google Sheets into WooCommerce is available in WPSyncSheets For WooCommerce Pro .
Is my Google account data safe?
Yes. The connection uses Google’s own secure authentication, data is written directly to the spreadsheet you select, and no Google account or Drive data is stored by the plugin author.
Do I need coding knowledge to use this plugin?
No. The setup wizard and settings screens are designed for non-developers, and no code is required.
FinderPress Media Auditor helps site administrators scan for broken images, missing Media Library files, unreachable media URLs, and other media issues across WordPress content. Use it to audit images, video, audio, PDFs, featured images, and attachment files without sending scan data to an external
The Accepted Payment Methods plugin is a straightforward, lightweight solution that enhances your website by displaying visually appealing icons of the payment methods you accept. This plugin is ideal for a variety of websites, including e-commerce platforms, service-oriented websites, and informati