WooCommerce and Google Sheets automations
Set up an automation: when new order created in WooCommerce, add new row to sheet in Google Sheets
Build it50agents builds it as an automation, and asks before anything goes outside.
WooCommerce and Google Sheets in practice
Used for
Each new WooCommerce order becomes a row in Google Sheets.
Best template
“New Order Created” in WooCommerce, then “Add New Row to Sheet” in Google Sheets. It gives you one row per order as it is created.
Watch out
Pointing “Delete Rows” at “New Order Created” would wipe orders from the sheet.
WooCommerce and Google Sheets templates
Pick one and Captain builds it with you.

When new order created in WooCommerce, add new row to sheet in Google Sheets
Build this
When new order created in WooCommerce, update spreadsheet row in Google Sheets
Build this
When new order created in WooCommerce, delete rows in Google Sheets
Build this
When new order created in WooCommerce, add multiple rows in Google Sheets
Build this
WooCommerce and Google Sheets triggers and actions
Every one of both apps. A trigger starts the work; actions are the steps.
Triggers
9- New order createdRuns when a new order is created.
- New product createdTriggers when a new product is created.
- New customer createdTriggers when a new customer is created.
- New coupon createdTriggers when a new coupon is created.
- Product updatedTriggers when an existing product is updated.
- Order updatedTriggers when a order is updated.
- Customer updatedTriggers when a customer is updated.
- Coupon updatedTriggers when a coupon is updated.
- Coupon deletedTriggers when a coupon is deleted.
No triggers match.
Actions
17- Create couponCreates a new coupon in your WooCommerce store.
- Create customerCreates a new Customer.
- Create orderCreates a new order.
- Create order noteCreates a new Order Note.
- Create productCreate a new WooCommerce product with name, pricing, images, categories, and stock/settings.
- Update couponUpdates an existing Coupon.
- Update customerUpdates an existing Customer.
- Update productUpdates an existing product in your WooCommerce store.
- Update orderUpdate an existing order.
- Find productsList all or Find products by product id, sku, or other filters.
- Find ordersLists orders and lets you filter by customer email, order ID, or other criteria.
- Delete an orderDelete an existing order.
- Delete a productDeletes an existing product.
- Delete customerDeletes a customer from your store.
- Delete couponDeletes an existing coupon from your store.
- Find customersList all or Finds customers by email, customer ID, or other filters.
- List productsShow available products.
No actions match.
Triggers
1- Row added or updatedRuns when row added or updated
No triggers match.
Actions
23- Update spreadsheet rowUpdate columns in sheet row
- List rows in sheetGet rows from a sheet tab as objects with row numbers. Supports an optional header row, offset/limit paging, and fetching from the last row.
- Delete rowsDelete one or more rows from a specific sheet in a Google Spreadsheet using a row range or row numbers.
- Add new row to sheetRuns as a step in Google Sheets.
- Lookup spreadsheet rowsFind rows in a Google Sheet that match a column value or an advanced filter.
- Copy sheet to spreadsheetCopy a sheet to another file
- Add multiple rowsAdd one or more rows to a specific sheet in a Google Spreadsheet. Provide data column-by-column or paste a JSON array for bulk inserts. If the sheet has no headers, they will be auto-created from your JSON keys.
- Create subsheetAdd a new subsheet to a spreadsheet and optionally set its position and add column headers in the first row.
- Create sheet columnInsert a new column into the specified Google Sheets sheet at the given index (or append to the end) and optionally set its header.
- Get rows from rangeRetrieve rows from sheet range
- Create a spreadsheetCreate a new spreadsheet.
- Find subsheetSearches a sheet in a spreadsheet by name and returns the sheet name, column titles, and number of rows.
- Get row detailsRetrieve values and metadata for a specific row in a spreadsheet sheet.
- Clear spreadsheet rowClears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.
- Create spreadsheet from templateCreate sheet from template
- List spreadsheetsFetch all spreadsheets
- List spreadsheet tabsLists all tabs (sheets) in a spreadsheet and returns the total count.
- Batch update cell valuesUpdate multiple cells at once
- Format spreadsheet rowFormat row font and background
- Add conditional formatting ruleApply conditional formatting to cells in a Google Sheets spreadsheet based on their values
- Update sheet nameRenames an existing sheet (tab) within a Google Spreadsheet to a new name you specify.
- Update multiple rowsUpdate values in one or more rows of a Google Sheet.
- Permanently delete spreadsheetPermanently delete a spreadsheet from Google Drive, including files on shared drives.
No actions match.
Questions about WooCommerce and Google Sheets
What can start a WooCommerce and Google Sheets automation?
“New order created”.
Which other apps work with both WooCommerce and Google Sheets?
HubSpot, Shopify, Stripe, Calendly and Grist. Each one has templates with WooCommerce and with Google Sheets, so a third app can join the same job.
All WooCommerce integrations · All Google Sheets integrations · Every app, A to Z
Connect WooCommerce and Google Sheets
Or pick another template above. Free to start.
Build it with Captain