Google Sheets + WooCommerce

Add WooCommerce orders to Google Sheets rows

When this happens
Step 1: Order
Then do this
Step 2: Create Spreadsheet Row

Tired of wasting time copying order info into a spreadsheet? Use this Zapier integration to automatically direct new orders into a Google Sheets spreadsheet that pulls orders from WooCommerce into one smooth flow. You'll never have to search for order information again.

How It Works

Your WooCommerce store receives an order
Zapier adds the order to your Google Sheets spreadsheet

What You Need

Self-hosted WordPress website
WooCommerce plugin installed
Google Sheets account

Try this template

Supported triggers and actions

What does this mean?

Booking
Triggers when any Booking is created, updated, deleted, etc. WooCommerce Bookings must be installed and enabled.
Trigger
Instant
Coupon
Triggers when any Coupon is created, updated, deleted, etc. Coupon functionality must be enabled.
Trigger
Instant
Customer
Triggers when any Customer is created, updated, deleted, etc in your WooCommerce Store.
Trigger
Instant
Order
Triggers when any Order is created, updated, deleted, etc in your WooCommerce Store.
Trigger
Instant
Line Item in an Order
Triggers when any Order event occurs. Creates a separate task for each line item in an Order.
Trigger
Instant

Product
Triggers when any Product is created, updated, deleted, etc in your WooCommerce Store.
Trigger
Instant
Subscription
Triggers when any Subscription is created, updated, deleted, etc. WooCommerce Subscriptions must be installed and enabled.
Trigger
Instant

Create Coupon
Creates a new coupon.
Action
Write

WooCommerce
Updates an existing coupon.
Scheduled
Action
WooCommerce
Creates a new customer.
Scheduled
Action
WooCommerce
Updates an existing customer.
Scheduled
Action
WooCommerce
Creates a new order.
Scheduled
Action
WooCommerce
Updates an existing order.
Scheduled
Action
WooCommerce
Creates a new product.
Scheduled
Action
WooCommerce
Updates an existing product.
Scheduled
Action
WooCommerce
Creates a new subscription.
Scheduled
Action
WooCommerce
Updates an existing subscription.
Scheduled
Action
WooCommerce
Finds a coupon by searching.
Scheduled
Action
WooCommerce
Finds a customer by searching.
Scheduled
Action
WooCommerce
Finds a order by searching.
Scheduled
Action
WooCommerce
Finds a product by searching.
Scheduled
Action
WooCommerce
Finds a subscription by searching.
Scheduled
Action
WooCommerce
Finds a coupon by searching.
Scheduled
Action
WooCommerce
Finds a customer by searching.
Scheduled
Action
WooCommerce
Finds a order by searching.
Scheduled
Action
WooCommerce
Finds a product by searching.
Scheduled
Action
WooCommerce
Finds a subscription by searching.
Scheduled
Action
Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new spreadsheet.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new worksheet in a spreadsheet.
Scheduled
Trigger
Google Sheets
Create a new column in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create a new row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
Google Sheets
Create a new worksheet by copying an existing worksheet.
Scheduled
Action
Google Sheets
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
Scheduled
Action
Google Sheets
Create a blank worksheet with a title. Optionally, provide headers.
Scheduled
Action
Google Sheets
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Scheduled
Action
Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Finds many matched rows (10 max.) by a column and value.
Scheduled
Action
Google Sheets
Returns many rows (20 max.) as a single JSON value and flat rows (line items).
Scheduled
Action
Google Sheets
Finds a row by a column and value. Returns the entire row if one is found.
Scheduled
Action
Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action