nithinmurali/pygsheets

Health v2 · maintenance only

Flags: no_license

Adoption not part of the score

1545 stars · 213 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

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

library · maturity stable

sdk api-framework http-client apis developer-tools data-science python cross-platform google-sheets google-sheets-api-v4 spreadsheets oauth2 google-drive automation

Member repositories

For agents

markdown · JSON · MCP: product_card(name="nithinmurali/pygsheets")