38 posts
Turn on offline mode, make a specific sheet available offline, and see which features stop working without a connection.
Download a Google Sheet as CSV, export any single tab straight from a URL, fix Excel's broken characters, and automate the export on a schedule.
Use SELECT * WHERE in the QUERY function to pull every matching row, with the exact syntax for text, numbers, dates and wildcards - and when FILTER is better.
A practical guide to writing data to Google Sheets from any app, script, or service using a REST API - no Google SDK, no Apps Script, no OAuth setup for callers.
A complete, honest guide to using Google Sheets as a database - what it's actually good for, how to set it up correctly, and when to switch to something else.
Build a fast edge API in Hono that reads Google Sheets rows using the GKit SheetsAPI - global edge delivery, no cold starts.
A practical guide to reading - and writing - Google Sheets data from any app without setting up OAuth, a Google Cloud project, or service account credentials.
Load Google Sheets data in SvelteKit server load functions, cache with built-in fetch, and type it with Zod.
Fetch and display Google Sheets data in a React Native Expo app - no server required.
Read and query Google Sheets rows in a Rails app using the GKit SheetsAPI - Net::HTTP, plain Ruby structs, and Rails.cache.
Read and write Google Sheets data from Python - without gspread, service accounts, or the google-auth library. Just requests.
Read and display Google Sheets data in Nuxt 3 using server routes, useFetch, and Nitro caching.
Use Google Sheets as a live data layer in Laravel - Http facade, Eloquent-style collections, and optional Cache facade caching.
Fetch and serve Google Sheets data from a Go API - typed structs, http.Client, and Gin routes.
Use Google Sheets as your data store in Flask - read, filter, and serve rows without a traditional database.
Fetch, filter, and serve Google Sheets data from a Node.js Express API - no database required.
Use Google Sheets as a lightweight data layer in C# - typed HttpClient, record DTOs, and IMemoryCache for fast responses.
Fetch, filter, and serve Google Sheets data from a Django API - no database required for read-heavy use cases.
How to read, create, update, and delete rows in a Google Sheet using a REST API - with real GET, POST, PUT, and DELETE examples in JavaScript, Python, and curl.
A complete guide to finding duplicate files in Google Drive - why they accumulate, how to detect them accurately, and the fastest way to clean them up.
Fetch, search, and paginate Google Sheets data in Vue 3 - no backend required.
Learn how to use Google Sheets as a lightweight CMS for your Svelte 5 app using GKit SheetsAPI - fetch products, filter by category, and ship without a database.
Fetch and display Google Sheets data in a SolidJS app using SheetsAPI - createResource, server functions, and reactive filtering.
Use SheetsAPI in Remix v2 loaders for server-side reads and actions for writes - full CRUD without a separate backend.
Fetch Google Sheet data in Nuxt server routes and pages - build a full-stack Nuxt app backed by a spreadsheet using SheetsAPI.
Proxy SheetsAPI through Netlify Functions to keep your user key server-side - build a static site with real database reads and writes.
Use SheetsAPI to fetch and display Google Sheets data in an Angular app - HttpClient services, async pipe, reactive search with RxJS, and environment variables.
How to sort rows returned by SheetsAPI using the sort query parameter - ascending, descending, and multi-field sorting patterns.
How to implement pagination when reading Google Sheets data through SheetsAPI - using limit and offset parameters with real code examples.
Step-by-step guide to fetching, filtering, and displaying Google Sheets data in a Next.js app using GKit SheetsAPI - no backend code 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.
Three ways to read Google Sheets data in JavaScript: the official Sheets API, SheetsAPI (simpler), and the CSV export trick.
A step-by-step guide to turning any Google Sheet into a full CRUD REST API using GKit SheetsAPI - no backend, no Apps Script, no plan limits.
A practical guide to integrating SheetsAPI with Remix (React Router v7) - covering loaders, actions, typed responses, caching, and error boundaries.
Learn how to read and write a Google Sheet from a static site using fetch() - no server, no database, no Apps Script. A practical no-backend guide with real GET and POST examples powered by GKit SheetsAPI.
Fetch Google Sheets rows in a React component with GKit SheetsAPI. A useEffect example with loading and error states, the real REST endpoint, JSON shape, and caching tips.
Learn how to paginate, search, sort, and shape Google Sheets data over REST with GKit SheetsAPI query params - limit, offset, search, search_exact, sort, fields, and format - with real URL examples.