Methods to Join Google Sheets with WooCommerce (in 5 minutes)

No Comments

Do you need to join Google Sheets with WooCommerce?

Connecting Google Sheets with WooCommerce permits you to simply handle order and buyer knowledge and share it with the remainder of your group.

On this article, we’ll present you methods to join Google Sheets with WooCommerce, step-by-step.

Why Join Google Sheets with WooCommerce in WordPress?

Google Sheets is a extremely popular free spreadsheet software program from Google. Connecting Google Sheets and WooCommerce permits you to merely handle and analyze your retailer order and buyer knowledge.

You may also share this knowledge together with your group with out having them login to your WordPress dashboard.

Integrating Google Sheets and WooCommerce might help your on-line retailer in a variety of methods.

Simply analyze and type buyer order knowledge
Rapidly current retailer knowledge in charts and graphs
Type and filter knowledge by complete, location, coupons used, and extra
Give group entry to knowledge with out making a separate login

That being mentioned, let’s check out methods to join Google Sheets with WooCommerce, in 5 minutes.

Setup Your WooCommerce Retailer and Google Sheets

Very first thing, you’ll want to have a completely functioning WooCommerce retailer arrange. In case you’re nonetheless constructing your retailer, then see our step-by-step information on methods to begin a web based retailer.

Word: you’ll additionally need to be sure to’re utilizing top quality WooCommerce internet hosting and a WooCommerce theme to make sure your retailer appears to be like nice and masses quick.

Subsequent, you’ll have to create a Google Sheets spreadsheet that you simply’ll ship WooCommerce retailer knowledge to.

Head over to the Google Sheets web site and click on ‘Clean’ so as to add a brand new spreadsheet.

Then, when including columns to your spreadsheet, you need these to match the kind of WooCommerce knowledge you need to gather.

On this case, now we have a spreadsheet with the shopper’s identify, electronic mail, cellphone, the merchandise they ordered, and the whole worth.

You may import all types of WooCommerce knowledge, together with location, coupons used, the standing of the order, time of the order, and way more.

Set up and Activate the Uncanny Automator Plugin for WordPress

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

The very best WordPress automation plugin is Uncanny Automator. It acts as a connector between your WordPress web site and different apps, to allow them to speak to one another with out you writing any code.

It’s like Zapier for WordPress web sites with out the excessive prices of Zapier.

Uncanny Automator could be very simple to make use of and comes with all types of automated workflows which you could arrange in a few clicks (no coding wanted).

Word: there’s a free model of the plugin out there, however we’ll use the Professional model for this tutorial because it has the Google Sheets integration we’d like.

For extra particulars, see our information on methods to create automated workflows in WordPress with Uncanny Automator.

Join Your Google Account with Uncanny Automator

Upon activation, you’ll want to join Uncanny Automator to your Google account.

First, navigate to Automator » Settings and click on on the ‘Google’ menu merchandise.

Subsequent, click on on the ‘Join an account’ button. This takes you to a display the place you possibly can authorize your Google account.

Then, choose the Google account you need to join and click on the ‘Permit’ button.

After that, you’ll want to click on ‘Permit’ yet one more time to authorize your account and ensure your selections.

It will take you again to the Google settings web page in your WordPress admin panel.

That’s all, you’ve efficiently linked your WordPress web site to Google Sheets utilizing Uncanny Automator.

Join WooCommerce to Google Sheets with Uncanny Automator

Now, you’re prepared to attach your on-line retailer to the Google Sheets spreadsheet you created earlier.

Uncanny Automator makes use of “recipes” to create automations and hyperlink apps and plugins collectively.

The very first thing you’ll want to do is navigate to Automator » Add new, click on the ‘Nameless’ possibility, then click on ‘Verify’.

Nameless recipes could be triggered by any person, whereas logged-in recipes can solely be triggered by logged in customers.

You must select the kind of recipe primarily based in your wants after which click on the ‘Verify’ button.

For the sake of this tutorial, we’ll be creating an nameless recipe that robotically sends WooCommerce order knowledge to Google Sheets the second an order is accomplished.

After that, you’ll want to give your recipe a reputation. This received’t be seen to your customers, however it’s going to enable you to establish the completely different recipes you create.

There are two completely different components to every recipe, the set off, and the motion.

The set off is the occasion that may begin the recipe, and the motion is the duty that may run when the motion is triggered.

First, you’ll want to choose ‘WooCommerce’ within the ‘Nameless set off’ meta field.

Then, you possibly can select the set off.

We’ll choose the primary possibility from the drop-down menu since this allows you to ship WooCommerce knowledge as soon as an order is full.

After that, you’ll want to select the set off situation.

Choose the ‘completes’ possibility from the drop-down menu to set off the automation when a buyer completes a purchase order after which click on ‘Save’.

Now, you possibly can select a particular product or any product out of your WooCommerce retailer to run the set off on.

To decide on any product in your retailer, choose the ‘Any product’ possibility after which click on ‘Save’.

Now, you possibly can transfer onto the Actions part. You’ll see completely different choices relying on when you selected an nameless or logged-in recipe.

In case you selected an Nameless recipe above, then you’ll want to create a brand new subscriber person in WordPress first. This new person can be used to ship the shape knowledge by.

For extra particulars, see our information on methods to add new customers and authors to your WordPress weblog.

Now, choose the ‘Current person’ possibility within the ‘Actions’ meta field.

This brings up a popup to decide on the brand new subscriber person position you simply created and enter the person ID.

In case you don’t know the person ID, then yow will discover this by going to Customers » All Customers and enhancing the person profile.

Then, within the URL yow will discover the person ID.

After that, choose ‘Subscriber’, enter the ID, and choose ‘Do nothing’ for current customers.

Then, click on the ‘Save’ button to proceed.

Subsequent, click on the ‘Add motion’ button.

Then, choose ‘Google Sheets’ from the record of integrations.

When you’ve accomplished that, select the ‘Create a row in a Google Sheet’ possibility situated within the ‘Choose an motion’ field.

It will carry up a drop-down menu the place you possibly can choose the spreadsheet you created earlier.

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

Subsequent, you’ll want to click on the ‘Get columns’ button.

It will import the rows out of your spreadsheet.

You must map your spreadsheet columns to the WooCommerce order knowledge by clicking the ‘Asterisk’ icon and choosing the WooCommerce area from the drop-down record.

After you’ve matched up your whole fields, it’s going to look much like the settings beneath.

You may select WooCommerce transport data, nonetheless we determined to make use of the WooCommerce billing data because the contact data could be extra correct.

Ensure you click on ‘Save’ when you’re accomplished creating your recipe.

Now, you possibly can view the total automation abstract to verify it appears to be like proper. After that, it’s time to make your recipe reside.

On the high of the recipe editor, within the’ Recipe’ field, swap the Draft toggle to ‘Stay’.

Your new recipe will now be lively, and also you’ll robotically ship new WooCommerce order knowledge to Google Sheets as soon as a purchase order is full.

Be certain to check your automation to see that the recipe is triggered and the right motion is carried out.

If you wish to add much more automations to your WooCommerce retailer, then see our information on methods to ship Twilio SMS notifications from WooCommerce.

We hope this text helped you learn to join Google Sheets with WooCommerce. You might also need to see our knowledgeable picks of the finest WooCommerce plugins on your retailer and our final WooCommerce search engine optimization information to get extra site visitors.

In case you appreciated this text, then please subscribe to our YouTube Channel for WordPress video tutorials. You may also discover us on Twitter and Fb.

The publish Methods to Join Google Sheets with WooCommerce (in 5 minutes) appeared first on WPBeginner.

    About Marketing Solution Australia

    We are a digital marketing company with a focus on helping our customers achieve great results across several key areas.

    Request a free quote

    We offer professional SEO services that help websites increase their organic search score drastically in order to compete for the highest rankings even when it comes to highly competitive keywords.

    Subscribe to our newsletter!

    More from our blog

    See all posts

    Leave a Comment