# theapache64/retrosheet

📃 Turn Google Spreadsheet to JSON endpoint (without any login/auth). Supported Platforms: Android, iOS, JVM and JS. Thanks to Kotlin Multiplatform 🙏🏼

Repository: https://github.com/theapache64/retrosheet
Canonical: https://ross.abutalabs.com/products/retrosheet
Homepage: https://a64.in/retrosheet/wizard
Language: Kotlin
License: Apache-2.0
License Family: permissive
Topics: retrofit, okhttp, interceptors, google-sheets, rest-api
Last push: 2025-12-29T18:29:40+00:00

## Health v2 (maintenance only)
Score: 61/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 59, release rhythm 40, longevity 100
- inputs: {"age_days": 2235, "days_push": 247, "days_rel": 401, "gap_med": 12, "n_releases_24m": 6}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1003, forks 42 (observed 2026-09-03T02:15:18.559582+00:00)

## What it is
A Kotlin Multiplatform library that turns Google Spreadsheets into JSON API endpoints, letting apps read and write data through Google Sheets without any backend or authentication setup. It integrates as an HTTP client plugin (OkHttp/Ktor interceptor) so switching to a real REST API later requires minimal code changes.

## Use cases
- use google sheets as a free backend for my app
- build an MVP without setting up a server
- read and write data to a spreadsheet as JSON from Android
- quickly prototype an app with a spreadsheet database
- submit form data to google sheets from mobile app
- swap spreadsheet backend for a real REST API later

## When to choose
- prototyping an MVP or POC that needs a quick free backend
- you want a real-time editable data interface via Google Sheets
- building Kotlin Multiplatform apps on Android, iOS, JVM, or JS
- you want free analytics via Google Forms submissions

## When to avoid
- production apps needing reliable, scalable, secure backends
- apps requiring authentication, complex queries, or transactions
- high-traffic workloads where Google Sheets rate limits apply
- non-Kotlin projects without JVM/JS runtimes

## Facets
- artifact type: library
- maturity: active
- function: http-client, serialization, sdk
- domain: developer-tools, apis, backend, mobile-development, cross-platform
- platform: jvm, cross-platform
- tags: google-sheets, retrofit, okhttp, ktor, json-endpoint, kotlin-multiplatform, mvp-backend, no-auth, android, ios

## Member repositories
- theapache64/retrosheet (main) score 61

## Provenance
- Observed fields: from GitHub, fetched 2026-09-03T02:15:18.559582+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T07:13:55.726341+00:00, confidence not recorded.
  - readme: https://github.com/theapache64/retrosheet (fetched 2026-09-03T02:15:18.559582+00:00, sha e57e37583881)
  - homepage: https://a64.in/retrosheet/wizard (fetched 2026-08-29T13:13:44.776835+00:00, sha 5ca206f34d2b)
- Data as of 2026-08-30T08:39:29.467469+00:00.