# nithinmurali/pygsheets

Google Sheets Python API v4

Repository: https://github.com/nithinmurali/pygsheets
Canonical: https://ross.abutalabs.com/products/pygsheets
Homepage: https://pygsheets.readthedocs.io/en/latest
Language: Python
License: NOASSERTION
License Family: other
Topics: google-sheets, google-sheets-api, python, python-lib, google-sheets-api-v4, google-sheets-library, spreadsheet
Last push: 2025-06-10T05:13:49+00:00

## Health v2 (maintenance only)
Score: 34/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 26, release rhythm 8, longevity 100
- inputs: {"age_days": 3740, "days_push": 449, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1545, forks 213 (observed 2026-08-28T04:05:01.481451+00:00)

## What it is
pygsheets is a Python library wrapping the Google Sheets API v4, providing intuitive models for spreadsheets, worksheets, cells, and data ranges. It supports OAuth2 authorization, sharing, formatting, data validation, and batch read/write operations.

## Use cases
- read and write google sheets from python
- export a numpy array or dataframe to a spreadsheet
- automate updating spreadsheet cells and ranges
- create, share, and manage google spreadsheets programmatically
- apply cell formatting, data validation, and conditional formatting via api
- sync data between an app and google sheets

## When to choose
- you want a simple, intuitive python wrapper over the google sheets api
- you need to manipulate cell formats, named ranges, or data validation
- you prefer spreadsheet/worksheet/cell object models over raw REST calls

## When to avoid
- you need a general google drive client beyond spreadsheets
- you work in a non-python stack
- you need real-time streaming updates from sheets

## Facets
- artifact type: library
- maturity: stable
- function: sdk, api-framework, http-client
- domain: apis, developer-tools, data-science
- platform: python, cross-platform
- tags: google-sheets, google-sheets-api-v4, spreadsheets, oauth2, google-drive, automation

## Member repositories
- nithinmurali/pygsheets (main) score 34

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:05:01.481451+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-30T04:30:36.160574+00:00, confidence not recorded.
  - readme: https://github.com/nithinmurali/pygsheets (fetched 2026-08-28T04:05:01.481451+00:00, sha c117af8ce9bc)
  - registry_pypi: https://pypi.org/pypi/pygsheets/json (fetched 2026-08-29T11:32:21.819076+00:00, sha 6e045f95cb48)
- Data as of 2026-08-30T08:39:29.467469+00:00.