---
id: pygsheets
version: "2.0.6"
license: MIT
license_treatment: permissive
maintenance: aging
---

# pygsheets — Google Spreadsheets Python API v4

License: permissive · Maintenance: aging · Downloads: 2.5M/mo

## 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 above — verify before relying.

pygsheets provides a Python interface to Google Sheets via the Google Sheets API v4, letting you open, create, modify, and share spreadsheets programmatically with intuitive cell, worksheet, and spreadsheet objects.

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

pip install pygsheets
uv add pygsheets
poetry add pygsheets

## Installing pygsheets

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.

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')

Requires OAuth2 credentials from Google Developers Console (client_secret.json) for Google Sheets API and Drive API access.

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_current
- Install friction: low
- Maintenance: aging
- Downloads: 2.5M/month (top 5,000 on PyPI)
- Known vulnerabilities: none known

## Tags

google sheets python api, programmatic spreadsheet access, google sheets automation, python google sheets library, spreadsheet cell manipulation, google drive spreadsheet control, batch spreadsheet updates, google-sheets, spreadsheet-automation, api-wrapper

[View on SkillFed](https://skillfed.io/packages/pygsheets) · [View on PyPI](https://pypi.org/project/pygsheets/)