To export WooCommerce orders to Google Sheets, follow these steps.
First, you’ll need to activate and set up the Order Sync with Google Sheets for WooCommerce plugin.
WooCommerce to Google Sheets Export #
Go to your WordPress dashboard, then click on Orders.

Now beside the Add order button, you’ll find a button labeled Sync orders on Google Sheet. Click on it to export your WooCommerce orders to Google Sheets.

You’ll see a popup notifying you that orders are synced.

After syncing, you can see your WooCommerce orders in the linked Google Sheet.


Google Sheets to WooCommerce Export #
Navigate to the Google Sheet that you have set up with the plugin.

In the Google Sheet menu, you’ll find an option called Order Sync beside Help. Click on it..

Under the Order Sync menu, select Fetch Order from WooCommerce to export the WooCommerce orders into the Google Sheet.

After a short wait, your orders will appear in the Google Sheet.


By following these steps, you can easily export and sync your WooCommerce orders with Google Sheets.