20 posts
Jun 24, 2026 · 3 min read
The Google Sheets API and GKit SheetsAPI both read Google Sheets — but they solve different problems. Here's when to use each.
Jun 24, 2026 · 2 min read
A practical guide to setting up a workflow where content editors update a Google Sheet and the website reflects changes automatically.
For simple use cases — content management, product catalogs, contact directories — Google Sheets + SheetsAPI covers 80% of what Airtable does at zero cost.
How to use React Server Components and Next.js fetch caching to serve Google Sheets data with zero client JavaScript.
Jun 24, 2026 · 5 min read
Google Sheets has no native webhook support. Here are the practical patterns — polling with SheetsAPI, Apps Script triggers, and Google Cloud Pub/Sub — and when to use each.
An honest comparison of Google Sheets and relational databases for storing app data — and the right use cases for each.
How to sort rows returned by SheetsAPI using the sort query parameter — ascending, descending, and multi-field sorting patterns.
How to use SheetsAPI's search, search_exact, and sort parameters to filter your Google Sheets data server-side — without downloading the whole sheet.
A comparison of authentication approaches when serving Google Sheets data via REST: public endpoints, API keys, and OAuth tokens.
How to implement pagination when reading Google Sheets data through SheetsAPI — using limit and offset parameters with real code examples.
Google Sheets has built-in offline mode, conflict resolution, and a change history. Here's why that makes it a solid data store for simple apps.
How to use GKit SheetsAPI as a lightweight data layer for React Native and Flutter apps — no server required.
Collect form submissions into a Google Sheet using SheetsAPI — no third-party form service required.
Use the SheetsAPI format=csv query parameter to get a Google Sheet as a downloadable CSV file — with examples in curl, fetch, and a Next.js download button.
How to create, read, update, and delete rows in Google Sheets using GKit SheetsAPI — with real fetch examples in TypeScript.
How to use Google Sheets as a simple headless CMS for blogs, landing pages, and marketing sites — with SheetsAPI as the content delivery layer.
Understanding Google Sheets API quotas, what the 429 error means, and how GKit SheetsAPI helps you stay within limits without slowing your app down.
Jun 24, 2026 · 4 min read
Three ways to read Google Sheets data in JavaScript: the official Sheets API, SheetsAPI (simpler), and the CSV export trick.
Google Sheets has a 10-million-cell limit. Here's what that means in practice, and when you'll hit it.
Both let you automate and extend Google Sheets — but they solve different problems. Here's how to choose.