Dashboard
Menu
WooCommerce → Google SheetsEvents and actions

Use WooCommerce events to automate Google Sheets

Choose a WooCommerce event 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.

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

Automation ideas

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

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

Available in Noptin

Google Sheets actions

Rows

1 action

  • Add or update a row in Google Sheets.

Available in Noptin

WooCommerce events and actions

Orders

11 events · 3 actions

View events and actions

Events

  • When a WooCommerce order is created
  • When a WooCommerce order is processed via checkout
  • When a WooCommerce order is paid
  • When a WooCommerce order is refunded
  • 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

Actions

  • Change the status of a WooCommerce order
  • Add or update a custom field on a WooCommerce order
  • Add a note to a WooCommerce order

Carts

1 event

  • When a customer abandons their cart

Customers

3 events

View events
  • When a customer's lifetime value surpasses a certain amount
  • When a customer has made a certain number of orders
  • X days since a customer's last order date

Subscriptions

13 events · 7 actions

View events and actions

Events

  • 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's renewal payment completes
  • 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 expires
  • When a subscription has reached its end date
  • When a subscription is created
  • When a subscription is cancelled
  • When a subscription is activated
  • X days before a subscription ends
  • X days before a subscription renews
  • X days before a saved card expires

Actions

  • Change the status of a WooCommerce subscription
  • Add or update a custom field on a WooCommerce subscription
  • Add a note to a WooCommerce subscription
  • Add a product line item to a WooCommerce subscription
  • Remove a product line item from a WooCommerce subscription
  • Apply a coupon to a WooCommerce subscription
  • Remove a coupon from a WooCommerce subscription

Products

5 events · 2 actions

View events and actions

Events

  • When a product is published
  • When a product is unpublished
  • When a product is deleted
  • When a product is purchased
  • When a product is refunded

Actions

  • 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

  1. Install the free Noptin plugin on your WordPress site.
  2. Activate your Noptin license, then install the Noptin add-on for Google Sheets from Noptin → Extensions. How to activate your license.
  3. 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

  1. Choose a WooCommerce event to start the automation.
  2. Select the Google account, spreadsheet, and worksheet that should receive the row.
  3. 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.

Explore each add-on

See what else you can do

Google Sheets integration details WooCommerce integration details

More ways to connect your tools

Explore related automations

WooCommerce to Mailchimp WooCommerce to ActiveCampaign WooCommerce to Salesforce Gravity Forms to Google Sheets Contact Form 7 to Google Sheets LifterLMS to Google Sheets

Browse all Noptin integrations to find another starting point or destination.

Ready to connect WooCommerce and Google Sheets?

Build the automation in your WordPress dashboard with Noptin.

See plans and pricing