pygsheets
Google Spreadsheets Python API v4
Decision gist · record as of 2026-08-14
Yes, if you need to automate Google Sheets workflows and are comfortable with aging maintenance. The library is stable and has no known vulnerabilities, low install friction, and a permissive MIT license. However, be aware that updates are infrequent (last release 2022); if Google's API changes significantly or you need cutting-edge features, you may need to fork or seek an actively maintained alternative.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires OAuth2 credentials from Google Developers Console (client_secret.json) for Google Sheets API and Drive API access.
- Installation is straightforward with low friction; the package depends on google-api-python-client and google-auth-oauthlib.
- Maintenance is aging—the latest release was in 2022 and the last commit was 2025-06-10, so updates are infrequent but the repository remains active.
License · maintenance · safety
MIT (permissive) — MIT license is permissive, allowing commercial and private use with minimal restrictions—you may use, modify, and distribute pygsheets freely as long as you retain the license notice.
last release 2022-11-30 (1353 days) · last repo commit 2025-06-10 · 1,544 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 2,521,153 downloads/mo, #3,023 on PyPI
Alternatives
Verify before relying
pip install pygsheets
import pygsheets
gc = pygsheets.authorize()
sh = gc.open('my sheet')
wks = sh.sheet1
wks.update_value('A1', 'Hello')- Whether enum34 dependency is still necessary for modern Python versions listed in classifiers (3.5–3.10).
- Current state of pandas integration support and whether it is actively maintained.
What it is and what it does
pygsheets wraps the Google Sheets API v4 in a Pythonic interface, letting you read, write, format, and manage Google Sheets without wrestling with raw API calls. It models spreadsheets as intuitive objects—spreadsheet, worksheet, cell, and data range—so you can open sheets by title or key, update cell values and formatting, create named ranges, apply conditional formatting, and share sheets with others using straightforward method calls.
The library is useful for automation tasks like syncing data between Python and Google Sheets, bulk updates, or building tools that treat Sheets as a lightweight database. It supports batch operations, cell formatting, data validation, and can integrate with pandas DataFrames. However, maintenance is aging; the latest release was in 2022, so expect infrequent updates and potential compatibility gaps with newer Google API changes.
Use it for
- Automate bulk data entry or updates to Google Sheets from Python scripts or data pipelines.
- Share computed results or numpy arrays with collaborators by writing them directly to a shared spreadsheet.
- Build a lightweight data management tool that uses Google Sheets as a backend store.
- Apply formatting, validation rules, and formulas to sheets programmatically at scale.
- Extract sheet data as pandas DataFrames for analysis or export to CSV.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you need to automate Google Sheets workflows and are comfortable with aging maintenance.
The library is stable and has no known vulnerabilities, low install friction, and a permissive MIT license. However, be aware that updates are infrequent (last release 2022); if Google's API changes significantly or you need cutting-edge features, you may need to fork or seek an actively maintained alternative.
Install
pygsheets on PyPI
Before you install
Installation is straightforward with low friction; the package depends on google-api-python-client and google-auth-oauthlib. Maintenance is aging—the latest release was in 2022 and the last commit was 2025-06-10, so updates are infrequent but the repository remains active.
Requires OAuth2 credentials from Google Developers Console (client_secret.json) for Google Sheets API and Drive API access.
License in practice
MIT license is permissive, allowing commercial and private use with minimal restrictions—you may use, modify, and distribute pygsheets freely as long as you retain the license notice.
Quickstart
pip install pygsheets
import pygsheets
gc = pygsheets.authorize()
sh = gc.open('my sheet')
wks = sh.sheet1
wks.update_value('A1', 'Hello')Verify before relying
- Whether enum34 dependency is still necessary for modern Python versions listed in classifiers (3.5–3.10).
- Current state of pandas integration support and whether it is actively maintained.
Package facts
| License | MIT permissive |
| Python support | Supports the current Python release >=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.* |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 3 packagesgoogle-api-python-clientgoogle-auth-oauthlibenum34 |
| Maintenance | Aging 1,353 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 2,521,153 / month, #3,023 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 3 - AlphaIntended Audience :: DevelopersIntended Audience :: End Users/DesktopIntended Audience :: Science/ResearchLicense :: OSI Approved :: MIT LicenseOperating System :: OS IndependentProgramming Language :: PythonProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.5Programming Language :: Python :: 3.6Programming Language :: Python :: 3.7Programming Language :: Python :: 3.8Programming Language :: Python :: 3.9Topic :: Office/Business :: Financial :: SpreadsheetTopic :: Software Development :: Libraries :: Python Modules |
Evidence: pygsheets-2.0.6-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “programmatic spreadsheet access”
- pygsheetspygsheets provides a Python interface to Google Sheets via the Google…
- numbers-parserRead, edit, and write Apple Numbers spreadsheet files (.numbers) from…
- gsheetsgsheets provides a Python wrapper around the Google Sheets API v4 to…
Give your agent the search over MCP, or paste the wish link into any chat.
More Python Modules packages
Converts domain names between Unicode and ASCII-compatible encoding (Punycode) according to IDNA 2008 and Unicode Technical Standard 46, with security validation and broader script coverage than the standard library.
Install it if you work with internationalized domain names, need to validate domains, or use HTTP clients that depend on it transitively.
Setuptools is a Python build backend and package management tool that handles building, distributing, and installing Python packages, including support for C/C++ extension modules.
PyYAML parses and emits YAML 1.1 data format, enabling serialization and deserialization of configuration files and Python objects to and from human-readable YAML text.
Pydantic validates Python data structures against type hints, coercing and checking input at runtime to ensure it matches a declared schema.
Provides reusable metadata objects for use with PEP-593 `typing.Annotated` to express common constraints like bounds, collection sizes, and predicates on types.
Install it if you use or build libraries that need to express type constraints in a standardized, inspectable way—or if you want to annotate your own types with…
Provides runtime tools to inspect and introspect Python type annotations, enabling programmatic examination of type hints at execution time.
See also gspread · smartsheet-python-sdk · gsheets · gspread-pandas · aspose-cells-python · numbers-parser · gspread-formatting · pyxlsx · mcp-google-sheets · gspread-dataframe