WooCommerce – Recurring Product Exports to Google Sheets

In this tutorial, we will show you how to export WooCommerce products to Google Sheets in recurring intervals. You’ll be able to schedule automatic exports to run in recurring intervals every X minutes, hours, days, weeks, or months.

Scheduling recurring exports of WooCommerce products to Google Sheets is a great way to have a backup that is automatically updated in recurring intervals. You can schedule the recurring export for a later date and time, and it will run in the background even if you’ve logged out of your WordPress site and gone off to do something else.

This allows you to have much more autonomy in your time because you can schedule reports or automatic exports of your product information and send them automatically to your clients or collaborators.

What you need to schedule recurring exports to Google Sheets

First, you need the WP Sheet Editor – WooCommerce Products plugin. It allows you to view and manage all your WooCommerce products using an intuitive spreadsheet inside WordPress. You can run advanced searches, bulk edit hundreds of products, and export/import product data with a few clicks.

Second, you need to sign up to our Google Sheets Sync service. It allows you to export and import WordPress data using your Google Sheets account. You don’t need to install browser extensions nor run any scripts. You do it all on your WordPress site.

You will get a helper plugin that will allow you to set up our Google Sheets Sync service on your WordPress site. Follow this guide to connect your WordPress site to your Google Sheets account, the Google API, and the WP Sheet Editor API.

Follow the steps in the sections below to schedule recurring exports to Google Sheets:

Open the WooCommerce products spreadsheet

You can open the products spreadsheet by going to WP Sheet Editor > Edit products.

Select the products you will export (optional)

You can skip this step/section if you want to export all your WooCommerce products to Google Sheets.

If you don’t want to export all your products to Google Sheets, WP Sheet Editor allows you to export all the results of a search or manually select the products you want to export (even after running a search). Let’s take a look at each of these options.

a) Search for the products you will export

To search for the products you want to export, click on the Search tool.

You can search for your products using any product field as a search filter.

In this example, we want to find products that belong to a specific category and have a regular price equal to or greater than $100.

When you apply the search filters, you will see all the results of that search displayed in the spreadsheet.

b) Manually select the products you will export

WP Sheet Editor will display a checkbox picker on the left side of the spreadsheet. You can select all the products you want to export.

Option 1 – Schedule recurring exports to Google Sheets

Recurring exports can be normal or incremental. In this section we will see how to schedule a normal recurring export of our WooCommerce products to Google Sheets.

If you want to see what incremental exports are and how to schedule one, you can go to the next section of this tutorial.

Let’s start by opening the Export tool.

Now we need to select these values to schedule an export that will run in recurring intervals:

• What columns do you want to export: You have three options here:
  • Type column names to select specific columns
  • Select all the active columns
  • Select all columns (including visible and hidden columns).
• Which rows do you want to export: You have two options here:
  • All the rows from my current search: Select this option if you have run a search or if you want to export all your products without having run a specific search.
  • Rows that I selected manually with the checkbox: Select this option if you have manually selected the products you want to export.
• What app will you use to edit this file: Google Sheets
• Name of this export: You need to add a name for this scheduled automatic export to Google Sheets.
• Tick the Run this in the future checkbox.
• Select the date and time: Use the date and time selector to choose the date and time when you want this automatic export to run.
• Notify this email address when the process finishes: Enter your email address and we will notify you when the first export is run and when subsequent recurring intervals are run..
• Select the Run in recurring intervals option.
• You need to add the number ni the Run every field, and then select the time unit. You can run recurring exports every X minutes, hours, days, weeks or months.
• Once you’re ready, click on Start new export.

Once you have scheduled the recurring export, you’ll see the View scheduled exports link. Click on it to go to the scheduled exports list.

Here you can see that our scheduled export has been added to the list.

You can follow this guide to understand how the Scheduled tasks popup allows you to take complete control of your scheduled tasks.

When the first export is executed and each time a recurring interval is exported, you will receive an email containing the details of the export, including the link to the Google Sheet and the link to download the log file of this scheduled task.

Here you can see a screenshot of the Google Sheet that has been created with our recurring export.

Option 2 – Schedule incremental exports to Google Sheets

Let’s see how to schedule an incremental recurring export to Google Sheets.

Incremental means that, after the first export, the recurring intervals will not export all products, but only the new products that have been added after the first export or after the last exported recurring interval.

Note that changes made to existing products will not be exported to Google Sheets, but only new products will be added to the Google Sheet. So, if you want to export both new products and update changes in existing products to Google Sheets, you can do a normal recurring export, following the steps we showed in the previous section of this tutorial.

Start by opening the Export tool.

Now select these values to schedule a recurring incremental export from your WooCommerce products to Google Sheets:

• What columns do you want to export: You have three options here:
  • Type column names to select specific columns
  • Select all the active columns
  • Select all columns (including visible and hidden columns).
• Which rows do you want to export: You have two options here:
  • All the rows from my current search: Select this option if you have run a search or if you want to export all your products without having run a specific search.
  • Rows that I selected manually with the checkbox: Select this option if you have manually selected the products you want to export.
• What app will you use to edit this file: Google Sheets
• Name of this export: You need to add a name for this scheduled automatic export to Google Sheets.
• Tick the Run this in the future checkbox.
• Select the date and time: Use the date and time selector to choose the date and time when you want this automatic export to run.
• Notify this email address when the process finishes: Enter your email address and we will notify you when the first export is run and when subsequent recurring intervals are run..
• Select the Run in recurring intervals option.
• You need to add the number ni the Run every field, and then select the time unit. You can run recurring exports every X minutes, hours, days, weeks or months.
• Tick the Make incremental exports checkbox.
• Once you’re ready, click on Start new export.

Once you have scheduled the recurring export, you’ll see the View scheduled exports link. Click on it to go to the scheduled exports list.

Here you can see that our scheduled incremental export has been added to the list.

You can follow this guide to understand how the Scheduled tasks popup allows you to take complete control of your scheduled tasks.

Here you can see a preview of the email you will receive notifying you when the first export is run, and each time a recurring interval is run adding the new products to your Google Sheet.

Here you can see a preview of the Google Sheet that was generated with our export. This Google Sheet will be automatically updated by adding new rows on every recurring interval run.

Sync WooCommerce and Google Sheets

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

• Immediate export
• Scheduled export
• Real-time bidirectional sync
• Immediate import
• Scheduled import
• Recurring import
• Real-time import

In this tutorial, we have shown you how to export WooCommerce products to Google Sheets at recurring intervals using the WP Sheet Editor – WooCommerce Products plugin and the Google Sheets Sync service.

The Google Sheets Sync service works with all spreadsheets generated by WP Sheet Editor plugins, so you can automate exports and imports of products, orders, coupons, customers, posts, pages, courses, donation forms, events, downloads, and any custom post type. We also support multilingual plugins like WPML and Polylang, as well as custom field plugins like ACF, PODs, JetEngine, Toolset Types, among others.