• Skip to primary navigation
  • Skip to main content
ShopMagic

ShopMagic

  • Pricing
  • Add-ons
  • Docs
  • Support
  • Blog
  • Ideas
  • My account
How to Connect WooCommerce to Google Sheets (Fast & Free)

Updated: March 2, 2023 / Blog

How to Connect WooCommerce to Google Sheets (Fast & Free)

Damian Machnik

This is a step-by-step guide showing you how to connect your WooCommerce store with Google Sheets for free, no matter how much data you will send.

You won’t need to go through lengthy external integrations or flows, understand weird terminology, create scripts, APIs or webhooks to make it work.

To do it as fast as possible, we will use the ShopMagic plugin for Google Sheets. It’s one of the simplest methods to link your WooCommerce store and a G spreadsheet.

Read on to learn how to set up your WooCommerce and Google Sheets connection in EXACTLY 7 clicks (and one copy-paste).

And if you don’t have a lot of time on your hands…

I’m not interested in your Google-optimized article, just take me straight to the guide 👇

Connect your WooCommerce store with a Google spreadsheet – benefits

Google Suite apps are used by approximately 2 billion users every month. 

Although Google Sheets is only a part of this package, it’s still an impressive number and places it as one of the most popular spreadsheet solutions. 

Send Woocommerce Data To Google Sheets for Analysis

Connecting your WooCommerce store with a Google Sheets spreadsheet will let you store your data in a tabular form that’s easy to read, process, and analyze. What else?

Google’s spreadsheet software is also well documented, so there’s a possibility that whatever you would like to achieve with your data, a solution is already out there.

What can you use Google Sheets for? Here are just a couple of ideas:

  • customer segmentation and insights
  • product sales analytics
  • inventory management
  • accounting
  • sales forecasting
  • connecting your data with other apps

…but be careful with your tools

A lot of tools that let you connect and send data between different systems (like WooCommerce and Sheets) base their pricing on the number of operations you perform monthly.

This means that if you’re not paying attention and exceed a certain amount of actions, your invoice can get 2-3x higher really quickly.

This kind of pricing also punishes you for growing – the more actions you perform, the more you will pay.

Not fair, right?

That’s why we created a solution to give you more flexibility and peace of mind, so you don’t have to nervously check your monthly usage and wonder if it will be enough to stay within budget. 

It doesn’t matter how much data you will send from your store, ShopMagic for Google Sheets will remain free.

Google Sheets – a perfect tool for your eCommerce analysis?

Google Sheets is free software that will help you make data-driven decisions easier. It provides all the basic functions that an eCommerce store needs to analyze and draw conclusions from its data.

While it’s certainly not as powerful as tools like Power BI or Tableau, it lets you easily perform both general and more advanced operations like RFM analysis and segmentation.

Sheets provide essential functions for reporting and data analytics and can be used by everyone, even if you never had the time to learn using spreadsheet software, analytics, or data science.

Here’s why you should consider moving your WooCommerce data to Google Sheets:

  1. No interface restrictions – freely sort, filter, modify and move your data around cells
  2. A lot of built-in visualization options (charts)
  3. Functions that will help you with your calculations
  4. Online, shareable access with just a link
  5. Several support options including official Google Docs support forum and online communities
  6. You can export and download your data using 6 different file formats
  7. Easy integration with Google Data Studio if you ever need a full-blown custom dashboard
  8. Access to advanced options like add-ons and scripts
  9. Ready-to-use apps, extensions, and integrations from the official Google Workspace Marketplace

Although Google Sheets is a great solution, you may wonder why it would be better than the analytics module you already have available in your WooCommerce dashboard?

Let’s find out!

Google Sheets vs WooCommerce analytics

WooCommerce built-in analytics module shares the same fate as some of the other tools provided natively (another example: WooCommerce emails).

It’s there. It’s working. It’s enough so you don’t have to worry about it from day one. 

But it might not be enough if you need anything more than a simple periodic check-up.

Some of the WooCommerce analytics’ disadvantages include:

  1. Limited filtering options
  2. Clunky appearance that makes the analysis harder
  3. You can’t reorder any of the items
  4. It’s made purely for data viewing, not calculations or modifications
  5. No ability to create custom reports
  6. Manual data export only supports CSV files

Feeling good about Google Sheets yet? Great, now let’s head below and see how to put your data into it.

The setup – your WooCommerce store and Google Sheets

Here I will skip the obvious part. Many guides waste your time by including the whole process of creating a new WooCommerce store – that’s NOT what we’re going to do here. 

Not

If you still need some guidance to create your WooCommerce store, you can read the official guide by WooCommerce explaining how to create your store.

Since you’re already looking for a way to send your eCommerce data to a Google document, then probably you already have a functioning WooCommerce store.

Now comes the second part – setting up your Google Sheet and other tools.

What will you need – checklist

Let’s not make it longer than it should be. Here are the 4 things you will need to make a WooCommerce <-> Google Sheets integration work:

1. Google account
You need it to access Google Sheets and other Google apps.

2. Google spreadsheet that will receive your data
A spreadsheet where you will store your WooCommerce figures.

3. ShopMagic for WooCommerce core plugin
You can get it from the official WordPress plugins’ directory right here or install it directly from your WordPress dashboard.

4. ShopMagic for Google Sheets add-on plugin
Just as the core ShopMagic plugin, the Google Sheets add-on can be found in the WordPress plugin’s directory or installed directly from Plugins -> Add new menu in your WordPress dashboard.

That’s it! Now let’s move to the step-by-step integration guide.

Create a spreadsheet that will receive your order data

In the following steps we will set up the WooCommerce <-> Google Sheets connection. It’s best if you already have a spreadsheet ready from the beginning. This will make the process smoother since you won’t need to pause to create a new spreadsheet.

You can do this by going to the Sheets app right here and clicking the big plus icon.

New Spreadsheet For Woocommerce Data

If you’re not sure what WooCommerce data would you like to pass to the Google spreadsheet yet, feel free to copy our Sheets template that includes the following columns:

  • Order ID
  • Date
  • Total
  • Customer email
  • Customer name
  • Customer phone
  • City
  • Shipping method
  • Products ordered
  • See order link

In the next steps, I will show you how to automatically send your order data to populate each row, column, and cell using ShopMagic placeholders.

Install ShopMagic plugin for Google Sheets 

Note: ShopMagic is a lightweight plugin that works “in the back” and will not affect your store performance. 

After you have prepared the spreadsheet, it’s time to get the free ShopMagic plugins.

1. First, you will need to install the ShopMagic core plugin. It’s a plugin that will provide the whole interface to create an automation that will pass your desired WooCommerce data to Google Sheets.

🔽 You can download the ShopMagic core ZIP file directly right here or from the WordPress plugins directory.

2. The second plugin you need to download is ShopMagic for Google Sheets – an add-on that is responsible exclusively for setting up the connection between your WooCommerce store and Google Sheets.

🔽 Download the ZIP file or go to the WordPress plugin page.

You can also find both plugins by searching for “shopmagic google sheets” in your WordPress dashboard menu under Plugins -> Add new:

How to find ShopMagic plugins from your WordPress dashboard

Connect your WooCommerce store and Google Sheets

Once you have your spreadsheet and plugins in place, it’s time we set up the actual integration with 7 clicks – just like I promised at the beginning of this article.

Click 1. Go to ShopMagic -> Settings -> Google Sheets tab. Here you will find an empty field labeled “Google Sheets Token”.

To get your token (it’s really simple and will require only copy-pasting) and authorize data exchange between WooCommerce and Google Sheets, click on the “Get Google Sheets token” link.

Get Token For Woocommerce Google Sheets Integration For Shopmagic Email Marketing Plugin

Click 2. After clicking the link, a new browser tab will open. Please choose a Google account that you would like to connect with your WooCommerce store.

Choose the Google account you would like to use for integration

Click 3. Click on “Allow” to proceed. In this step you will be asked to allow ShopMagic to do two things:

  • See information about your Google Drive files – spreadsheets are saved there, ShopMagic will not read any other files you have stored on your G Drive
  • See, edit, create, and delete your Google spreadsheets – no, ShopMagic will not create or delete your spreadsheets. That’s just Google’s way of naming the permission level we need to make the integration work

Please remember that ShopMagic apps are open-source (everyone can inspect our code) and meet both WordPress and Google quality and security standards. Your data is safe and we do not store it on our servers.

Confirm Google permission settings

Click 4. Now the token will appear – please copy it by clicking on the icon next to it (or highlighting it and pressing Ctrl+C/Cmd+C).

Copy Google Sheets token

Click 5, 6, & 7. Go back to the tab where you have your ShopMagic settings opened and paste the token. Click on the “Save changes” button.

Save Token For Google Sheets Woocommerce Integration With Shopmagic Plugin

Good job! The integration part is done. Now we will set up and customize the automation that will send your new orders to a Google Sheet.

Set up an automation that will send your new order data to a spreadsheet

Now it’s time to create a process that will fill your Google spreadsheet with eCommerce data.

1. From your WordPress menu, choose ShopMagic -> Add new. This will create a new automation (you can learn more about automation from the ShopMagic documentation)

Add New Marketing Automation For WordPress And Woocommerce

Send New Order Data From Woocommerce To Google Sheets

2. Apply the following settings to your automation (here I’m using the Google Sheet template named “ShopMagic WooCommerce Data to automatically set the first row as column names):

Export Woocommerce New Order Data To Google Sheets

Export Woocommerce New Order Data To Google Sheets Settings
Export WooCommerce new order data to Google Sheets

  • Event: New order
  • Actions: Add row to Google Sheet
  • Spreadsheet: here you will see a list of all your Google spreadsheets – please choose the one which should be populated with your order data
  • Spreadsheet tab: choose a specific tab
  • Is first row a header?: click “checked” if the first row of your spreadsheet contains the column name
  • Order ID: use the {{ order.id }} placeholder
  • Date: use the {{ order.date_created }} placeholder
  • Total: use the {{ order.total }} placeholder
  • Customer email: use the {{ customer.email }} placeholder
  • Customer name: use the {{ customer.name }} placeholder
  • Customer phone: use the {{ customer.phone }} placeholder
  • City: use the {{ order.shipping_city }} placeholder
  • Shipping method: use the {{ order.shipping_method }} placeholder
  • Products ordered: use the {{ order.products_ordered }} placeholder
  • See order link: use the {{{ order.admin_url }}{ placeholder

3. Click the “Publish” button.

Fireworks

Congratulations! You have successfully set up your integration. From now on, every new order placed in your store will trigger an automation that adds a new row to your Google spreadsheet, populating its cells with your order’s data.

Connecting WooCommerce and Google Sheets – summary

I hope that this guide gave you easy-to-follow instructions on how to link and send data from your WooCommerce store to a Google spreadsheet and inspired you to explore possible applications of such integration.

Here you can find the resources mentioned in this article:

  • Google Sheets basic template you can use in your automation – create a copy
  • ShopMagic for WooCommerce plugin (core) – download ZIP file
  • ShopMagic for Google Sheets (add-on) – download ZIP file

 

About Damian Machnik

Product Manager at WP Desk. Every day I try to create better and more interesting products. If you have any questions, go ahead and email me!

  • Terms & Conditions
  • Privacy Policy
  • Support Policy
  • Refund Policy

© 2023 A WP Desk WP Desk Automation