Shopify locations in a live spreadsheet
Add the Locations table to a sheet as a data source named locations and its 7 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
=list.locations(location) Every location, once. Spills the distinct location values down the column: the row labels for the formula above.
=data.locations.count(id, location, "<>") Rows with a location. Counts the rows whose Location is not empty.
Columns
| Column | In formulas | Type |
|---|---|---|
| ID | id | Text |
| Location | location | Text |
| City | city | Text |
| Region | region | Text |
| Country | country | Text |
| Active | active | Yes / no |
| Fulfills online orders | fulfills_online_orders | Yes / no |
Other inventory tables
Your locations, 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.