Run your product catalog from a Google Sheet

Why keep the catalog in a Sheet

Product data is naturally tabular — one row per SKU, a column for each attribute. Your buyers and merchandisers already live in a spreadsheet, sorting by margin and flagging what is out of stock. Building an admin panel just to edit that same table is wasted work, and every price change becoming a deploy is a bottleneck.

PasteSheet sits in front of the Sheet and serves it as clean, typed JSON over a fast, cached endpoint. Your storefront — a Next.js site, a mobile app, or a no-code front end — fetches the catalog and renders it. This is the read and catalog layer, not checkout: it serves the merchandising data your storefront displays, while payments and orders stay in your commerce stack.

What the catalog endpoint gives you

Each tab becomes an endpoint, and URL parameters do the querying — no query language to learn:

• Exact-match filters — ?in_stock=true or ?category=Apparel to slice the catalog.
• Partial matches with contains[name]= and full-text search= for on-site product search (Pro).
• Sort by price or newest with sort=-price, and page large catalogs with page / per_page.
• Image URLs live in a cell and return like any other field — host them on any CDN and reference the link.

Fetch products as JSON

Point your storefront at the endpoint and read the rows. Filter to in-stock items and sort by price in a single request:

curl "https://pastesheet.com/your-endpoint/Products?in_stock=true&sort=-price"

{
  "data": [
    {
      "sku": "TSHIRT-BLK-M",
      "name": "Classic Tee — Black",
      "price": 24.00,
      "in_stock": true,
      "image": "https://cdn.example.com/tees/black.jpg"
    }
  ]
}

Safe to publish, nothing to wire up

Because the endpoint is read-only by design, it is safe to expose publicly or hand to a teammate: consumers can read and query the data but can never change the sheet. And there is no Google Cloud project, OAuth screen, or service account to set up — you paste a share URL and get a live API.

What it costs

Frequently asked questions

Sources

• Files you can store in Google Drive (size limits) — Google

Related use cases