Are you busy finding a way to display WooCommerce products to Google Sheets? If yes, then here in this article we will walk you through the process of WooCommerce and Google Sheets integration.

How to Display WooCommerce Products to Google Sheet

Most of the people are relying on the WooCoomerce plugin for WordPress to sell products online without any trouble. It is one of the best eCommerce plugins. But as you know keeping an eye on every other product in your store is quite difficult. And for the same, we prefer to maintain Google Sheets.

Not to forget, adding every product detail manually like product name,  pricing, stock status and all is a lot of work. So we started looking out for software that can easily integrate WooCommerce with Google Sheets.

Why Choose This Method Of Integration?

In contrast with other integration services-

  • Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer, and more
  • Create “Unlimited Workflows” and smoothly define multiple tasks for each action
  • As compared to other services which offer 750 tasks at $24.99, Pabbly Connect proffers 50000 tasks in the starter plan of $29 itself
  • Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
  • Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE

Sign Up To Pabbly Connect     

To be very honest, compared to this “software hunt”, finding a polar bear in a hailstorm would be easy. But guess what! Not anymore. Here we are suggesting integrating software named Pabbly Connect that can connect unlimited applications in a matter of time.

Pabbly Connects eases the tedious or repetitive actions by creating seamless workflows. With zero coding skills, you can bind unlimited applications in a minute. It lets you transfer data in real-time. Plus the software doesn’t restrict on any features like unlimited workflows, actions, triggers, and much more even in its free plan.

Here, in this article, we will understand how one can display WooCommerce products to Google Sheets using an automation tool i.e Pabbly Connect.

How to Display WooCommerce Products to Google Sheets (step by step)

So, let’s get started.

Step 1: Sign up to Pabbly Connect

Sign Up

Start the process of connecting WooCommerce to Google Sheets by clicking on the “Sign Up Free” icon on the Pabbly Connect dashboard. Next, either manually fill-up all the details or sign up using Gmail credentials.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

Select Connect

Further, after login into the account, click on the “Access Now” button of Connect.

Step 3: WorkFlow for WooCommerce to Google Sheets Integration

(a) Start with a New Workflow

Create New Workflow

Start the process of creating a workflow for displaying the WooCommerce product to Google Sheets integration by clicking the “Create Workflow” button.

(b) Name the Workflow

Name the Workflow

Further, add the name of workflow which in our case is “WooCommerce to Google Sheets”. Nevertheless, you can always name the workflow according to your requirements.

Step 4: Setting Trigger for WooCommerce & Google Sheets Integration

Next, after creating a workflow, you have to choose the integration app to connect your Woocommerce to Google Sheets. Using Pabbly Connect one can bind or connect unlimited apps, click here to avail your access to unlimited workflows.

(a) Select Application you Want to Integrate

Select Woocommerce

The following step is to select “WooCommerce” from the dropdown, then choose the “New Product Created” option to append every product data from the software into Google Sheets.

(b) Copy the Webhook URL

Copy the Webhook URL

The following step is to copy the webhook URL which is appearing on the dashboard.

Step 5: Connecting WooCommerce to Pabbly Connect

To collect product data from WooCommerce, you gotta paste the copied Webhook URL in the software. For that, you have to log in to your WordPress account where you installed your Woocommerce plugin.

(a) Go to WooCommerce Settings

Go to WooCommerce Settings

After login into the WordPress account, go to the “WooCommerce” section then there click on the “Settings” option.

(b) Click on Advanced Option

Click on Advanced Option

Next, when you click on “Settings”, it will open up a tab with a different option. Just click on the “Advanced” option.

(c) Click on Webhooks Option

Click on Webhooks Option

Further, when you click on “Webhooks”, it will open up a tab with a certain option. Just click on the “Add Webhook” option to paste the Webhook URL.

(d) Add Webhook

Add Webhook

Now, assign the name according to your need. Make sure to make status “Active” and in the topic section, select “Product Created”.  Then in the delivery URL, paste your copied URL from Pabbly Connect. After making all changes, click the “Save Webhook” button.

(e) Head Back to Product Section

Head Back to Product Section

Next, to test the WooCommerce integration, we are going to add a new product for your store. For that, you have to click on “Products” then click on the “Add New” option.

(f) Add Product

Add Product 

Further, add your product as mentioned image, provide a little description of the product.

(g) Publish the Product

Publish the Product

After adding pricing and all, hit the “Publish” button. But before hitting the button, make sure to click “Capture Webhook Response” in the Pabbly Connect dashboard.

Step 6: Test the Response in Pabbly Connect Dashboard

Test the Response

As soon as you click on the “Publish” button, the entry will appear on the “Pabbly Connect” dashboard. Then, click on the “Save” option.

Step 7: Setting Action for WooCommerce & Google Sheets Integration

To make this WooCommerce Google Sheets integration work, you have to choose the action for your trigger.

(a) Select Application you Want to Integrate

Select Google Sheets

Moving on, click on the “+” icon then select “Google Sheets” and in the choose method option, select ” Add New Row”.

(b) Click the Connect Button

Connected with Google Sheets

After making all the necessary changes, click on the “Connected with Google Sheets” button. Further, it will open the authorization window, for which you have to log in to your Google account.

(c) Map Field Data

Map Field Data

All the sheets in your account will appear on the dropdown. Simply select the sheet, which in our case is “WooCommerce Products”. Now, all you have to do is add the necessary field from drop-down such as for the product name, select the product name option, and for the product id field select the product number.

(d) Save and Send Test Request

Save and Send Test Request

Subsequently, after filling all the details, save the setting and then “Send Test Request” to test the WooCommerce Google Sheets integration.

Step 8: Check Response in Google Sheets

Check Response in Google Sheet

Lastly, when you check the Google Sheets, the entered product details get auto-populated in a sheet.

Now you know how to add WooCommerce products into Google Sheets. This is a one-time process, after this every time when you add a new product, it will get auto-populated in the sheet.

Conclusion –

Hopefully, now we have cleared all the confusion about the automation process. Here, in this article, we learned how to display WooCommerce products to Google Sheets. All you have to do is follow all the above-mentioned steps and you can easily connect WooCommerce to Google Sheets. With the help of automation, one can easily avoid repetitive work. And in such cases, software like Pabbly Connect is a real savior that lets you connect unlimited premium apps.

So, don’t wait anymore. Go and get your access by signing up for a free account.

You May Also Like To Read –