The Shopify tables in Sheets
Sheets reads your store as 9 tables. Add one to a spreadsheet as a data source and its columns become names your formulas use.
Sales
OrdersID, Order, Created at, Processed at, Payment status…Order linesLine ID, Order ID, Order, Order date, Product…Draft ordersID, Draft, Status, Created at, Subtotal…
Products
ProductsID, Product, Handle, Vendor, Type…Product variantsID, Variant, Option, Product ID, Product…CollectionsID, Collection, Handle, Products, Sort order…