Connect WooCommerce and Google Sheets

Store owners and the accountants who help them often want orders in a spreadsheet they can sort, filter and share. FlowMattic writes WooCommerce orders, refunds and daily sales into Google Sheets from your own WordPress site, and it can work the other way too, updating stock or creating coupons when your team edits the sheet.

Try FlowMattic free See example workflows

49 triggers 76 actions 7 example workflows 21 ready-made templates Unlimited runs

Try a pairing

When this happens in WooCommerce43 triggers

Do this in Google Sheets19 actions

1. TriggerNew Order Created

2. ActionAdd New Row

When WooCommerce fires New Order Created, FlowMattic runs Add New Row in Google Sheets with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

WooCommerce and Google Sheets workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

Add every new WooCommerce order as a row

Order number, customer, total and payment method land in one row per order, so the bookkeeper or packer works from a sheet instead of the WooCommerce admin.

New Order CreatedAdd New Row

Keep each order's status column current

When an order moves to processing, completed or refunded, look up its row by order number and update the status cell, so the sheet never shows an order as still unpaid.

Order UpdatedLookup Row DataUpdate Row

Ready-made template

Log refunds and cancellations for the books

A Filter lets through only orders that turn cancelled or refunded and writes them to a finance tab, which makes month-end reconciliation a matter of reading one list.

Order UpdatedFilterAdd New Row

View the template

Set stock levels from a stocktake sheet

Warehouse staff type counted quantities into a column. Each change finds the product by SKU and updates its stock in WooCommerce, with no wp-admin login needed.

Update Specific Column ValueGet Product by SKUUpdate Product Stock Quantity

Write yesterday's sales report into a new row each morning

A daily Schedule pulls the WooCommerce sales report and appends totals as one row, building a running sales history you can chart without exporting anything.

ScheduleRetrieve Sales ReportAdd New Row

Ready-made template

Draft product copy with AI and save it for review

When a product is created, an AI Agent step writes a description and SEO title and saves them to a review sheet, so a person approves the copy before it goes on the product page.

New Product CreatedAI AgentAdd New Row

View the template

Create coupon codes from rows in a partner sheet

Marketing adds an affiliate or influencer with a code and discount to the sheet, and the matching WooCommerce coupon is created from that row.

New Spreadsheet RowCreate Coupon

Set up: each new order as a row

When you finish, every order placed in your store is written to a Google Sheet as one row.

Prepare the sheet
Create a spreadsheet with a header row such as Order, Date, Customer, Email, Total and Payment so every column is ready to map.
Connect Google Sheets
In FlowMattic, add a Google Sheets connection under Connects with an account that can edit that spreadsheet. WooCommerce runs on the same site, so it needs no separate account.
Choose New Order Created
Start a workflow with the WooCommerce New Order Created trigger and place a test order so FlowMattic captures real order data.
Map Add New Row
Add a Google Sheets step with Add New Row, pick the spreadsheet and tab, map the order fields to the columns, test it and switch the workflow on.

From WooCommerce	To Google Sheets
Order ID	Order
Date created	Date
Billing first and last name	Customer
Billing email	Email
Order total	Total
Payment method title	Payment

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

New Order Created runs once per order. To track later changes, use Order Updated or one of the Order Status Set to triggers in a second workflow.
An order's products arrive as a list. If you want one row per product, loop over the line items with Iterator before Add New Row.
For sheet-to-store workflows, match products by a SKU column with Get Product by SKU so a renamed product still updates the right item.
Writing to the same sheet you watch can start the workflow again. Watch one tab and write to another when you combine both directions.

WooCommerce

Integration page

Triggers (43)

New Product CreatedWhen a new product is created
Product UpdatedWhen a product is updated
Product DeletedWhen a product is moved to trash
Restore ProductWhen a product is restored from trash
New Order CreatedWhen a new order is created
Order UpdatedWhen an order is updated
Order DeletedWhen an order is moved to trash
Restore OrderWhen an order is restored from trash
New Coupon CreatedWhen a new coupon is created
New Customer CreatedWhen a new customer profile is created
Product Added to CartWhen user adds product in cart
Product Removed from CartWhen a product is removed from cart
Order Status Set to PendingTriggers when an order status is set to pending
Order Status Set to FailedTriggers when an order status is set to failed
Order Status Set to On-holdTriggers when an order status is set to on-hold
Order Status Set to ProcessingTriggers when an order status is set to processing
Order Status Set to CompletedTriggers when an order status is set to completed
Order Status Set to RefundedTriggers when an order status is set to refunded
Order Status Set to CancelledTriggers when an order status is set to cancelled
WooCommerce Subscription CreatedTriggers when a subscription is created after a customer purchases a subscription product or products
WooCommerce Subscription Status UpdatedTriggers immediately after a subscription's status has been changed
Product ViewedTriggers when a product is viewed on frontend
Order Note AddedTriggers when a note is added to an order
Customer Order Count ThresholdTriggers when customer reaches specified completed order count
Customer Total Spend ThresholdTriggers when customer reaches specified spending amount
Product Category PurchasedTriggers when a product from specific category is purchased
Product PurchasedTriggers when a specific product is purchased
Variable Product PurchasedTriggers when a variable product is purchased
Variable Subscription PurchasedTriggers when a variable subscription product is purchased
Order PaidTriggers when an order payment is completed
Product ReviewedTriggers when a product review is submitted
Product RefundedTriggers when a product refund is created
Coupon UpdatedTriggers when a coupon is updated
Coupon DeletedTriggers when a coupon is deleted
Coupon RestoredTriggers when a coupon is restored from trash
Customer UpdatedTriggers when a customer profile is updated
Customer DeletedTriggers when a customer is deleted
Product Goes Out of StockTriggers when a product goes out of stock
Product Back in StockTriggers when a product comes back in stock
Product Low StockTriggers when a product reaches low stock threshold
Product Variation Goes Out of StockTriggers when a product variation goes out of stock
Product Variation Back in StockTriggers when a product variation comes back in stock
New Cart AbandonmentTriggers when a customer abandons their cart without completing checkout

Actions (57)

Create New ProductCreate a new product in WooCommerce
Create Variable ProductCreate a new variable product in WooCommerce
Create Product VariationCreate a new product variation in WooCommerce
Update ProductUpdate existing product in WooCommerce
Create New OrderCreate a new order in WooCommerce
Create CouponCreate a new coupon
Apply CouponApply a coupon to the cart
Add Email(s) to CouponAdd one or more emails to a coupon
Add Product to CartAdd products to the cart
Remove Product from CartRemoves the given product from the cart
Create a CustomerCreate a new customer profile
Get Customer by IDGet a customer's profile by their ID
Get Customer by EmailGet a customer's profile by their email
Get Order by IDGet an order's details by its ID
Get Orders by EmailGet all orders by email
Create AttributeCreate a custom product attribute
Add Attribute TermsAdd terms to the product attribute taxonomy
Add Product AttributesAdd attributes to the existing product
Update Product AttributesUpdate product attributes with new values and remove previous values
Get Product Sales CountGet number of sales for the product by ID
Add Order NoteAdd a note to the order
Get Product by IDGet product details by ID
Get Product by SKUGet product details by SKU
Get Orders of UserList all completed orders of a user by email or ID
Change Order StatusChange the status of an order
Get Customer Total SpentGet total amount spent by a customer
Get Customer Order CountGet total number of orders placed by a customer
Get Customer Last OrderGet the last order placed by a customer
Delete CouponDeletes an existing coupon
Retrieve Sales ReportGet total sales, refunds, net sales, and order count for a selected date range
Retrieve Top Sellers ReportGet list of top selling products with quantity sold
Retrieve Reviews TotalsGet review totals by rating
Retrieve Products TotalsGet product totals by type
Retrieve Customers TotalsGet customer totals report
Retrieve Coupons TotalsGet coupon totals by discount type
Retrieve Orders TotalsGet order totals by status
Retrieve a List of RefundsGet list of refunds for an order
Fetch Coupon DetailsRetrieves coupon details by coupon code or ID
Add/Update Custom FieldsAdds or update custom fields on specific order
Create Product ReviewCreate a new product review
Create Product TagCreate a new product tag
Create Product CategoryCreate a new product category
Delete CustomerDelete a customer account
Delete Product TagDelete a product tag
List All OrdersRetrieve a list of all orders
Retrieve Product by Name/SlugGet product details by product name or slug
Update CouponUpdate an existing coupon
Update CustomerUpdate customer details
Get All CustomersRetrieve a list of all customers
Get All ProductsRetrieve a list of all products
Get Product VariationGet variation details by product and variation ID
List All Order NotesRetrieve all notes for a specific order
Update Product VariationUpdate an existing product variation
Send Abandoned Cart EmailSend a recovery email to customers with abandoned carts
Check Cart StatusCheck if a cart is abandoned, recovered, or active
Update Product PriceManage the regular price or sale price of an existing Product or Variation by SKU or ID
Update Product Stock QuantityManage the stock quantity and stock status of an existing Product or Variation by SKU or ID

Google Sheets

Integration page

Triggers (6)

New Spreadsheet RowTrigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
Update Cell DataTrigger when any cell is updated in the spreadsheet
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

Add New RowAdd a new row with mapped data
Update RowUpdate existing row in specific spreadsheet with mapped data
Delete RowDelete row by ID in specific spreadsheet
Clear Row DataClear data or row by ID in specific spreadsheet
Lookup Row DataSearch for data in specific spreadsheet
Get Cell DataGet data for particular cell in specific spreadsheet
Update Cell DataUpdate data for particular cell in specific spreadsheet
Get Row CountGet total number of rows in specific spreadsheet
Get Row DataGet rows data from the sheet based on specified range
Create Spreadsheet ColumnCreate a new column in specific spreadsheet
Create New SheetCreate a new sheet in specific spreadsheet
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
Copy SheetCopy a sheet to another or within the same spreadsheet
Get RowsRetrieve rows in JSON format for use with Iterator
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Why run this pair with FlowMattic

WooCommerce and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

Order data stays on your server

Customer addresses and totals travel from WooCommerce to Google directly from your WordPress site, not through an outside automation service.

Sale days cost the same

Runs are unlimited, so a holiday sale with thousands of orders needs no bigger plan than a quiet week.

The sheet can drive the store

With Google Sheets triggers and 57 WooCommerce actions, staff can change stock, prices or coupons from a spreadsheet they already know.

Common questions

What does the WooCommerce Google Sheets integration do?

It sends store events such as new orders, status changes, refunds and new products into Google Sheets rows, and it can turn sheet edits back into WooCommerce changes like stock updates or new coupons. Everything is set up on the FlowMattic builder inside WordPress.

Can I export orders that were placed before I set this up?

Yes. Run a workflow with List All Orders, loop over the result with Iterator and write each order with Add New Row. You can run it once or on a Schedule.

Can each product in an order get its own row?

Yes. Put an Iterator on the order's line items after the trigger, then Add New Row inside the loop so each product, quantity and price gets a row.

Can I update prices from the sheet?

Yes. Use Update Specific Column Value on the price column, find the product with Get Product by SKU and change it with Update Product Price.

Can I report on subscriptions as well as orders?

Yes, if you sell subscriptions. WooCommerce Subscription Created and WooCommerce Subscription Status Updated can each write a row, so renewals, pauses and cancellations sit in their own tab next to the orders.

Did not find your answer? You can browse the help center or ask us directly.

Start automating WooCommerce and Google Sheets

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

Try FlowMattic free See pricing

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 23 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. WooCommerce integration 2.2.2, Google Sheets integration 2.2.4.