The WooCommerce tables in Sheets
Sheets reads your WooCommerce store as 9 tables. Add one to a spreadsheet as a data source and its columns become names your formulas use.
Sales
OrdersDate, Month, Order number, Status, Counts as sale…Order linesDate, Month, Order number, Status, Counts as sale…RefundsDate, Month, Amount, Reason, Refunded through the payment method…
Catalog
ProductsName, Type, Status, SKU, Categories…Product variationsProduct, Variation, SKU, Category, Price…Product categoriesName, Slug, Parent, Products, ID…
Customers
CustomersName, E-mail, Username, Role, Company…Buyers (from orders)E-mail, Name, Country, Registered, Customer ID…