How to Automatically Update WooCommerce When Order Information is Updated in Google Sheets

When you receive a lot of emails every day, it can be quite a hassle to save files to Dropbox each time.
Moreover, many people might have experienced the struggle of missing a file save or saving a file in the wrong folder, making it difficult to find later.

In this article, we will introduce a method to automatically save files received in Gmail to Dropbox!

By using no-code tools, you can easily set up automation between Gmail and Dropbox.
You can start using it right away, so be sure to give it a try!

Recommended for

Those who want to automatically upload files attached to Gmail to Dropbox
Those who want to integrate Gmail and Dropbox to facilitate smooth file sharing within the team
Those who want to prevent the loss of attachments and ensure proper document storage

For those who want to try it immediately

In this article, we will introduce the integration method using the no-code tool "Yoom".

No complicated settings or operations are required, and even non-engineers can easily achieve it.

You can start right away using the template below, so please give it a try!

Would you like to automate the management of order information by integrating Google Sheets with WooCommerce?
This time, we will introduce a method to automatically reflect updates made to order information in Google Sheets in WooCommerce as well.
This will save you the trouble of double entry and help prevent update errors.
It will be particularly useful for e-commerce site operators in managing order information.

Recommended for

E-commerce personnel who want to avoid the hassle of double entry and update errors
Those who want to smoothly handle customer inquiries
Those who want to centralize order data updates and simplify operations
Those who use Google Sheets and WooCommerce and want to integrate the apps to improve operational efficiency

Benefits and Examples of Integrating Google Sheets and WooCommerce

Benefit 1: Centralized Order Information Updates

By integrating Google Sheets and WooCommerce, you can centralize order information updates.
For example, if you update a customer's address or email address in Google Sheets, it will automatically reflect in WooCommerce.
This way, even if a customer changes their email address or moves, you only need to enter the update in Google Sheets, saving you from double entry.
Additionally, since the update time is shortened, you can simplify important data management.

Benefit 2: Eliminate Manual Updates and Reduce Burden

Manual data updates are prone to human error and take a lot of time to correct.
However, by automating order data updates, the data updated in Google Sheets will be reflected in WooCommerce, allowing for accurate data updates.
This way, you can reduce the hassle of checking and correcting updates, thereby reducing the burden on the person in charge.
By introducing such automation, the person in charge may be able to focus more on operating the e-commerce site and handling customer interactions.

Benefit 3: Eliminate Errors and Respond Smoothly

By automatically updating order information, you can respond smoothly to customer inquiries.
For example, even if a customer changes their email address, it will be reflected from Google Sheets to WooCommerce, preventing situations where you contact the wrong email address.
By incorporating this automation, you may be able to eliminate errors during manual updates and achieve smooth responses.
This will be particularly effective for customer teams that handle many inquiries on a daily basis.

We will introduce the automation method using Yoom by integrating Google Sheets with WooCommerce.

[What is Yoom]

How to Create a Google Sheets and WooCommerce Integration Flow

This time, we will introduce how to set up the following template: "When a row is updated in Google Sheets, update the order information in WooCommerce."
By using this template, you don't need to set up automation from scratch, which is convenient.

The integration flow is broadly created through the following processes.

Register Google Sheets and WooCommerce as My Apps
Copy the template
Set the trigger for Google Sheets, which serves as the starting point of the flow, and configure the subsequent WooCommerce operations
Turn on the trigger button and verify the integration between Google Sheets and WooCommerce

If you are not using Yoom, please register for free here.
If you are already using Yoom, please log in.

Step 1: Register Google Sheets and WooCommerce as My Apps

Please register Google Sheets and WooCommerce as My Apps to connect them to Yoom.
Pre-registering as My Apps makes automation settings easier.

Let's register Google Sheets as My App.
Click "My Apps" → "New Connection" on the left side of the Yoom screen.

A list of apps will be displayed, so search for Google Sheets or use the search bar.

When the following screen is displayed, click the red frame to log in to Google Sheets.

Next, register WooCommerce as My App.
Search for WooCommerce or find it from the app list as you did before.

When the following screen is displayed, check the WooCommerce admin panel to set the "Account Name" and "Access Token".

Once both My Apps registrations are complete, Google Sheets and WooCommerce will be displayed in My Apps.

Step 2: Copy the Template

To set up automation, click "Try it" on the banner below.

Check the screen display below and click "OK".

When the following screen is displayed, check the "Title" and "Description".
If changes are necessary, click on the relevant section and make the changes.
Since it is done from the Google Sheets settings, click "When a row is updated".

Step 3: Setting the Google Sheets trigger that initiates the flow and the subsequent WooCommerce operation settings

The following screen will be displayed, so please check the settings.

"Title" → Can be changed as desired
"Account information linked with Google Sheets" → Check for any mistakes in the account
"Trigger Action" → When a row is updated

Move to Google Sheets and enter order information for testing.
It is set as follows for example, but you can set the item content as you like.

Return to the Yoom screen and check the following settings method.

Scroll and make the following settings.

"Trigger Interval" → Choose from 5 minutes, 10 minutes, 15 minutes, 30 minutes, 60 minutes
* Note that the trigger interval varies depending on the plan.
"Spreadsheet ID", "Sheet ID" → Select from candidates or check the description and enter
"Table Range (Start)" → In this case, A
"Table Range (End)" → In this case, V
* Specify the alphabet of the column where the items end.
"Column with Unique Values" → Specify a column where values do not duplicate within the column
* Be sure to set a column with unique values.
If values are duplicated, it may not work correctly, so be careful.
In this case, the H column of the company name column was specified.
"Column to Detect Updates" → Specify the column name to detect updates
* In this case, since the setting is to detect when the email address is updated, specify the O column.
Which column to specify is set arbitrarily.

After setting, click "Test" → "Test Successful" → "Save".

Next, since we will set up WooCommerce, click "Update Order".
When the following screen is displayed, check the settings.

"Title" → Can be changed as desired
"Account information linked with WooCommerce" → Check for any mistakes in the account
"Action" → Update Order

When the following screen is displayed, set the "TOP Page URL".

Scroll and set the "Order ID".
Use the output from Google Sheets to set it.
The content set in Google Sheets will be displayed as output.
Click the arrow in the red frame to select the output.

This time, since we are setting to update the email address, select the email address from the Google Sheets output.
If there are items you want to update, set them as follows.
After setting, click "Test" → "Test Successful" → "Save".

Step 4: Turn on the trigger button and check the integration operation between Google Sheets and WooCommerce

Finally, click "Turn on Trigger" to complete the automation settings.
Check if the flow bot starts correctly.

Here is the template used this time.

Other Examples of Automation Using Google Sheets and WooCommerce

1. This flow automatically adds order information to WooCommerce when a row is added in Google Sheets.
In addition to updating order information, you can also add new entries.
This reduces the hassle as there is no need to manually register order information.

2. This is a flow where product information in WooCommerce is automatically updated when a row is updated in Google Sheets.
Since product information can be automatically updated, you can obtain the latest information regardless of which data you check.
This eliminates manual work and prevents update errors or omissions.

3. This is a flow where customer information is automatically added to WooCommerce when a row is added in Google Sheets.
It allows centralized management of customer information, reducing the need to switch between tools.
Registration errors are minimized, enabling accurate data entry.

Summary

Managing order information is essential for running an e-commerce site.
This time, we shared a method to automate order information updates by integrating Google Sheets with WooCommerce.
This will free you from manual updates and reduce the risk of human error.
Additionally, centralizing order information updates may lead to time savings and make data management easier.

Why not try improving your daily operations with Yoom?