How to integrate Google Sheets with WooCommerce to update product information in WooCommerce after a row update in Google Sheets

In companies and stores that hold a large number of their own products, there are often scenes where prices are changed with each season. This integration of Google Sheets and WooCommerce will be a powerful means to streamline product information management tasks and speed up operations. In this article, we will introduce the business benefits and methods to achieve automation by utilizing these tools. Recommended for: - Those who manage product information with Google Sheets and sell products on WooCommerce - Those who frequently update product information on WooCommerce manually and seek efficiency - Managers who want to share product data across multiple departments and ensure consistency in management - Those who frequently need to update product data and seek quick update reflections - Beginners in programming who want to try automation flows Benefits and Examples of Integrating Google Sheets and WooCommerce Benefit 1: Maintain Consistency of Information By automatically reflecting the information updated in Google Sheets on WooCommerce, you can maintain consistency of information. Managing Google Sheets as a master list prevents errors and omissions in manual updates across different apps. For example, when reducing the price of a product on sale, you can accurately reflect the price information in bulk, preventing troubles caused by incorrect information. Benefit 2: Reduction of Manual Work By building a basic flow where product information is batch registered in Google Sheets and automatically reflected in WooCommerce, you can eliminate the hassle of manually registering and updating products one by one on WooCommerce. For instance, in scenarios where dozens of products are added each season, this automation can save time. Reducing the workload allows employees to focus on other important tasks. Benefit 3: Facilitation of Information Sharing By utilizing and sharing Google Sheets among marketing, product management, and inventory management teams, everyone can proceed with their work based on the same latest data. For example, if the marketing team updates product price information for a campaign on Google Sheets, it will automatically reflect on WooCommerce, eliminating the need for another team to manually reflect the information. This smoothens inter-departmental collaboration and achieves an efficient workflow. [Yoomとは] Now, let's create a flow bot using the template "Update WooCommerce product information when a row is updated in Google Sheets."

How to Create a Workflow for Integrating Google Sheets and WooCommerce

The process to complete the workflow will proceed as follows.

・Integrate Google Sheets and WooCommerce with My Apps
・Copy the template
・Set triggers in Google Sheets and configure WooCommerce
・Turn on the trigger

‍

Let's start by making a new connection for the apps you want to integrate.

・Integrate Google Sheets and WooCommerce with My Apps

(1) First, connect Google Sheets to My Apps.
After logging into your Yoom account, click "My Apps" on the left panel and search for Google Sheets from "New Connection".

‍

‍

Search and click on the Google Sheets app icon.

‍

‍

‍

(2) Click "Sign in with Google" to move to the account selection screen, and choose the account you want to integrate from the right management account.
After selection, proceed to the sign-in screen and complete the authentication.
The first Google Sheets connection is now complete.

(3) Next, integrate the WooCommerce app.
Just like registering Google Sheets with My Apps, select WooCommerce.

‍

‍

(4) Enter the "Account Name" and "Access Token" for the WooCommerce you want to integrate.
After entering the information, click [Add].

If the settings are done correctly, you will be moved to the My Apps screen of your Yoom account with the two apps added.
Now, the two apps are connected to your Yoom account.

・Copy the Template

After confirming that the new connection of the target app is complete in your Yoom account, click the icon for "Try this template" below.

‍

Click the "OK" button to copy the template.
You will be redirected to the "My Projects" screen of your Yoom account, so please check the template content.

‍

‍

There are two setup flows.

・Google Sheets Trigger Setup

(1) First, set up the Google Sheets app trigger.

‍

‍

From the My Projects section on the left side of your Yoom account screen, click "【Copy】Update WooCommerce product information when a row is updated in Google Sheets".

‍

‍

After clicking, the template content will be displayed as shown in the screen below.

‍

‍

(2) First, click on the trigger "When a row is updated".

‍

‍

(3) Enter the account information to be linked and click [Next].
On the next screen, enter information such as "Trigger Interval" and "Spreadsheet ID".

Select any of the following for "Trigger Interval": 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
※ Note that the trigger interval varies depending on the plan.

‍

(4) For the "Spreadsheet ID" and "Sheet ID" fields, click the input bar to expand the information obtained from the account as "candidates" as shown in the screen below.
Let's also make use of this information.

‍

‍

(5) After entering the information, click [Test] and if there are no issues, click [Save].
In this step, you can obtain information as output as shown below.
The output information can be referenced and utilized in subsequent steps, as noted by "This value can be used in other operations."

‍

‍

・WooCommerce Setup

(1) Finally, click on the second action "Update Product".

‍

‍

(2) Enter the WooCommerce account information to be linked and click [Next].

‍

‍

(3) On the next screen, enter information such as "TOP Page URL" and "Email".
Click the input bar to select the output.
As an example, the following is a reference and setting of the output [Product Name], [Product Type], and [Regular Price] obtained from the previous step.

‍

‍

‍

(4) After entering the information, click [Test] and if there are no issues, click [Save].
This completes the setup.

・Turn on the Trigger

By clicking the red frame part "Turn on the Trigger" on the screen below, the flow bot will start automatically.

‍

‍

Here is the template used this time

Other Automation Examples Using Google Sheets and WooCommerce

There are other examples of automation using Google Sheets and WooCommerce on Yoom, so here are a few introductions.

Add Products to WooCommerce When a Row is Added in Google Sheets

You can maintain the accuracy of shared information by registering and quoting the information added to Google Sheets in WooCommerce.
By saving the effort and time previously required for registration, you can proceed with operations smoothly.
Additionally, creating an environment where you can focus on other tasks leads to increased productivity.

‍Add Order Information to WooCommerce When a Row is Added in Google Sheets

This flow is recommended for those who want to streamline registration tasks and focus more on core business activities.
By using the addition of information to Google Sheets as a trigger, you can also register information in WooCommerce, significantly reducing manual work.
By eliminating the time spent on registration tasks, you can concentrate on high-priority tasks, leading to increased productivity.

Update WooCommerce Customer Information When a Row is Updated in Google Sheets

This flow is recommended for those who want to efficiently progress their work through sheet sharing.
By implementing this automation, you may reduce update tasks and focus on other important tasks.
Additionally, using the referenced information can help prevent human errors.

Summary

By integrating Google Sheets with WooCommerce, it becomes easier to automate update tasks, reducing the burden on personnel and improving the efficiency of information management tasks.
Additionally, by maintaining information consistency and reducing working hours, it is possible to enhance the reliability and speed of operations.
As a result, teams and staff may be able to focus their resources on more strategic tasks.

Please take advantage of Yoom to experience automation through app integration.