Connect WooCommerce to Google Sheets: 3 Easy Steps

on Google sheets, Tutorials, WooCommerce • December 7th, 2021 • Write for Hevo

The E-Commerce industry is expanding as a result of predicted growth and the impact of novel Coronavirus on commerce. Every day, more shops are moving to online sales, and more entrepreneurs are starting their businesses through E-Commerce. Based on multiple research studies, Statista has predicted that by 2022 E-Commerce revenue will grow to 6.54 trillion dollars. As the E-Commerce industry is flourishing, it is high time to use the best tools available to store and analyze data. Connecting WooCommerce to Google Sheets is the best option available in the market.

Google Sheets is a widely used free spreadsheet application developed by Google. You can easily manage and analyze your store order and customer data by connecting WooCommerce to Google Sheets. With WooCommerce Google Sheets Integration, you can also share your order data or any other data in this regard with your team without having them sign in to your WordPress account.

This article will introduce you to WooCommerce and Google Sheets. It will elaborate on how these are some of the best tools available in the market. It will further provide you with a step-by-step guide that will help you connect WooCommerce to Google Sheets using WooCommerce Webhook. It will also provide you with the advantages and disadvantages of connecting WooCommerce to Google Sheets.

Table of Contents

Prerequisites

Listed below are the prerequisites of connecting WooCommerce to Google Sheets:

  • A fully functioning WooCommerce Store.
  • A Google account with administrator access.
  • A basic understanding of working with Google Sheets.

Introduction to WooCommerce

WooCommerce logo
Image Source

WooCommerce is a free plugin offered by Automattic (the same company that owns WordPress) that allows you to use WordPress to create an online store. It converts the standard WordPress operating system into a fully functional E-Commerce store. WooCommerce provides you the tools to seamlessly and economically sell any goods/services on your website. With WooCommerce, you can perform various tasks like selling products (both digital and physical), accepting secure payments, managing inventory, and automatically sorting the taxes on different products.

According to a research study by Built With, WooCommerce is the most popular E-Commerce plugin available in the market. It powers about 27% of the top 1 million E-Commerce websites worldwide because it is adaptable and beginner-friendly.

Key Features of WooCommerce

Some of WooCommerce’s key features are listed below:

  • Open Source: WooCommerce is a fully Open Source platform and is completely handled on GitHub. This allows everyone to review, alter, or contribute to the code.
  • Customizable: Customizability is one of WooCommerce’s best features. You can customize almost every component of your website to match your brand or type of business. From the product page through the order confirmation page, you have complete control over your website.
  • Multiple Payment Gateways: WooCommerce provides 100z+ payment gateway alternatives, including Stripe, PayPal, Apple Pay, etc. Typically, these gateways charge around 2.9 percent, but this varies significantly depending on the provider.

For more information on WooCommerce, click here.

Introduction to Google Sheets

Google Sheets logo
Image Source

Google Sheets is a Web-Based Spreadsheet application from Google that allows you to create, update, alter and share data in real-time. It houses all the standard spreadsheet functions such as the ability to add, delete, and sort rows and columns. However, unlike other spreadsheet tools, Google Sheets allows multiple users (living at distant locations) to work on a spreadsheet at the same time and communicate using the built-in instant messaging program.

Key Features of Google Sheets

Some of Google Sheets’ key features are listed below:

  • Modify/Update: Google Sheets provides you the ability to update spreadsheets in real-time. Rather than sending several copies of a document via E-Mail, a single document can be opened and changed by multiple individuals at the same time. All modifications made by other contributors are visible to everyone (with access), and all these modifications are automatically saved to the admin’s Google Drive.
  • Google Explore: Google Sheets provides you the Explore feature that helps you to ask questions, generate charts, construct pivot tables, visualize data, and color-code the spreadsheet.
  • Supports Multiple File Formats: One of the most prominent features of Google Sheets is that it accepts a variety of spreadsheet file formats. Google Sheets allows you to open, modify, save, and export these spreadsheets files. Some of the formats that Google Sheets supports include .xlsx, .xls, .xlsm, .xlt, .xltx, .xltxm, .ods, .csv, .tsv, etc.

For more information on Google Sheets, click here.

Simplify WooCommerce & Google Sheets ETL using Hevo’s No-code Data Pipeline

Hevo Data, a No-code Data Pipeline helps to Load Data from any data source such as Databases, SaaS applications, Cloud Storage, SDKs, and Streaming Services and simplifies the ETL process. It supports 100+ data sources (including free data sources like Google Sheets, WooCommerce, etc.) and is a 3-step process by just selecting the data source, providing valid credentials, and choosing the destination. Hevo loads the data onto the desired Data Warehouse, enriches the data, and transforms it into an analysis-ready form without writing a single line of code.

Its completely automated pipeline offers data to be delivered in real-time without any loss from source to destination. Its fault-tolerant and scalable architecture ensure that the data is handled in a secure, consistent manner with zero data loss and supports different forms of data. The solutions provided are consistent and work with different Business Intelligence (BI) tools as well.

Get Started with Hevo for free

Check out why Hevo is the Best:

  • Secure: Hevo has a fault-tolerant architecture that ensures that the data is handled in a secure, consistent manner with zero data loss.
  • Schema Management: Hevo takes away the tedious task of schema management & automatically detects the schema of incoming data and maps it to the destination schema.
  • Minimal Learning: Hevo, with its simple and interactive UI, is extremely simple for new customers to work on and perform operations.
  • Hevo Is Built To Scale: As the number of sources and your data volume grows, Hevo scales horizontally, handling millions of records per minute with very little latency.
  • Incremental Data Load: Hevo allows the transfer of data that has been modified in real-time. This ensures efficient utilization of bandwidth on both ends.
  • Live Support: The Hevo team is available round the clock to extend exceptional support to its customers through chat, email, and support calls.
  • Live Monitoring: Hevo allows you to monitor the data flow and check where your data is at a particular point in time.
Sign up here for a 14-day Free Trial!

Steps to Connect WooCommerce to Google Sheets

WooCommerce to Google Sheets Connection image
Image Source

In this section, you will be connecting WooCommerce to Google Sheets using WooCommerce Webhooks. WooComemrce Webhooks allow your Google Sheet to fetch all your E-Commerce store orders and store them safely. Follow the steps below to connect WooCommerce to Google Sheets and export your data from WooCommerce to Google Sheets in real-time:

Step 1: Create a Google Sheet

Create a Google Sheet where you want to export your WooCommerce data and add the necessary fields as shown in the image below.

Creating Google Sheet image
Image Source

NOTE: For ease of explanation, you will be adding 5 fields (viz. Data Added, Order Number, Order Due, Order Status, and Order Link) in your Google Sheet.

Step 2: Add and Deploy the Google Apps Script

Once you have added the necessary fields in your Google Sheet, go to the “Extensions” menu from the menu bar and select “Script Editor”. This will open up a Script Editor window where you can add your custom script. Copy-paste the code given below the Script Window.

//get invoked when web app receives a GET request
function doGet(e) {
  return HtmlService.createHtmlOutput("request received");
}

//get invoked when webapp receives a POST request
function doPost(e) {
  var myData = JSON.parse([e.postData.contents]);
  var order_number = myData.number;
  var order_created = myData.date_created;
  var order_status = myData.status;
  
  var timestamp = new Date();
  var sheet = SpreadsheetApp.getActiveSheet();
  sheet.appendRow([timestamp,order_number,order_created,order_status]);
}

The above given Google Apps Script will fetch data from the WooCommerce Webhooks and parse & add that data to your Google Sheet. To know more about the functioning of Google Apps Script, click here.

Once you have added the script, follow the steps below to deploy it as a web app:

  • Click on the “Deploy” button from the top and select the “New Deployment” option.
  • This will open up a popup. Select “Web App” as the deployment type as shown in the image below.
New Deployment image
Image Source – Self
  • Here, select “Me” under “Execute as” and “Anyone” under “Who has access” as shown in the image below.
Web App Deployment Settings image
Image Source – Self
  • Click on the “Deploy” button.
  • After a successful deployment, a message will appear indicating the same. It will also provide you with the Web App URL as shown in the image below. Copy that URL and keep it save as you will require it later.
Successful Web App Deployment image
Image Source – Self

Step 3: Create the WooCommerce Webhook

After the successful deployment of your Google Apps Script, you need to create a WooCommerce Webhook to export data from WooCommerce to Google Sheets. This WooCommerce Webhook will get invoked whenever an order is created. Follow the steps below to create a WooCommerce Webhook:

  • Log in to your WooCommerce account and go to “Settings”.
  • Go to Advanced > Webhooks.
  • Paste the Web App URL that you copied in the last step under the “Delivery URL” field as shown in the image below. This will send the order information to the Delivery URL whenever an order is placed.
WooCommerce Webhook Settings image
Image Source
  • Click on the “Save Webhook” button.
  • Make sure that your WooCommerce Webhook is listed in the Active Webhooks.

That’s it! You have successfully connected WooCommerce to Google Sheets. Now, the information of all your orders will appear in the Google Sheet.

Advantages of Connecting WooCommerce to Google Sheets

Listed below are some of the major advantages of connecting WooCommerce to Google Sheets:

  • You can easily analyze and sort your order data after connecting WooCommerce to Google Sheets.
  • With WooCommerce Google Sheets Integration, you can use Google Sheets’ visualization tools to convert your data in the form of charts and graphs. This gives a clearer picture of your data.
  • WooCommerce to Google Sheets connection allows your team to access data without having to create a separate login.

Disadvantages of Connecting WooCommerce to Google Sheets

Listed below are some of the major disadvantages of connecting WooCommerce to Google Sheets:

  • As your data grows(which is bound to happen as your business flourishes), the complexity increases and you need visualization options to read and analyze your data. In such a case, Google Sheets does not provide a wide range of options unlike Microsoft Excel, etc.
  • When it comes to formulas available in Google Sheets to manipulate data, they are insufficient for complex accounting and bookkeeping.

Conclusion

The article introduced you to WooCommerce and Google Sheets. It further elaborated on the key features that make them one of the widely used tools in any business model. It also provided a comprehensive step-by-step guide on how to connect WooCommerce to Google Sheets using WooCommerce Webhooks.

With the complexity involved in Manual Integration, businesses are leaning towards Automated Integration. It is hassle-free, easy to operate, and does not require any technical background. In such a case you can explore more of Hevo Data. Hevo Data supports 100+ data sources (including free data sources like Google Sheets, WooCommerce, etc.)

Visit our Website to Explore Hevo

Want to take Hevo for a spin? Sign Up for a 14-day free trial and experience the feature-rich Hevo suite first hand.

Share your experience of connecting WooCommerce to Google Sheets in the comments section below!

No-Code Data Pipeline for your Data Warehouse