9 posts
A practical JavaScript guide to reading and writing Google Sheets data - no service account setup, no OAuth flow, no Google SDK. Just fetch().
Fetch, filter, and serve Google Sheets data from a Node.js Express API - no database required.
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, filter, and display Google Sheet data in a Vue 3 app using the Composition API and SheetsAPI - no backend required.
Use Node.js and Express to proxy, transform, and expose Google Sheets data as a REST API - with caching, error handling, and TypeScript types.
SheetsAPI returns proper CORS headers so you can call it from any frontend - React, Vue, vanilla JS - without a proxy or backend.
Step-by-step guide to fetching, filtering, and displaying Google Sheets data in a Next.js app using GKit SheetsAPI - no backend code required.
Three ways to read Google Sheets data in JavaScript: the official Sheets API, SheetsAPI (simpler), and the CSV export trick.