WooCommerce → Google SheetsEvents and actions

Use WooCommerce events to automate Google Sheets

Choose an event from WooCommerce to start an automation, then add or update a row in Google Sheets. The action settings show what information you need to provide.

See plans and pricing See what you can do ↓

Already using Noptin? Learn how to create an automation rule.

WooCommerce

Google Sheets

Noptin is installed on 15,000+ websitesSee what users say

Automations

Ways to connect these tools

These are examples. Available fields depend on the event and the choices on your site or connected account.

Add or update a row in Google Sheets when a WooCommerce order is paid

When a WooCommerce order is paid
Add or update a row in Google Sheets.

Supported triggers and actions

Choose a trigger, then combine actions in the order you need. For a quicker setup, describe what you want to Noptin’s AI and let it build your automation rule.

When this happens (5)

When a WooCommerce order is paid
When a WooCommerce order is refunded
When a customer abandons their cart
When a customer's lifetime value surpasses a certain amount
When a customer has made a certain number of orders

Do this (5)

Change the status of a WooCommerce order
Add or update a custom field on a WooCommerce order
Change the status of a WooCommerce subscription
Add a product line item to a WooCommerce subscription
Remove a product line item from a WooCommerce subscription

View all triggers and actions (46)

Search triggers and actions

When this happens (28)

X days since a customer's last order date
When a subscription's renewal payment completes
When a subscription expires
When a subscription is cancelled
X days before a subscription ends
X days before a subscription renews
X days before a saved card expires
When a product is purchased
When a product is refunded
When a WooCommerce order is created
When a WooCommerce order is processed via checkout
When a WooCommerce order is deleted
When a WooCommerce order is pending payment
When a WooCommerce order is processing
When a WooCommerce order is held
When a WooCommerce order is completed
When a WooCommerce order is cancelled
When a WooCommerce order has failed
When the trial period for a subscription has reached its end date
When a subscription is suspended
When a subscription's renewal payment fails
When a subscription that was cancelled by a customer or store owner has reached the end of the term covered by the last payment
When a subscription has reached its end date
When a subscription is created
When a subscription is activated
When a product is published
When a product is unpublished
When a product is deleted

Do this (8)

Apply a coupon to a WooCommerce subscription
Remove a coupon from a WooCommerce subscription
Add or update a row in Google Sheets.
Add a note to a WooCommerce order
Add or update a custom field on a WooCommerce subscription
Add a note to a WooCommerce subscription
Create or update a product
Delete a product

About this connection

How the two tools fit together

WooCommerce: Send bulk emails to your WooCommerce customers or customers who purchased a specific product.

Google Sheets: Google Sheets is a web-based spreadsheet application that enables you to create, edit and share spreadsheets online. With this integration, you can automatically add and update data in your Google Sheets when certain events occur in WordPress.

What information can you send?

Choose a spreadsheet and worksheet. Noptin shows its column headings so you can decide what goes in each column.

Available details depend on the WooCommerce event or action you choose and any fields configured on your site. Available columns come from the header row of the worksheet selected in the connected Google account.

Before you begin

Have these details ready

For Add or Update Row, you will need:

Connected Google account
Spreadsheet and worksheet
Values for the worksheet columns

Start here

Set up WooCommerce and Google Sheets with Noptin

Install the free Noptin plugin on your WordPress site.
Activate your Noptin license, then install the Noptin add-on for Google Sheets from Noptin → Extensions. How to activate your license.
Install and set up WooCommerce on your WordPress site. Connect Google Sheets in Noptin using the account or server details requested in its settings.

See how to install a premium extension.

How to install the Noptin newsletter plugin

Put it together

Set up the automation in WordPress

Choose an event from WooCommerce to start the automation.
Select the Google account, spreadsheet, and worksheet that should receive the row.
Match the details from the first step to the fields in the second. Run a test, then turn on the rule.

Follow the automation rules guide if you need help creating the rule.

Ready to connect WooCommerce and Google Sheets?

Build the automation in your WordPress dashboard with Noptin.

See plans and pricing