Works with Shopify

Live spreadsheets on your store data

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.

Request access See the reports
  • Runs inside your Shopify admin
  • AI assistants via MCP
  • Reads your store; changes nothing
What it is

Sheets

Live spreadsheets, dashboards and scheduled reports on your store data.

Works with Shopify.

Sheets turns your store's orders, products, customers and inventory into live spreadsheets. Spreadsheet formulas, pivot tables and charts read the data directly, so your sales reports, stock lists and dashboards stay current without exporting a CSV.

  • Formulas over your store data: sales by product, by day, by channel.
  • Pivot tables and charts that update with every new order.
  • Low-stock lists and best-seller rankings in a few clicks.
  • Share sheets with your team, export to .xlsx or PDF.
  • Scheduled e-mail reports, sent from your own mailbox.

Sheets reads your store data; it does not change orders, products or customers.

The data

9 tables from your store

Add any of them to a spreadsheet as a data source. Each table's page lists its columns and the formulas that use them.

Sales

Orders 28 columns · data.orders Order lines 15 columns · data.order_lines Draft orders 13 columns · data.draft_orders

Products

Products 16 columns · data.products Product variants 15 columns · data.product_variants Collections 6 columns · data.collections

Customers

Customers 14 columns · data.customers

Inventory

Inventory by location 15 columns · data.inventory_by_location Locations 7 columns · data.locations
Reports

Reports people build first

One formula each. Put it in a cell, fill it down a column, or turn the table into a pivot and a chart.

=data.orders.sum(net_total, channel, A2)
Net sales. Order totals after refunds, for the whole store or per channel in column A.
=data.orders.sum(net_total, ship_to_country, A2)
Sales by country. Net sales per shipping country.
=data.orders.avg(total)
Average order value. Average order total; add a date filter to compare months.
=data.order_lines.sum(quantity, product, A2)
Units sold per product. Quantity per product from the order lines. List the products with =list.order_lines(product).
=data.order_lines.sum(net_amount, vendor, A2)
Revenue per vendor. Net line amounts per vendor.
=data.inventory_by_location.count(variant_id, available, "<5")
Low stock. Variant locations with fewer than five units available.

All 9 reports

How it works

From connection to a live report

  1. ConnectInstall Sheets in your store; it opens inside the Shopify admin.
  2. Add dataAdd the tables a sheet needs as data sources, each under a short name.
  3. Write formulasUse =data.<name>.sum(…) next to any spreadsheet function, or build pivots and charts.
  4. Share and scheduleShare the sheet with colleagues, export to .xlsx or PDF, or e-mail it on a schedule.
FAQ

Questions

Does Sheets change my store?

No. Sheets reads orders, products, customers and inventory; it does not change them.

Which store data can a sheet use?

9 tables: orders, order lines, draft orders, products, product variants, collections, customers, inventory by location, and locations.

Can an AI assistant build my reports?

Yes. Connect Claude or another MCP client to your store's Sheets: it can read your sheets and store data, write formulas and build dashboards, with the access you grant and can revoke.

Where does Sheets run?

Inside your Shopify admin, as an embedded app. Its data is stored on servers in the European Union.

What happens when I uninstall?

The access token is deleted at once, and all of the store's Sheets data within 48 hours of Shopify's store redaction request.

Live spreadsheets on your store data

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.

Request access