Build your first automation in under 5 minutes. Sign up for free.

Connect WooCommerce with Google Sheets

Build automations that connect WooCommerce with Google Sheets. When something happens in WooCommerce, Nodest passes the data along and runs the actions you set up in Google Sheets or the other way around — no coding required.

Automations

Popular WooCommerce and Google Sheets workflows

Pick a ready-made workflow that connects WooCommerce with Google Sheets, customise it to fit your needs, and go live in minutes.

WooCommerceGoogle Sheets

Create rows in Google Sheets for new customers in WooCommerce

When “Customer created” fires in WooCommerce, Nodest will create a row in Google Sheets.

WooCommerceGoogle Sheets

Create rows in Google Sheets for completed payments in WooCommerce

When “Payment complete” fires in WooCommerce, Nodest will create a row in Google Sheets.

WooCommerceGoogle Sheets

Create rows in Google Sheets for order status changes in WooCommerce

When “Order status changed” fires in WooCommerce, Nodest will create a row in Google Sheets.

WooCommerceGoogle Sheets

Update rows in Google Sheets for order status changes in WooCommerce

When “Order status changed” fires in WooCommerce, Nodest will update a row in Google Sheets.

WooCommerceGoogle Sheets

Create rows in Google Sheets for new orders in WooCommerce

When “Order placed” fires in WooCommerce, Nodest will create a row in Google Sheets.

Triggers and actions

Available triggers and actions for WooCommerce and Google Sheets

Combine the triggers and actions of WooCommerce and Google Sheets to build your automation. Triggers start the automation, and actions are the steps that follow.

Order status changedTrigger

Order status changed

Fires when an order changes status.

Customer createdTrigger

Customer created

Fires when a new customer account is created.

Payment completeTrigger

Payment complete

Fires when payment is completed for an order.

Order placedTrigger

Order placed

Fires when a customer places a new order.

Create a couponAction

Create a coupon

Create a discount coupon in WooCommerce.

Create a customerAction

Create a customer

Create a customer account in WooCommerce.

Create an order noteAction

Create an order note

Add an internal or customer-facing order note.

Create a productAction

Create a product

Create a product in your WooCommerce store.

Refund an orderAction

Refund an order

Refund a WooCommerce order, in full or in part.

Update a productAction

Update a product

Update an existing product in WooCommerce.

Update a customerAction

Update a customer

Update an existing customer in WooCommerce.

Create a product categoryAction

Create a product category

Create a product category in WooCommerce.

Create a product tagAction

Create a product tag

Create a product tag in WooCommerce.

Update product stockAction

Update product stock

Update the stock quantity of a product.

Create an orderAction

Create an order

Create an order in your WooCommerce store.

Update an orderAction

Update an order

Update an existing order in WooCommerce.

Find payment methodsAction

Find payment methods

Payment gateways configured on the store.

Find spreadsheetsAction

Find spreadsheets

List spreadsheets shared with Nodest.

Find columnsAction

Find columns

List the column headers in a sheet.

Find rowsAction

Find rows

List rows in a sheet with column names.

Retrieve a rowAction

Retrieve a row

Get one row from a sheet by number.

Retrieve a spreadsheetAction

Retrieve a spreadsheet

Get a spreadsheet's details and tabs.

Find sheetsAction

Find sheets

List the tabs in a spreadsheet.

Create a rowAction

Create a row

Add a row to the bottom of a sheet.

Update a rowAction

Update a row

Change the values in an existing row.

Clear a rowAction

Clear a row

Clear the values in a row.

Delete a rowAction

Delete a row

Remove a row from a sheet.

Create a spreadsheetAction

Create a spreadsheet

Create a spreadsheet in your Drive.

Add a sheet to a spreadsheetAction

Add a sheet to a spreadsheet

Add a tab to a spreadsheet.

Delete a sheetAction

Delete a sheet

Remove a tab from a spreadsheet.

Copy a sheet to a spreadsheetAction

Copy a sheet to a spreadsheet

Copy a tab into another spreadsheet.

Retrieve a cellAction

Retrieve a cell

Get the value of one cell.

Lookup a rowAction

Lookup a row

Find a row by a value in one column.

How it works

Connect WooCommerce with Google Sheets in three steps

Create automations that move data between WooCommerce and Google Sheets. Nodest handles the work in between, so you can focus on what matters.

Connect WooCommerce and Google Sheets

Link your WooCommerce and Google Sheets accounts to Nodest in a few clicks, so both tools are ready to use in automations.

Pick a trigger

Choose the event that starts your automation, such as a new order, form submission, or updated record in WooCommerce or Google Sheets.

Chain actions and go live

Add one or more actions, and combine them with filters, branches, and delays to create a workflow that fits your needs.

Frequently asked questions about WooCommerce and Google Sheets

Find answers to common questions about connecting WooCommerce with Google Sheets using Nodest.

How do I connect WooCommerce to Nodest?

Click Connect on WooCommerce in your Integrations list and enter your WordPress site URL. Nodest sends you to your own site to approve the connection.

Do I need WooCommerce API keys?

Automation tips and tricks for WordPress professionals

Learn how to take control of your time with automation tips and productivity insights - weekly to your inbox.

Illustration showing how Nodest connects WordPress to the tools you already use every day