Shopify collections in a live spreadsheet
Add the Collections table to a sheet as a data source named collections and its 6 columns become names your formulas, pivot tables and charts use. Sheets reads it from your store each time the sheet opens or refreshes.
Formulas on this table
=data.collections.sum(products) Total products. Adds up the Products column over every row of Collections.
=data.collections.sum(products, collection, A2) Products per collection. With a collection in A2, the total for that one. Fill it down next to a list of them.
=list.collections(collection) Every collection, once. Spills the distinct collection values down the column: the row labels for the formula above.
=data.collections.count(id, collection, "<>") Rows with a collection. Counts the rows whose Collection is not empty.
Columns
| Column | In formulas | Type |
|---|---|---|
| ID | id | Text |
| Collection | collection | Text |
| Handle | handle | Text |
| Products | products | Whole number |
| Sort order | sort_order | Text |
| Updated at | updated_at | Date and time |
Other products tables
Your collections, live
Orders, products, customers and inventory become live tables. Sales reports, stock lists and dashboards stay current without exporting a CSV, and AI assistants such as Claude can build them for you through MCP.