# burnash/gspread

Google Sheets Python API

Repository: https://github.com/burnash/gspread
Canonical: https://ross.abutalabs.com/products/gspread
Homepage: https://docs.gspread.org
Language: Python
License: MIT
License Family: permissive
Topics: gspread, google-sheets, google-sheets-api-v4, google-sheets-api, spreadsheets, spreadsheet
Last push: 2026-07-30T07:35:32+00:00

## Health v2 (maintenance only)
Score: 73/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 95, release rhythm 28, longevity 100
- inputs: {"age_days": 5388, "days_push": 34, "days_rel": 476, "gap_med": 75, "n_releases_24m": 4}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 7503, forks 980 (observed 2026-08-28T04:10:00.357543+00:00)

## What it is
A Python client library for the Google Sheets API v4, providing a simple interface to open, read, write, format, and share spreadsheets. It supports authentication via service accounts, OAuth, and API keys.

## Use cases
- read and write data to google sheets from python
- sync a database or csv export into a spreadsheet
- automate spreadsheet updates in a scheduled script
- share and manage permissions on google sheets programmatically
- append rows to a sheet from a web app backend
- format cell ranges in google sheets via code

## When to choose
- you need Python access to Google Sheets with a simple, high-level API
- you want to automate reading, writing, or formatting spreadsheet data
- you need service-account or OAuth authentication for Sheets

## When to avoid
- you need a full-featured spreadsheet engine or offline spreadsheet processing
- you work with Excel or other non-Google spreadsheet formats
- you need guaranteed long-term maintenance - the project is currently seeking new maintainers

## Facets
- artifact type: library
- maturity: maintenance
- function: database-driver, sdk
- domain: spreadsheets, apis, developer-tools
- platform: python, cross-platform
- tags: google-sheets, google-sheets-api-v4, spreadsheets, google-api, oauth2, automation

## Member repositories
- burnash/gspread (main) score 73

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:10:00.357543+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-29T17:37:31.494226+00:00, confidence not recorded.
  - readme: https://github.com/burnash/gspread (fetched 2026-08-28T04:10:00.357543+00:00, sha 90a689b1f325)
  - registry_pypi: https://pypi.org/pypi/gspread/json (fetched 2026-08-29T08:33:18.867769+00:00, sha 2d19fbcbd044)
- Data as of 2026-08-30T08:39:29.467469+00:00.