Back to Blog

WooCommerce to Google Sheets Integration to Streamline Your Workflow

You may have different reasons for reporting your data about orders, products, customers, etc. from WooCommerce. Some users just need this once when they’re migrating to another platform or online store. Others would like to export WooCommerce data recurrently for reporting or analytical purposes. In this blog post, we’ll discover how you can export WooCommerce directly to Google Sheets and automate further exports on a schedule. 

Connect WooCommerce to Google Sheets – what options are available?

If you chose Google Sheets as the destination for your WooCommerce data, you should know the available options for data export:

  • WordPress plugins – some users go for this option, but few of them are satisfied with it. The more plugins you have on your WP site, the lower performance of it you should expect. So, it’s not an option for us. 
  • Google Apps Script – this is an interesting solution if you know how to code in Apps Script. In brief, you need to write a script, deploy it as a web app and connect to WooCommerce via a webhook. Since we’re no-code enthusiasts, let’s skip this option as well.
  • Third-party tools – this may include Google Sheets add-ons, as well as web apps. Not all tools can do the job of course, but this option is what we need because it does not require coding skills and won’t affect the performance of our WP site. 

WooCommerce integration with Google Sheets via API

The WooCommerce REST API is a good way to access your WooCommerce data. Usually, this method is chosen by web developers and tech-savvy folks. But, with Coupler.io, a data importing solution, you can fetch data from APIs and import it to Google Sheets, Excel, and other destinations easily without a single code line. For this, you’ll need to:

  • Obtain WooCommerce API credentials
  • Configure your WooCommerce to Google Sheets integration based on the data required for export

Get WooCommerce API credentials

This is pretty simple! Go to your WordPress admin and select WooCommerce => Settings => Advanced => REST API.

Then you’ll see a big “Create an API key” button. Click on it.

Specify the details for your key: enter a description, select the user, and choose Read/Write permissions (actually, Read permission is enough for exporting data from WooCommerce).

Click “Generate API key” and welcome your Consumer key and Consumer secret.

Copy your credentials to some text editor, since we’ll use them in the next step.

Set up a WooCommerce to Google Sheets integration

Sign in to Coupler.io and click “Add importer“. 

Name the importer whatever you want and complete these three steps:

  1. Set up Source
  2. Set up Destination
  3. Set up Schedule

Set up Source 

  • Select JSON Client as the source application. Click “Continue“.
  • Insert the JSON URL depending on the data you want to export using the following boilerplate:

http://{your-domain}/wp-json/wc/v3/{endpoint}
  • {your-domain} – replace with the domain name of your WordPress site.
  • {endpoint} – replace with the endpoint that corresponds to the WooCommerce data entity for export. Here is a list of available endpoints.

For example, here is the JSON URL for exporting a list of products from WooCommerce:

http://www.*******.io/wp-json/wc/v3/products

Click “Continue“.

  • Insert the following required strings in the “URL query string” field:
consumer_key: {replace-with-your-consumer-key}
consumer_secret: {replace-with-your-consumer-secret}
  • Optionally, you can use properties specific to the chosen {endpoint}, such as, id, date_created, status, sku, price, and many more. You can find the available properties in the WooCommerce API documentation.

Click “Continue“.

Set up Destination

  • Select Google Sheets as the destination application. Click “Continue“. 
  • Connect your Google account: click “Connect“, and log in to your account. Click “Continue“.
  • Choose the spreadsheet, as well as the sheet to export data to. Click “Continue“.
  • In the next steps you can specify the first cell to import your data range to, as well as the import mode (replace or append). Click “Continue“.

Set up Schedule

Customize the frequency for automated exports of data from WooCommerce to Google Sheets.

When all the settings are configured, click “Save and Run“. And there you go! 

To open the spreadsheet with the data exported from WooCommerce, click the “View Results” button. If necessary, you can easily switch destination and source applications and load data, for example from Google Sheets to BigQuery.

Do you need a ready-to-use WooCommerce integration? 

With the JSON Client, you can connect WooCommerce to Google Sheets, but you’ll have to tinker with the parameters. Meanwhile, Coupler.io provides many ready-to-use integrations, such as Shopify, Pipedrive, and others. If you need a dedicated WooCommerce integration or any other source, let us know about it by filling out this form. The Coupler.io team works on adding new sources, and we’d be happy to know your preference.

For example, numerous requests from users resulted in the Shopify to Google Sheets integration.

Data that you can auto export from WooCommerce to Google Sheets

The WooCommerce API allows you to export versatile data, including products, orders, customers, sales reports, etc. Check out the parameters you need to configure in Coupler.io to do this.

WooCommerce products and inventory to Google Sheets

Base URL:

http://{your-domain}/wp-json/wc/v3/{endpoint}
Type of data{endpoint}
Details of all products.../products
Details of a product.../products/{product-id}
Details of all variations of a product.../products/{product-id}/variations
Details of a variation of a product.../products/{product-id}/variations/{variation-id}
Details of all product attributes .../products/attributes
Details of a product attribute.../products/attributes/{attribute-id}
Details of all terms from a product attribute .../products/attributes/{attribute-id}/terms
Details of a product attribute term .../products/attributes/{attribute-id}/terms/{term-id}
Details of all product categories.../products/categories
Details of a product category.../products/categories/{category-id}
Details of all product shipping classes.../products/shipping_classes
Details of a product shipping class.../products/shipping_classes/{shipping_class-id}
Details of all product tags.../products/tags
Details of a product tag.../products/tags/{tag-id}
Details of all product reviews.../products/reviews
Details of a product review.../products/reviews/{review-id}

WooCommerce orders to Google Sheets

Base URL:

http://{your-domain}/wp-json/wc/v3/{endpoint}
Type of data{endpoint}
Details of all orders.../orders
Details of an order.../orders/{order-id}
Details of all notes of an order.../orders/{order-id}/notes
Details of a note of an order.../orders/{order-id}/notes/{note-id}
Details of all refunds of an order.../orders/{order-id}/refunds
Details of a refund of an order.../orders/{order-id}/refunds/{refund-id}

WooCommerce reports to Google Sheets

If you only need to export a WooCommerce sales report to Google Sheets, check out our template with a preconfigured JSON Client importer. 

To use the template, you’ll need first to install the Coupler.io add-on for Google Sheets from the Google Workspace Marketplace.

And here are the parameters to export other types of reports from WooCommerce:

Base URL:

http://{your-domain}/wp-json/wc/v3/{endpoint}
Type of data{endpoint}
Details of all reports.../reports
Details of a sales report.../reports/sales
Details of a top sellers report.../reports/top_sellers
Details of a coupons totals report.../reports/coupons/totals
Details of a customers totals report.../reports/customers/totals
Details of an orders totals report.../reports/orders/totals
Details of a products totals report.../reports/products/totals
Details of a reviews totals report.../reports/reviews/totals

Miscellaneous WooCommerce data to Google Sheets

Base URL:

http://{your-domain}/wp-json/wc/v3/{endpoint}
Type of data{endpoint}
Details of all coupons.../coupons
Details of a coupon .../coupons/{coupon-id}
Details of all customer.../customers
Details of a customer.../customers/{customer-id}
Details of all tax rates.../taxes
Details of a tax rate.../taxes/{tax-id}
Details of all tax classes.../taxes/classes
Details of all webhooks.../webhooks
Details of a webhook.../webhooks/{webhook-id}
Details of all settings groups.../settings
Details of all setting options.../settings/{setting_group-id}
Details of a specific setting option.../settings/{setting_group-id}/{setting-id}
Details of all payment gateways.../payment_gateways
Details of a specific payment gateway.../payment_gateways/{payment_gateway-id}
Details of all shipping zones.../shipping/zones
Details of a shipping zone.../shipping/zones/{zone-id}
Details of all the locations of a shipping zone.../shipping/zones/{zone-id}/locations
Details of all the shipping methods from a shipping zone.../shipping/zones/{zone-id}/methods
Details of a specific shipping method from a shipping zone.../shipping/zones/{zone-id}/methods/{method-id}
Details of all shipping methods .../shipping_methods
Details of a shipping method.../shipping_methods/{method-id}
A simple list of available data endpoints.../data
List of all the continents.../continents
Continent data.../continents/{continent-code}
List of all the countries.../countries
Country data.../countries/{country-code}
List of all the currencies.../currencies
Currency data.../currencies/{currency-code}
Current currency.../currencies/current

How do I export data about WooCommerce accounts to Google Sheets

You’ll find the information about the WooCommerce accounts in the details of all settings groups using the following JSON URL:

http://{your-domain}/wp-json/wc/v3/settings

WooCommerce export to Google Sheets as a one-time purpose

The solution described above is well suited for recurring exports of data from WooCommerce. If you only need to do this once and have no desire to set up the integration, you can export some data manually as a CSV file and then import it to Google Sheets. But, this way, you can only import products and reports. Here is how you can do this.

Export products from WooCommerce as a CSV file

In your WordPress admin, go to WooCommerce => Products and click the “Export button“.

This will open a new page where you need to specify:

  • Which columns to export
  • Which product types to export
  • Which product categories to export
  • Whether to export custom meta

In the end, click “Generate CSV” to download a CSV file with WooCommerce products data to your device.

Export reports from WooCommerce as a CSV file

In your WordPress admin, go to WooCommerce => Reports. Select the report you want to export:

  • Orders
    • Sales by date
    • Sales by product
    • Sales by category
    • Coupons by date
    • Customer downloads
  • Customers
    • Customers vs. guests
  • Shipping Labels

Choose the period for your report and click “Export CSV“.

Note: Customer downloads, Customer list, and Stock reports are not available for export as CSV.

Having exported the required data as a CSV file, you can import this CSV file into Google Sheets

Which WooCommerce exporting option should I choose?

Without any doubts, Coupler.io seems to be the best option for your purpose. The reason is quite simple: you can automate data export from WooCommerce to Google Sheets on a schedule. So, for example, your spreadsheet will automatically get the updated data of your orders every Sunday. 

Besides, this tool lets you get an enhanced set of exportable data, which is not available with the native exporting functionality. Nevertheless, it’s up to you to make a choice, and we’re sure that it will be right for you. Good luck with your data!

Back to Blog

Comments are closed.

Access your data
in a simple format for free!

Start Free