7 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.
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.
Jun 24, 2026 · 2 min read
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.
Jun 24, 2026 · 5 min read
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.