WooCommerce to Google Sheets Integration – Complete Guide

Looking for a seamless way to connect WooCommerce with Google Sheets?

Integrating WooCommerce with Google Sheets can save you valuable time by automatically syncing your store data into a spreadsheet. This setup makes it easier to track revenue, analyze sales trends, and keep your data well-organized—all in one place.

In this article, we’ll guide you on setting up WooCommerce to Google Sheets integration in a few minutes.

Benefits of Integrating WooCommerce with Google Sheets

Google Sheets is a widely used, free spreadsheet application developed by Google, allowing users to create, edit, and collaborate on spreadsheets online. Integrating WooCommerce with Google Sheets can significantly enhance your e-commerce operations.

One significant benefit is automated data management, which ensures that orders, customer details, inventory, and product data sync automatically to Google Sheets. This minimizes manual data entry and reduces the risk of errors, saving valuable time and effort. Additionally, this integration enhances data protection. For instance, store owners can share order details with warehouse shipping managers or affiliates without granting them direct access to the WordPress dashboard.

Another advantage of integrating WooCommerce with Google Sheets is enhanced reporting and analytics. With customer and order data stored in Google Sheets, you can create custom reports, generate charts, and build dashboards to analyze sales trends, track performance, and make informed business decisions.

Finally, improved collaboration is a significant benefit. Since Google Sheets is cloud-based and supports multiple users, team members can access and update data simultaneously. This enhances communication and coordination across different departments, ensuring everyone stays aligned and up to date.

With these benefits in mind, let’s see how to integrate WooCommerce with Google Sheets.

Setting Up WooCommerce to Google Sheets Integration

Before we go over setting up the integration between WooCommerce and Google Sheets, you must create a new spreadsheet where the information will be stored.

Creating a Spreadsheet in Google Sheets

Log in to the Google Sheets website with your Google account and click ‘Blank spreadsheet’ to create a new spreadsheet. Alternatively, you can visit “https://sheets.new” in your browser.

Next, add columns for the data you want to collect and save in the spreadsheet. For this article, we have created a column for the customer’s name, email address, order total, purchased products, and order date.

You can import any WooCommerce data, including country, payment method, order notes, etc.

Once your spreadsheet is ready, you can now connect it to WooCommerce via MailOptin.

Installing the MailOptin Plugin

MailOptin is a powerful WordPress automation plugin that effectively integrates Google Sheets with WooCommerce, especially automatically exporting WooCommerce orders to Google Sheets.

To get started, you’ll need to purchase a MailOptin license from the pricing page. Once you have the plugin file, log in to your WordPress admin dashboard and navigate to Plugins > Add New.

Click Upload Plugin, select the downloaded ZIP file, and then click Install Now. 

After the installation, activate the plugin to begin the setup process.

Connecting WooCommerce to Google Sheets via MailOptin

To connect WooCommerce to Google Sheets, MailOptin requires authorization to access your Google account.

You can start by logging into the Google Cloud Console and creating a new project. Click the project drop-down menu in the top left corner, next to the Google Cloud logo, and select “New Project.”

You can enter a name for your project, optionally choose an organization, and submit the form to proceed.

After creating your project, click Get Started and enter your app details.

Next, in the Audience section, select ‘External’ as the user type and provide your email address in the Contact Information section.

Finally, accept the Google API Services policy and click Create.

On the Overview page, click Create OAuth Client or go to Clients > Create Client to proceed.

Next, select Web application as the application type and enter a name for your OAuth client ID.

Go to your WooCommerce store and navigate to MailOptin > Integration > Google Sheets to copy the authorized redirect URL.

With your authorized redirect URL copied, return to Google Console, paste it, and click Create.

Next, click the Download icon to access your Client ID and Client Secret. Be sure to copy and save them, as you’ll need them later.

Once saved, go to the API Library page or visit Google API Library

Search for and enable the following APIs: Google Drive API and Google Sheets API.

Next, navigate to Google Auth Platform > Data Access, click Add or Remove Scopes, and select Google Drive API: ./auth/drive and Google Sheets API: ./auth/spreadsheets.

Finally, save your changes.

Next, go to Google Auth Platform > Audience and publish the application.

To finalize the Google Sheets integration, go to your WordPress dashboard > MailOptin > Integrations > Google Sheets.

Enter your OAuth Client ID and Client Secret, then click Save Changes.

Next, click the Authorize Your Account button. You will be redirected to a Google-hosted page to complete the authorization process. After the authorization process, you should see that the connection is successful in MailOptin.

The complete guide for granting MailOptin access to your Google Sheets account can be found here.

Adding WooCommerce Customers to Google Sheets

This section will guide you through automatically adding WooCommerce customers to Google Sheets based on specific purchase criteria.

You can configure the integration to capture customer and order data when:

• Any WooCommerce product is purchased
• Purchase of specific WooCommerce products
• Purchase of products from specific categories
• Purchase from specific product tags

Any WooCommerce Product Purchase

To automatically send WooCommerce order details to Google Sheets whenever a customer purchases any product, go to your WordPress dashboard and navigate to MailOptin > Settings > WooCommerce Integration.

Here, you need to select Google Sheets as the integration method. Then, choose the spreadsheet where you want to store the order data.

Next, map the columns in your spreadsheet with the appropriate WooCommerce order details. For example, as illustrated in the image below, we are exporting the customers’ first names, last names, and email addresses, along with the order total, the names of the products purchased, and the date the order was paid.

To automatically send WooCommerce orders to Google Sheets right after a purchase, ensure the Subscribe Customers setting under Other Settings is set to “Automatically”. If you prefer to export only the orders whose buyers explicitly opted in by checking an optin checkbox during checkout, set to “Ask for Permission“.

Once you’ve made your selection, click Save Changes.

Purchase From Specific WooCommerce Products

If you want to send WooComemrce order details when customers purchase only certain products to Google Sheets, open the product edit page in WooCommerce. Scroll down to the Product Data section and click on the MailOptin tab.

In the Integration section, choose Google Sheets as the integration. Under the Select List section, pick the sheet where you want to save the WooCommerce customer and order details.

Finally, map the custom fields and save.

Purchase Products from Specific Categories

If you want to export orders for products purchased from a specific category to Google Sheets, follow the short guide below.

Go to WooCommerce > Products > Categories in your WordPress dashboard. Find the category and open its edit page.

Click the Connect button to open the setup window and configure the Google Sheets integration for the WooCommerce category.

Select Google Sheets as the integration, choose the sheet where the data should be saved, and map the necessary fields. This ensures that all purchases from that category are automatically synced with the Google Sheets file.

Once you’ve finished configuring the settings, click the Save Settings button.

Then, click the Update button to apply the changes after closing the setup window.

Purchase from Specific Product Tags

Like product categories, you can automatically send WooCommerce product orders with a specific tag to Google Sheets.

To set this up, go to WooCommerce > Products > Tags and open the edit page for the tag you want to connect with MailOptin.

On the edit page, you’ll see an option to connect MailOptin. This lets you link the tag to your Google Sheets for a seamless data export.

Click the Connect button to open the setup window and configure the integration.

Click the Save Settings button once you’ve finished.

Integrating WooCommerce Memberships to Google Sheets

Using the WooCommerce Memberships plugin to add members-only capability to your store? You can sync your member data to Google Sheets.

To integrate WooCommerce Memberships to Google Sheets using MailOptin, open the membership plan edit page in WooCommerce by navigating to WooCommerce >> Memberships >> Membership Plans, then click on the plan you want to edit.

In the MailOptin section, select Google Sheets as the integration, choose your desired spreadsheet, and map member data fields to the corresponding columns in your sheet.

Once you’re done, click Update to apply the changes.

With this setup, members will be automatically synced with Google Sheets, making managing and tracking memberships easier.

Integrate WooCommerce with Google Sheets Today

Integrating WooCommerce with Google Sheets using MailOptin offers a range of powerful benefits for your online store. It eliminates manual data entry, reduces errors, and ensures your records stay accurate and up-to-date.

The flexibility of Google Sheets also allows you to customize reports, analyze sales trends, and collaborate seamlessly with your team.

Whether tracking revenue, evaluating product performance, or planning marketing strategies, having your WooCommerce data instantly available in Google Sheets empowers you to make smart, data-driven decisions.

We hope this guide has made it easier for you to set up WooCommerce to Google Sheets integration.