PasteSheet icon PasteSheet logo mark — a spreadsheet grid with a curly brace on a green rounded square PasteSheet

Use a Google Sheet as your website's CMS

A spreadsheet is the friendliest CMS your non-technical teammates already know. PasteSheet turns any Google Sheet into a live, cached content API, so your site pulls copy, listings, and images straight from cells — and anyone can edit without touching code or a deploy.

Last updated

Key facts

  • A Google Sheet is capped at 10 million cells (or 18,278 columns), which is the real ceiling on using one as a database. source
  • A PasteSheet endpoint returns up to 500 rows on the Free plan and 5,000 on Starter ($9/mo); Pro ($19/mo) removes the row cap entirely.
  • A cached endpoint reads the sheet once per TTL, not once per request — so 10,000 visitors become one upstream read, and Google's quota stops being your problem.
  • PasteSheet's Free plan covers 3 endpoints and 2,000 requests a month, with MCP included — no credit card, no expiry.

Why a Google Sheet makes a great CMS

Most content on a marketing site is really just a table: rows of blog posts, team members, features, or FAQ entries, each with a few fields. A spreadsheet models that perfectly — and your writers, marketers, and clients already know how to use one. There is no admin panel to build, no schema migration to run, and no login to hand out.

PasteSheet sits in front of the sheet and serves it as clean, typed JSON over a fast, cached endpoint. Your front end — Next.js, Astro, plain HTML, or a no-code builder — fetches that JSON and renders the page. Edit a cell, and the change is live after the cache refreshes.

What you can drive from the sheet

One endpoint per tab gives you a content type. Common ones people ship:

Fetch your content as JSON

Point your site at the endpoint and read the rows. Filter, sort, and paginate with URL parameters — no query language to learn:

terminal 
curl "https://pastesheet.com/your-endpoint/Posts?status=published&sort=-date"

{
  "data": [
    {
      "title": "Launching our new pricing",
      "slug": "new-pricing",
      "excerpt": "Simpler tiers, same great API.",
      "date": "2026-07-09",
      "status": "published"
    }
  ]
}

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

Free

For side projects and trying things out.

$0 /mo
Endpoints
3
Requests / mo
2,000
Row cap
500
  • Type-mapped columns
  • Custom cache TTL
  • Private endpoints & keys
Get started

Start free. The Free plan runs 3 live endpoints with a 5-minute cache — enough to power a small site. Paid plans add private endpoints, custom cache TTL, and full-text search when you grow.

Compare plans Start free

Frequently asked questions

Do my editors need a PasteSheet account?

No. Only you, the owner, connect the sheet once. Editors just use Google Sheets as normal — anyone you share the sheet with can update content, and the API reflects their edits after the cache refreshes.

How fresh is the content?

Responses are cached at the edge for speed. The Free plan refreshes every 5 minutes; paid plans let you set a custom TTL from 30 seconds to an hour, so you trade freshness against request volume as you like.

Can readers change my sheet through the API?

No. PasteSheet is read-only by design. The endpoint only serves data — there is no write path — so it is safe to expose publicly or embed in a client-side site.

What about images?

Store an image URL in a cell and return it like any other field; your front end renders it. You can host images anywhere — a CDN, Drive, or your own bucket — and just reference the link.

Sources

Related use cases

Run a Blog with Google Sheets as the CMS

Publish a blog from a Google Sheet — posts, slugs, dates, tags, and body text. Filter to published rows and sort by date over a fast, read-only JSON API.

A No-Code Backend From a Google Sheet

Skip the server. PasteSheet turns a Google Sheet into a live, read-only JSON API your web or mobile app reads from — no database, no backend, no Google setup.

Build a Directory Website From a Sheet

Turn a Google Sheet into a searchable directory. PasteSheet serves your listings as a filterable, read-only JSON API — no database, no admin panel, no code.

Drive a Marketing Site from Google Sheets

Run your marketing site's content blocks from a Google Sheet — hero copy, feature lists, section text. PasteSheet publishes it as a live, read-only JSON API.

Turn your sheet into an API in minutes

Paste a Google Sheet URL and get a live REST API and MCP server — no backend, no code, free to start.

Start free See pricing