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.
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:
- No interface restrictions – freely sort, filter, modify and move your data around cells
- A lot of built-in visualization options (charts)
- Functions that will help you with your calculations
- Online, shareable access with just a link
- Several support options including official Google Docs support forum and online communities
- You can export and download your data using 6 different file formats
- Easy integration with Google Data Studio if you ever need a full-blown custom dashboard
- Access to advanced options like add-ons and scripts
- 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:
- Limited filtering options
- Clunky appearance that makes the analysis harder
- You can’t reorder any of the items
- It’s made purely for data viewing, not calculations or modifications
- No ability to create custom reports
- 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.
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.
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.
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.
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.
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.
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).
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.
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)
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):
- 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.
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
