Automatically Add WooCommerce Orders to Google Sheets

Managing order data across different tools can quickly become time-consuming, especially as your store grows.

Fortunately, automation tools like OttoKit allow you to connect your applications and streamline repetitive tasks without manual effort.

In this guide, we’ll walk through how to connect WooCommerce with Google Sheets and automatically add a new row to a spreadsheet whenever an order is created in WooCommerce.

By setting up this automation, you can keep your order records organized, accessible, and up to date in real time—without copying and pasting data.

Whether you’re a store owner, operations manager, or part of an accounting or fulfillment team, this step-by-step guide will help you simplify order tracking and improve efficiency.

Let’s get started!

Imagine This Scenario

Imagine you run an online store powered by WooCommerce.

Every time a customer places an order, your team needs to record key details—such as order ID, customer name, total amount, and order date—into a Google Sheet for reporting, fulfillment, or accounting purposes.

Manually doing this for every order means:

• Logging into WooCommerce
• Opening the order
• Copying details
• Pasting them into a spreadsheet

Repeating these steps for every order can be tedious, time-consuming, and prone to errors—especially when order volume increases.

Because of this, updates are often delayed, data can be missed, or reports become outdated.

The Solution with OttoKit

With OttoKit, you can create a workflow that automatically adds a new row to Google Sheets whenever a WooCommerce order is created.

This means:

• No manual data entry
• Always-updated order records
• More time for your team to focus on growth and customer experience

Once set up, OttoKit takes care of syncing your order data seamlessly—so you don’t have to.

Let’s walk through how to set this up step by step.

1. Go to the OttoKit Dashboard.
2. Click on Workflow, as shown below-

3. Now, click on the Create Workflow button.

4. From the dropdown, select Create from Scratch.

5. Enter a name for your workflow and click Create.

6. Next, click on the plus (+) button to add a trigger step.

7. In the apps search field, type WooCommerce and select WooCommerce as the trigger app.

8. Choose Order Created as the trigger action.

9. Click on Select Connection, then choose the WordPress site you want to connect from the dropdown and click Continue.

10. Now, click on Fetch Data.

11. OttoKit will automatically fetch recent order data from your WooCommerce store (no test order is required). Once the data is fetched, click Save.

12. Next, click on the plus (+) button, and in the search box, select Google Sheets.

13. Choose Add New Rows as the Google Sheets action.

14. Click on Create New Connection.

15. A popup will appear asking you to select the email address to connect Google Sheets. Choose the appropriate email and continue.

16. Click Continue.

17. Click Continue again.

18. The connection will now be created. Click Continue to proceed.

19. Select the Spreadsheet name from the dropdown.

20. Next, select the Sheet name.

21. This is the Google Sheet where you have already added column headers. These headers will be used for mapping data in the workflow.

22. You will now see all the Google Sheet headers displayed in the action step. Here, you need to map data from the WooCommerce response.

23. In the Name field, type @. Do the same for the other fields. A popup will appear showing dynamic fields from the WooCommerce response.

24. You can search using a keyword and select the appropriate response field to map it to the column.

25. The selected value will be added automatically. Repeat the same process for the remaining fields, then click Continue.

26. Click on Test Action.

27. You will see confirmation that data has been added to your Google Sheet. Once verified, click Save.

28. Check your Google Sheet to confirm that the test data has been added successfully.

29. Finally, click on Publish Workflow located at the top-right corner.

That’s it, your workflow is set up and is now Live.

You can perform a test submission by creating a new WooCommerce order and checking inside the Google Sheet.

Need Help?

If you get stuck, don’t hesitate to reach out to our support team at [email protected]. We will be happy to assist you and ensure that everything works smoothly.