Latest Tech and Tips

How to Connect Google Sheets with WooCommerce (in 5 mins)


Do you desire to connect Google Sheets with WooCommerce?

Connecting Google Sheets with WooCommerce allows you quickly take care of order and also client information and also share it with the remainder of your group.

In this short article, we’ll reveal you how to connect Google Sheets with WooCommerce, detailed.

How to connect Google Sheets with WooCommerce (in 5 minutes)

Why Connect Google Sheets with WooCommerce in WordPress?

Google Sheets is a popular complimentary spread sheet software program fromGoogle Connecting Google Sheets and also WooCommerce allows you just take care of and also evaluate your shop order and also client information.

You can likewise share this information with your group without having them login to your WordPress control panel.

Integrating Google Sheets and also WooCommerce can assist your on-line shop in a great deal of methods.

  • Easily evaluate and also arrange client order information
  • Quickly existing shop information in graphes and also charts
  • Sort and also filter information by total amount, area, vouchers utilized, and also much more
  • Give group accessibility to information without developing a different login

That being claimed, allow’s have a look at how to connect Google Sheets with WooCommerce, in 5 mins.

Setup Your WooCommerce Store and also Google Sheets

First point, you require to have a completely operating WooCommerce shop established. If you’re still constructing your shop, after that see our detailed overview on how to begin an on the internet shop.

Note: you’ll likewise desire to ensure you’re utilizing excellent quality WooCommerce holding and also a WooCommerce motif to guarantee your shop looks fantastic and also lots quick.

WooCommerce store example

Next, you’ll require to produce a Google Sheets spread sheet that you’ll send out WooCommerce shop information to.

Head over to the Google Sheets website and also click ‘Blank’ to include a brand-new spread sheet.

Add new Google Sheet

Then, when including columns to your spread sheet, you desire these to match the sort of WooCommerce information you desire to gather.

In this situation, we have a spread sheet with the client’s name, e-mail, phone, the items they purchased, and also the complete rate.

WooCommerce to Google Sheets spreadsheet

You can import all type of WooCommerce information, consisting of area, vouchers utilized, the condition of the order, time of the order, and also a lot more.

Install and also Activate the Uncanny Automator Plugin for WordPress

To connect Google Sheets to WooCommerce, we’re going to be utilizing an automation plugin.

The ideal WordPress automation plugin isUncanny Automator It works as a port in between your WordPress site and also various other applications, so they can chat to each various other without you composing any kind of code.

Uncanny Automator Plugin

It’s like Zapier for WordPress sites without the high prices ofZapier

Uncanny Automator is really simple to usage and also comes with all type of automated operations that you can establish in a number of clicks (no coding required).

Note: there is a free version of the plugin readily available, yet we’ll make use of the Pro variation for this tutorial because it has the Google Sheets combination we require.

For even more information, see our overview on how to produce automated operations in WordPress with Uncanny Automator.

Connect Your Google Account with Uncanny Automator

Upon activation, you require to connect Uncanny Automator to your Google account.

First, browse to Automator” Settings and also click the ‘Google’ food selection product.

Connect Google Account

Next, click the ‘Connect an account’ switch. This takes you to a display where you can license your Google account.

Then, choose the Google account you desire to connect and also click the ‘Allow’ switch.

Give Uncanny Automator permission

After that, you require to click ‘Allow’ again to license your account and also validate your options.

This will certainly take you back to the Google setups web page in your WordPress admin panel.

Google Account connection success

That’s all, you have actually efficiently linked your WordPress website to Google Sheets utilizingUncanny Automator

Connect WooCommerce to Google Sheets with Uncanny Automator

Now, you’re prepared to connect your on-line shop to the Google Sheets spread sheet you produced previously.

Uncanny Automator utilizes “recipes” to produce automations and also web link applications and also plugins with each other.

The very first point you require to do is browse to Automator” Add brand-new, click the ‘Anonymous’ choice, after that click ‘Confirm’.

Select anonymous recipe

Anonymous dishes can be set off by any kind of individual, while logged-in dishes can just be set off by visited customers.

You require to pick the sort of dish based upon your requirements and after that click the ‘Confirm’ switch.

For the purpose of this tutorial, we’ll be developing a confidential dish that immediately sends out WooCommerce order information to Google Sheets the minute an order is finished.

After that, you require to provide your dish a name. This will not show up to your customers, yet it will certainly assist you recognize the various dishes you produce.

There are 2 various components to each dish, the trigger, and also the activity.

Anonymous triggers and actions

The trigger is the occasion that will certainly begin the dish, and also the activity is the job that will certainly run when the activity is set off.

First, you require to choose ‘WooCommerce’ in the ‘Anonymous trigger’ meta box.

Select WooCommerce trigger

Then, you can pick the trigger.

We’ll choose the very first choice from the drop-down food selection because this allows you send out WooCommerce information when an order is full.

Select first WooCommerce trigger

After that, you require to pick the trigger problem.

Select the ‘completes’ choice from the drop-down food selection to cause the automation when a consumer finishes an acquisition and after that click ‘Save’.

Completes order trigger condition

Now, you can pick a certain item or any kind of item from your WooCommerce shop to run the trigger on.

To pick any kind of item in your shop, choose the ‘Any product’ choice and after that click ‘Save’.

Trigger any product in store

Now, you can relocate onto the Actions area. You’ll see various choices relying on if you selected a confidential or logged-in dish.

If you selected an Anonymous dish over, after that you require to produce a brand-new customer individual in WordPress initially. This brand-new individual will certainly be utilized to send out the kind information via.

For even more information, see our overview on how to include brand-new customers and also writers to your WordPress blog site.

Now, choose the ‘Existing user’ choice in the ‘Actions’ meta box.

Select existing user

This raises a popup to pick the brand-new customer individual function you simply produced and also get in the individual ID.

If you do not understand the individual ID, after that you can discover this by going to Users” All Users and also editing and enhancing the individual account.

Then, in the URL you can discover the individual ID.

Find user ID

After that, choose ‘Subscriber’, get in the ID, and also choose ‘Do nothing’ for existing customers.

Then, click the ‘Save’ switch to proceed.

Select do nothing and save

Next, click the ‘Add action’ switch.

Then, choose ‘Google Sheets’ from the listing of assimilations.

Select Google Sheets

Once you’ve done that, pick the ‘Create a row in a Google Sheet’ choice situated in the ‘Select an action’ box.

Create a row in Google Sheets

This will certainly raise a drop-down food selection where you can choose the spread sheet you produced previously.

Then, choose the ‘Spreadsheet’ and also‘Worksheet’

(*5 *)

Next, you require to click the ‘Get columns’ switch.

This will certainly import the rows from your spread sheet.

Select get columns

You requirement to map your spread sheet columns to the WooCommerce order information by clicking the ‘Asterisk’ symbol and also picking the WooCommerce area from the drop-down listing.

Match order and spreadsheet columns

After you’ve compared every one of your areas, it will certainly look comparable to the setups listed below.

You can pick WooCommerce delivering details, nevertheless we determined to make use of the WooCommerce payment details because the get in touch with details can be much more precise.

WooCommerce to Google Sheets columns

Make certain you click ‘Save’ when you’re done developing your dish.

Now, you can check out the complete automation recap to ensure it looks right. After that, it’s time to make your dish live.

At the top of the dish editor, in the’ Recipe’ box, switch over the Draft toggle to ‘Live’.

Review recipe and make live

Your brand-new dish will certainly currently be energetic, and also you’ll immediately send out brand-new WooCommerce order information to Google Sheets when an acquisition is full.

Make certain to examination your automation to see that the dish is set off and also the right activity is carried out.

If you desire to include a lot more automations to your WooCommerce shop, after that see our overview on how to send out Twilio SMS alerts from WooCommerce.

We wish this short article assisted you find out how to connectGoogle Sheets with WooCommerce You might likewise desire to see our specialist choices of the very best WooCommerce plugins for your shop and also our utmost WooCommerce SEO overview to obtain even more website traffic.