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.
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
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.
So, let’s get started.
Step 1: Sign up to Pabbly Connect
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
Further, after login into the account, click on the “Access Now” button of Connect. Start the process of creating a workflow for displaying the WooCommerce product to Google Sheets integration by clicking the “Create Workflow” button. 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. 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. 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. The following step is to copy the webhook URL which is appearing on the dashboard. 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. After login into the WordPress account, go to the “WooCommerce” section then there click on the “Settings” option. Next, when you click on “Settings”, it will open up a tab with a different option. Just click on the “Advanced” 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. 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. 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. Further, add your product as mentioned image, provide a little description of 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. As soon as you click on the “Publish” button, the entry will appear on the “Pabbly Connect” dashboard. Then, click on the “Save” option. To make this WooCommerce Google Sheets integration work, you have to choose the action for your trigger. Moving on, click on the “+” icon then select “Google Sheets” and in the choose method option, select ” Add New Row”. 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. 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. Subsequently, after filling all the details, save the setting and then “Send Test Request” to test the WooCommerce Google Sheets integration. 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. 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. Step 2: Access Pabbly Connect
Step 3: WorkFlow for WooCommerce to Google Sheets Integration
(a) Start with a New Workflow
(b) Name the Workflow
Step 4: Setting Trigger for WooCommerce & Google Sheets Integration
(a) Select Application you Want to Integrate
(b) Copy the Webhook URL
Step 5: Connecting WooCommerce to Pabbly Connect
(a) Go to WooCommerce Settings
(b) Click on Advanced Option
(c) Click on Webhooks Option
(d) Add Webhook
(e) Head Back to Product Section
(f) Add Product
(g) Publish the Product
Step 6: Test the Response in Pabbly Connect Dashboard
Step 7: Setting Action for WooCommerce & Google Sheets Integration
(a) Select Application you Want to Integrate
(b) Click the Connect Button
(c) Map Field Data
(d) Save and Send Test Request
Step 8: Check Response in Google Sheets
Conclusion –
You May Also Like To Read –
