WooCommerce is a WordPress extension that makes getting your online store off the ground much faster. It provides you with an eCommerce template, helps track orders, customers, and shipping, and a lot more! In this article, we’ll cover how to automatically add your WooCommerce orders to a Google Sheets spreadsheet using Zapier, which will make it even easier to keep up track of your online shop’s orders.
What You’ll Need:
- A WooCommerce account
- A WordPress website
- The WooCommerce plug-in installed on your WordPress website
- A Google Sheets account
- A Zapier account
Let’s get started!
Step 1: Add The Zapier Extension To Your WooCommerce Plug-In.
First things first, before you can use WooCommerce with Zapier you’ll have to download the Zapier extension for WooCommerce. Keep in mind that this is a paid plug-in, so if you don’t have it, you’ll need to purchase it in order to use Zapier with WooCommerce.
To do this, login to your WordPress website and click Extensions from your WooCommerce tab:
On the next page, you’ll search for “Zapier,” in the search bar, and select it when it appears:
Once you select the Zapier extension, you will be redirected to this page:
Pick the subscription option that corresponds to your needs and choose BUY NOW. That will bring you to this page:
Enter your WordPress login information and Continue to the next screen. On this screen, WooCommerce is going to ask if you already have a WooCommerce account. Choose I have an existing WooCommerce.com account – unless you’ve been following this tutorial without a WooCommerce account, in which case you’ll need to make one:
Now you’ll be asked to log in to WooCommerce to complete your purchase. Enter your login information, click Connect Account, and enter your payment info on the next page to complete your purchase:
Once you’ve made your purchase, you’ll be given a license key and a downloadable zip file. We’re going to use each of these to install the Zapier extension, so copy the license key and download the zip file.
Next, find the downloaded zip file – titled woocommerce-zapier – and move it to your desktop:
Next, go back to your WordPress website, navigate to Plugins near the bottom left, and select Add New:
This will bring you to the following page:
Near the top of the page you’ll notice a button that says Upload Plugin as indicated in the image above. Press it, then click Choose File, selected the woocommerce-plugin folder on your desktop, then select Install Now:
If you uploaded the correct zip file, you should now be looking at the following page:
As indicated, select Activate Plugin:
You should now see a little notification at the top of the page letting you know that your Zapier extension has been successfully installed! You’ll also get a little pop-up over in the left pane asking if you would like to create a Zapier Feed. For every Zap you make using WooCommerce, you’re going to need one of these Feeds. So, go ahead and select Click here to create one. This will bring you here:
We’re going to leave this window open while we work on the rest of the Zapier. For now, just make sure that New Order is selected as your Trigger and give the Feed a Title that matches what we’re going to be using it for, as in the image above. We’ll come back to this page in a bit.
Now, it’s time to create your Google Sheet!
Step 2: Create Your Google Sheets Spreadsheet For WooCommerce Orders.
Now we’re going to create the spreadsheet where your WooCommerce orders are going to appear. For this example, all of your orders are going to appear in Column 1.
Your rows will be added from top to bottom, so the oldest orders will be at the top of the spreadsheet, while the newest are at the bottom. If you have an existing Google spreadsheet that you’d like to use, feel free to use it, or create a new one just for this Zap. Your spreadsheet should look something like this:
As you can see, in our example we added a title in the first row, just to keep things looking nice. You’ll also notice that we stretched out the first column to be a little wider. This is so that the WooCommerce orders that get copied into the first column rows are completely visible.
Once you have your spreadsheet created, you’re ready to make your Zap!
Step 3: Create Your Zap
Now that we have all of the groundwork in place, we’re ready to start making our Zap! Log in to your Zapier account and go to your dashboard. You should be looking at the following screen:
In that top box, What Do You Want to Automate Today?, we’re going to create the skeleton for our Zap. In the first field, Connect this app…, type in “WooCommerce,” and select it when it appears – like in the screenshot above. Similarly, in the second box – with this app! – search Google Sheets and select it as well.
Once you have each selected, click the Make a Zap! button.
Step 4: Create Your WooCommerce Trigger
After you press the Make a Zap! button, you’ll be faced with the following screen:
This is where you’re going to choose your Zap’s Trigger. The “Trigger,” is what tells your Zap when to run. Every time your Trigger occurs, your Zap will fire into action. In our case, we want our Zap to run every time we get a new order in WooCommerce. So, choose New Order from the options, and Continue.
Next, Zapier will ask you to connect your WooCommerce plug-in to Zapier. Remember our Zapier Feed page that we left open in WordPress? This is where it comes into play. You should be looking at the following screen in Zapier:
Click the Copy button to the write of the url, known as your Webhook URL. This url is what’s going to connect this Zap to our WooCommerce account. Now go back to the Zapier Feed page we left open from earlier, and paste your Webhook into the Webhook URL field. Once you’ve done that, go back to Zapier and click Ok, I did this at the bottom of the page.
Now Zapier is going to ask you to pull in a sample from WooCommerce to use with this Zap. This sample will either be from an existing order on your WooCommerce account or a randomly generated one by Zapier.
We’re going to use a randomly generated one, though you’re free to use an existing one if you like. Once you’ve got your sample, you’re ready to move on to the next step!
Step 5: Create Your Google Sheets Action
After you finish creating your Zap’s Trigger, you’re going to be faced with the following screen:
This is the section we’re actually going to decide what our Zap does once it’s running. In our case, that’s going to be copying our latest WooCommerce order over to our Google Sheets spreadsheet that we created in Step 2. You should see Google Sheets listed first – since that’s we chose in Step 3 – but if you don’t, you can easily search for it in the search field at the top. Once you have it selected, Continue.
On the next screen, you’re going to pick your Google Sheets action. In our case, that’s going to be Create Spreadsheet Row:
Once you have that selected, Continue.
Now you’re going to connect your Google account to Zapier. If you’ve already done this before, you’ll just choose your Google account and hit Continue, like below:
Otherwise, you’ll choose Connect an Account and follow the on-screen prompts.
You should now be looking at the following screen:
This is your Action template. This is where we’re going to specify exactly what we want Zapier to do when this Zap runs. You’ll notice that be each field is a little dropdown arrow. This dropdown arrow provides you with information from your Google Sheets account, your WooCommerce account, and other data that you’ve used previously in this Zap – like the sample we generated in Step 4. This allows you to customize your Zap and set it up exactly how you like.
In the first field, you’re going to select the Google Drive you want to use with this Zap. This is optional, so you only need to fill it in if you have more than one Google Drive on your Google account.
In the second field, Spreadsheet, you’re going to pick the spreadsheet we created in Step 2 from the dropdown menu:
The third field is where you’ll choose the Sheet of your spreadsheet that is used. For most people – including those who created their spreadsheet while reading this tutorial – you’re just going to choose Sheet1 from the dropdown menu.
The fourth and last field is where you get to exercise some creativity. This is where you’ll decide what gets copied into your spreadsheet every time you get a new WooCommerce order. If you just type in, “New order,” Zapier is just going to copy “New Order,” into your spreadsheet for every order you get – not very useful.
Instead, we’re going to use variables. Variables allow you to fill in the field with information that will change depending on the order. For example, if Ted orders something through your website, the First Name variable will say, “Ted”. Pretty simple!
You can fill in this field to contain whatever you need; if all you need is the order number from each of your orders, then you can choose that variable and leave the rest of the field blank. We’re going to take a slightly more filled-out approach, though, just to give you a feel for how it works.
The first thing we want to know is the customer’s name. In the fourth field, type, “Customer: “. Include the space after the “:”, in order to make things easy to read. Then, from the dropdown menu, choose the variables for your customer’s first and last names (they’ll be the name from the sample we created in Step 4, and won’t actually be used when the Zap runs for real). Be sure to but a space between the two variable bubbles so that they don’t run together.
It should look something like this:
Next, we’re going to include the order number. On a new line (in the same field) type, “Order #: “ and follow it with the order number variable in the dropdown menu. After that, on another line, type, “Amount Paid: “. This is where we’re going to put the subtotal – not the total. We also recommend including the currency variable just before the subtotal variable, just so you always know what currency the customer used.
Your finished template should look something like this:
Once you’re happy with it, you’re ready to Continue to the last step.
Step 6: Test Your Zap.
Typically, we recommend skipping the testing portion of creating your Zap, just because most Zaps are so simple that it’s not really necessary. In this case, though, you want to make sure that the formatting is correct, otherwise, you’ll have a hard time understanding your spreadsheet later on.
After finishing the last step, you should see the following:
As indicated with red in the above screenshot, go ahead and Send Test To Google Sheets. This will send the sample template we just created to your WooCommerce spreadsheet in Google Sheets:
Pretty quickly, you can see that there is already a problem with our example. The new row we just created is using the same format as our title cell! This is because each new row created by Zapier will copy the format of the row directly above it. This means that so long as we fix our sample row, the rest will be formatted correctly.
To do this, we’re going to use the Format Painter tool. Select a blank cell in the first column, and choose the Format Painter tool at the top of the page:
Once you’ve done this, just click the second row containing our sample WooCommerce order. This will correct it to the format we intended, like so:
From now on, all future cells will be formatted like this. Make sure that you didn’t forget any spaces, and that you’re happy with the information in your cell.
Once you’re happy, you can go back to Zapier and Continue to the final step – turning your Zap on!
On the next screen, all that’s left to do is name your Zap and turn it on:
Keep in mind that once you turn this Zap on, it’s going to add a new row to your spreadsheet every time you get a new WooCommerce order unless you turn it off.
Here’s a quick recap of everything we did:
- Added the Zapier plugin to WooCommerce
- Created a spreadsheet in Google Sheets for our WooCommerce orders
- Set our Zap to run every time we get a new WooCommerce order
- Set our Zap to copy pertinent information from our new WooCommerce orders to our Google Sheets spreadsheet
- Made sure that the formatting of our orders is correct
- Then we turned our Zap on!
From here on out, you’re going to be able to keep track of your WooCommerce orders in a simple and easy to read format that only includes the information you care most about. You can use this simply to stay on top of your WooCommerce orders, or use it to share your WooCommerce orders with your team, integrate this spreadsheet with other Zaps, and so on.
This is only a sample of what can be accomplished through Zapier. Don’t hesitate to explore what else the service has to offer, and get creative with your automations!