WooCommerce Orders – Recurring Exports to Google Sheets

Let’s see how to schedule recurring exports of WooCommerce ordes to Google Sheets. We will create normal recurring exports and incremental recurring exports.

Recurring exports of WooCommerce orders to Google Sheets can have many useful uses:

• Save new orders to the same Google Sheet every hour
• Exporting new WooCommerce orders every day, week, month
• Generate sales reports in Google Sheets, based on your order details
• Create sales reports with charts and tables using the details of your WooCommerce orders in Google Sheets

In order to export your WooCommerce orders to Google Sheets at automatic recurring intervals, you will need these two elements:

First, you need the WP Sheet Editor – WooCommerce Orders plugin. This plugin creates an intuitive spreadsheet within your WordPress site, which allows you to view and manage your WooCommerce orders easily.

Second, you need the Google Sheets Sync service. This service allows you to export and import WordPress content using Google spreadsheets. It works with all WP Sheet Editor spreadsheets that run in the backend, so you can automate exports between WordPress and Google Sheets for posts, pages, products, orders, events, downloads, etc.

You’ll get a helper plugin when you sign up to this service. Follow this guide to connect your WordPress site to your Google account, the Google API and the WP Sheet Editor API.

In previous tutorials, we have shown you how to export WooCommerce orders to Google Sheets immediately and how to schedule an automatic export of WooCommerce orders to Google Sheets.

Now you need to follow the steps in the sections below to schedule recurring exports of WooCommerce orders to Google Sheets.

1- Open the WooCommerce orders spreadsheet

You need to start by opening the WooCommerce orders spreadsheet by going to WP Sheet Editor > Edit orders.

2- Open the Export tool

Once you’re on the WooCommerce orders spreadsheet, you need to open the Export tool.

3- Export orders to Google Sheets in recurring intervals

After opening the export tool, let’s look at the values you need to select to create a normal recurring export or an incremental recurring export.

Option 1 – Create a normal recurring export to Google Sheets

A normal (non-experimental) recurring export will generate a new spreadsheet each time a recurring interval is exported.

This means that, if you have scheduled the export to run every 24 hours, a new Google Sheet will be created every 24 hours and all rows (all orders in this case) will be exported.

Select these values:

• What columns do you want to export:
  • You can select specific columns by typing the column names.
  • You can also Select active columns. Active columns are the ones that have been enabled to be displayed on the spreadsheet using the Column manager.
  • Or you can Select all columns.
• Which rows do you want to export: You can export all the rows, all the rows from a specific search, or all the rows you have manually selected 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 job.
• Select the date and time: Use this field to select when you want this automatic export to run.
• Notify this email address when the process finishes: Add an email address here to receive an email notification when the process finishes.
• Select the Run in recurring intervals option.
• Now you need to select the recurrence by addin a number in the Run every field, and then select the time unit: minutes, hours, days, weeks, months.
• You can tick the Export every product (line item) as separate rows checkbox, but this is optional. If you don’t check this checkbox, you will get the order details in one row.
• Once you’re ready, click on Start new export.

After that, the recurring export will be scheduled to run in the selected date and time.

You can click on the View scheduled exports link to open the list of scheduled exports.

Here you can see that our recurring export has been scheduled and added to the list. You can follow this guide to learn how to take full control of your scheduled jobs.

Here is a preview of the email you will receive when the first recurring interval is exported.

And each time a new recurring interval is exported you will receive an email with the details of this scheduled job and a link to open the new Google Sheet that has been generated.

Here you can see the Google Sheet that has been generated with our recurring export. Since this is a normal recurring export, a new Google Sheet will be generated on each interval.

Option 2 – Create an incremental recurring export to Google Sheets

An incremental recurring export will not generate a new Google Sheet each time an export is run. Instead, it will generate a Google Sheet the first time the export is run, and in the following recurring intervals it will add only the new orders to the same Google Sheet that was generated with the first export. This is great for exporting only new orders every hour, every day, etc., and adding them to the same Google Sheet.

Changes to orders that have already been exported in the previous recurring interval will not be exported when running a new recurring interval.

Select these values to schedule an incremental recurring export:

• What columns do you want to export:
  • You can select specific columns by typing the column names.
  • You can also Select active columns. Active columns are the ones that have been enabled to be displayed on the spreadsheet using the Column manager.
  • Or you can Select all columns.
• Which rows do you want to export: You can export all the rows, all the rows from a specific search, or all the rows you have manually selected 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 job.
• Select the date and time: Use this field to select when you want this automatic export to run.
• Notify this email address when the process finishes: Add an email address here to receive an email notification when the process finishes.
• Select the Run in recurring intervals option.
• Tick the Make incremental exports checkbox.
• Now you need to select the recurrence by addin a number in the Run every field, and then select the time unit: minutes, hours, days, weeks, months.
• You can tick the Export every product (line item) as separate rows checkbox, but this is optional. If you don’t check this checkbox, you will get the order details in one row.
• Once you’re ready, click on Start new export.

After that, the incremental export will be scheduled to run in the selected date and time. You can click on the View scheduled exports link to open the list of scheduled exports.

Here you can see that our incremental export has been scheduled and added to the list. You can follow this guide to learn how to take full control of your scheduled jobs.

You will receive an email to notify you that the process has been executed and completed. You’ll get this email every time a new recurring interval is exported.

Here you can see the Google Sheet that has been generated with our incremental recurring export. After the first export, only new orders will be added to this Google Sheet.

In this tutorial, we have shown you how to export WooCommerce orders to Google Sheets at recurring intervals.

You can create normal recurring exports that will generate a new Google Sheet on each run, or you can create incremental exports that will add only new orders to the same Google Sheet.