How to integrate WooCommerce with Google Sheets to automatically add orders to Google Sheets when an order is placed in WooCommerce

You can set it up in the following 4 steps.

1. Register WooCommerce and Google Sheets in My Apps
2. Open the template
3. Set triggers and actions
4. Verify the automation between WooCommerce and Google Sheets

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

[What is Yoom]

Step 1: Register WooCommerce and Google Sheets in My Apps

Please register WooCommerce and Google Sheets in My Apps to connect them to Yoom.
By registering in My Apps first, you can smoothly set up automation.

Let's register WooCommerce in My Apps first.
Click "My Apps" → "New Connection" on the left side of the Yoom screen.
Find WooCommerce from the list of apps or search for Google Sheets using "Search by app name".

The following screen will be displayed, so please set the "Account Name" and "Access Token" while referring to the explanation.

Next, let's register Google Sheets in My Apps.
Select Google Sheets in the same way as before.
When the following screen is displayed, please log in to Google Sheets.

Step 2: Open the Template

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

Please check the screen display below and click "OK".

The following screen will be displayed, so please check the "Title" and "Description".
If you want to make changes, you can do so by clicking on the relevant section.
To start with WooCommerce settings, click "When an order is created".

Step 3: Set Triggers and Actions

The following screen will be displayed, so let's check the settings.

• "Title" → Can be changed freely
• "Account information to integrate with WooCommerce" → Check if the account is correct
• "Trigger Action" → When an order is created
  

The following screen will be displayed, so please set the "TOP page URL".
Once the setup is complete, click "Test" → "Test Successful" → "Save".

Next, to set up Google Sheets, please click "Add Record".
The following screen will be displayed, so let's check the settings.

• "Title" → Can be changed freely
• "Account information to integrate with Google Sheets" → Check if the account is correct
• "Execution Action" → Add Record
  

Please set the order information in Google Sheets for testing.
The settings are as follows.

Return to Yoom and set up "Database Integration".

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

Scroll and set the "Values of the records to be added".
Use WooCommerce output for the setup.
You can check the output by clicking the arrow in the red frame.
Set the output corresponding to the item name in the Google Sheets set for testing.
Once the setup is complete, click "Test" → "Test Successful" → "Save".

Step 4: Verify the Automation of WooCommerce and Google Sheets

Once you click "Turn on Trigger", the automation setup is complete.
Please check if the flowbot is working correctly.

Other Examples of Automation Using WooCommerce and Google Sheets

1. This is a flow where product information registered in kintone is automatically added to WooCommerce.
As product information is automatically reflected in WooCommerce immediately after registration, you can quickly check the data.
You can centrally manage product information, and only need to check one app, saving the hassle of moving between tools.

2. This is a flow to add orders to Notion when they occur in WooCommerce.
This flow, which we introduced this time, has Notion as the registration destination.
By integrating with Notion, which is also convenient for task management, you can manage WooCommerce order information.

3. This is a flow where AI extracts information from the contents of Google Docs notes and automatically creates documents in Google Sheets.
Based on the notes taken in Google Docs during meetings, documents can be automatically issued in Google Sheets, reducing the effort required for document creation.
Automation of document issuance can shorten the time needed to create documents.

Summary

Integrating WooCommerce with Google Sheets may make order management easier and lead to more transparent data management.
This automation could be effective for companies that handle a large amount of order data.
As a result, staff may be able to dedicate their free time to operating the e-commerce site.
Use this article as a reference to streamline your order data management.

For app integration and automation without the need for coding, Yoom is recommended.
If you want to try Yoom, please register for free here.