# 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: 2026-07-11 · Source: * ## 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](https://support.google.com/drive/answer/37603)) - 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](https://pastesheet.com/use-cases/google-sheets-nextjs-data), Astro, plain HTML, or a [no-code builder](https://pastesheet.com/use-cases/google-sheets-webflow) — 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: - Blog posts and articles — see the [blog CMS use case](https://pastesheet.com/use-cases/google-sheets-blog-cms). - Landing-page copy, feature grids, and [pricing tables](https://pastesheet.com/use-cases/google-sheets-pricing-table). - [FAQ entries](https://pastesheet.com/use-cases/google-sheets-faq-page), [testimonials](https://pastesheet.com/use-cases/google-sheets-testimonials), and [team bios](https://pastesheet.com/use-cases/google-sheets-team-directory). - Any [directory or listing](https://pastesheet.com/use-cases/google-sheets-directory-website) that changes often. ## 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: ```bash 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 — $0/month.** For side projects and trying things out. - Endpoints: 3 - Requests: 2,000 / month - Rows per endpoint: 500 - Tabs per endpoint: 1 - Rate limit: 60 / minute **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. ## 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 - [Files you can store in Google Drive (size limits)](https://support.google.com/drive/answer/37603) — Google - [Publish a file from Google Docs, Sheets, Slides or Forms](https://support.google.com/docs/answer/183965) — Google Docs Editors Help ## Related use cases - [Run a Blog with Google Sheets as the CMS](https://pastesheet.com/use-cases/google-sheets-blog-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](https://pastesheet.com/use-cases/google-sheets-app-backend) — 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](https://pastesheet.com/use-cases/google-sheets-directory-website) — 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](https://pastesheet.com/use-cases/google-sheets-content-website) — 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. --- [PasteSheet](https://pastesheet.com) turns any Google Sheet into a live REST API and MCP server for AI agents — no backend, no code. Canonical HTML version of this page: