Export WooCommerce Products to Google Sheets in Real Time

In this tutorial, we will show how to export WooCommerce products to Google Sheets in real time. We will add live product sync between WooCommerce and Google Sheets.

We are going to show you how to schedule a real-time export, where all changes and new products you create in WordPress are automatically saved to Google Sheets.

We will also show you how to create a bidirectional real-time export, where all changes and new products created in WordPress are automatically exported to Google Sheets, and all changes and new products created in Google Sheets are automatically imported into WordPress.

This is the best way to add bulk product sync between WooCommerce and Google Sheets.

With this live synchronization, you can:

• Synchronize WooCommerce prices in real time with Google Sheets
• Synchronize your WooCommerce stock with Google Sheets in real time
• Synchronize all your WooCommerce product data with Google Sheets
• Create products in Google Sheets and import them to WooCommerce automatically
• Create a dynamic synchronization between your WooCommerce store and your Google Sheets account

You need two things to add bulk product sync for WooCommerce and Google Sheets:

WooCommerce Products Spreadsheet

This plugin allows you to view and edit all your WooCommerce products in a spreadsheet within WordPress. You can do advanced searches, apply bulk changes to hundreds of products, export and import products.

Google Sheets Sync Service by WP Sheet Editor

This is a service provided by wpsheeteditor.com, which allows you to export and import content between WordPress and Google Sheets. It works with all the spreadsheets in the WP Sheet Editor plugin on the backend.

You can do immediate exports and imports, scheduled one-time exports and imports, recurring exports and imports, and real-time unidirectional and bidirectional syncs.

You can follow this guide to set up the helper plugin that you’ll get when you sign up to our Google Sheets Sync service. The guide will show you how to connect your WordPress website to the Google API and to the WP Sheet Editor API.

Here are other types of exports you can do from WooCommerce products to Google Sheets using our Google Sheets Sync service:

• Immediate export
• Scheduled one-time export
• Scheduled recurring export

Follow the steps in the sections below to add real-time synchronization between your WooCommerce products and your Google Sheets account.

1- Real-time export from WooCommerce to Google Sheets

The first thing we want to show you is how to schedule a real-time export from WordPress to Google Sheets.

This is a one-way export because all changes and new products you create in WordPress will be automatically saved to the Google Sheet generated in the export.

Important:

• The live sync export recognizes changes and products added using the normal product editor, using the WP Sheet Editor spreadsheet, and changes / new products using third party plugins what use the normal WordPress API.
• If you want to add a bidirectional export that synchronizes changes in both directions, you should go to the next section of this tutorial.

You need to start by opening the WooCommerce products spreadsheet by going to WP Sheet Editor > Edit products. You’ll see all your WooCommerce products displayed on the spreadsheet. Every product is a row and every column is a field.

Click on Export to create a real-time export from WordPress to Google Sheets.

Now select the following values in the Export tool.

• What columns do you want to export: You can select all the active columns, all the columns (including disabled columns), or specific columns by typing the column names.
• Which rows do you want to export: You can select all the products or only the products you have selected manually in the spreadsheet.
• What app will you use to edit this file: You need to select Google Sheets.
• Name of this export: You need to add a name for this scheduled real-time export from WordPress to Google Sheets.
• Tick the Run this in the future checkbox.
• Now you need to Select the date and time when you want the export to run.
• Notify this email address when the process finishes: You can add your email address to get a notification by email when the process finishes.
• Select the Real time sync option.
• Type of sync: WordPress to Google Sheets
• What column shoud be used as an identifier: By default, we use the record_id column to identify and match the products to export the information.
• Click on Start new export.

Once you schedule this realtime export from WordPress to Google Sheets, you will see a link to View scheduled exports.

If you click on that link, you’ll see the new scheduled export has been added to the Scheduled exports popup.

You can follow this guide if you want to understand how to take complete control of your scheduled tasks by using the scheduled tasks popup.

When your real-time export is run and completed, you will receive an email to the email address you added, which will contain all the details of this export, the link to the generated Google Sheet, and the link to view and download the log file of this scheduled export.

And here’s the generated Google Sheet, which will be automatically updated every time you make changes to your WooCommerce products on WordPress.

By following the steps shown in the section above, you can synchronize all your WooCommerce products to your Google Sheets account. Now, whenever you apply changes on existing products or create new products, the changes will be automatically exported to Google Sheets.

2- Real-time bulk product sync with Google Sheets

Now let’s see how to add real-time bulk product sync with Google Sheets. For this we need to create a bidirectional real-time export, which will allow you to synchronize your WooCommerce products in both ways.

This means that any changes to existing products or any new products you create on WordPress will be automatically exported to Google Sheets.

At the same time, any changes to existing products or any new products you create on Google Sheets will be automatically imported into WordPress.

You need to start by opening the Export tool.

Now you need to select the following values to create a bidirectional realtime synchronization between your WooCommerce store and your Google Sheets account:

• What columns do you want to export: You can select all the active columns, all the columns (including disabled columns), or specific columns by typing the column names.
• Which rows do you want to export: You can select all the products or only the products you have selected manually in the spreadsheet.
• What app will you use to edit this file: You need to select Google Sheets.
• Name of this export: You need to add a name for this scheduled real-time sync between WordPress/WooCommerce and Google Sheets.
• Tick the Run this in the future checkbox.
• Now you need to Select the date and time when you want the export to run.
• Notify this email address when the process finishes: You can add your email address to get a notification by email when the process finishes.
• Select the Real time sync option.
• Type of sync: Bidirectional
• What column shoud be used as an identifier: This field allows you to effectively identify and update rows in Google Sheets. For best results in bi-directional synchronization scenarios, we recommend you avoid to use IDs as identifiers. Using IDs can cause complications when creating new rows in Google Sheets, as these new rows will not have IDs. Additionally, it can limit the ability to import the same Google Sheet across multiple WordPress sites, as each site uses different IDs. Instead, we recommend using alternative identifiers such as titles, URL slugs, emails, usernames, SKUs, or other unique values that make it easier to match data across multiple sites. By using these identifiers, you can ensure seamless data synchronization.
• Click on Start new export.

Once you schedule the real-time synchronization, you will see a link to View scheduled exports.

If you click on that link, you’ll see the new scheduled export on the Scheduled exports list.

Folow this guide if you want to understand how to take complete control of your scheduled tasks by using the scheduled tasks popup.

Bidirectional exports will automatically create an import that will monitor all the new changes you make in Google Sheets and automatically import them into WordPress. The name of this import will be the same name you entered for the bidirectional export plus the prefix ” – Auto monitoring”.

Important. For the automatic import from Google Sheets to WordPress, we use a delay time that you can select in the advanced settings of the plugin, or in the settings of the import task that was automatically created when exporting the content of a bidirectional export. This delay time is to make sure that you have enough time to make sure that you have finished editing in Google Sheets to avoid importing incomplete information.

Once your bidirectional export between WooCommerce and Google Sheets runs, you will receive an email containing all the details of your bidirectional sync, as well as the link to open the Google Sheet that has been generated, and the link to download the log file of this bidirectional sync.

Below you can see the Google Sheet that was generated from our bidirectional export to Google Sheets.

By following the steps we just showed you in the previous section, you can add real-time synchronization between your WooCommerce store and your Google Sheets account. Now, all the changes you apply to your WooCommerce products in WordPress will be automatically exported to Google Sheets. Also, all the changes you apply in Google Sheets will be automatically imported to WordPress.

Sync WooCommerce and Google Sheets

You can automate your WooCommerce products with Google Sheets exports and imports:

• Immediate export
• Scheduled export
• Recurring exports
• Immediate import
• Scheduled import
• Recurring import
• Real-time import

With the WooCommerce Products Spreadsheet plugin and our Google Sheets Sync service, you can export and import your WooCommerce product information between WordPress and Google Sheets.

It’s the best way to create scheduled exports, recurring exports and real-time exports (one-way and bi-directional).

Keep in mind that you will also be able to export and import other post types, because it works with all WP Sheet Editor spreadsheets. This means that in addition to WooCommerce products, you can export and import posts, pages, custom post types, donation forms, events, courses, lessons, etc. It works with custom fields (ACF, PODS, and others) and with fields from multilingual plugins like WPML, Polylang, etc.