gsheets
Pythonic wrapper for the Google Sheets API
Decision gist · record as of 2026-08-14
Yes, if you need straightforward programmatic access to Google Sheets and are comfortable with OAuth setup. The low install friction and permissive license make it a reasonable choice. However, note that oauth2client is deprecated and the latest release is from 2022; verify compatibility with your Google account setup and current API versions before relying on it for production workflows.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires OAuth 2.0 client credentials (JSON file) from Google Developers Console and prior enablement of the Sheets and Drive APIs for your Google account.
- Low friction: pure Python wheel with only two runtime dependencies (google-api-python-client and oauth2client).
- Maintenance is active with recent commits, though the latest release was in 2022.
License · maintenance · safety
MIT (permissive) — MIT license is permissive; you can use, modify, and distribute gsheets freely in commercial and private projects without restriction.
last release 2022-06-12 (1524 days) · last repo commit 2026-07-06 · 124 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 128,490 downloads/mo, #11,705 on PyPI
Alternatives
Verify before relying
pip install gsheets
from gsheets import Sheets
sheets = Sheets.from_files('~/client_secrets.json', '~/storage.json')
s = sheets.get('https://docs.google.com/spreadsheets/d/...')
value = s.sheets[0]['A1']- Whether oauth2client (a deprecated library as of 2017) continues to work reliably with current Google authentication flows.
- Current state of compatibility with modern versions of google-api-python-client given the 2022 release date.
What it is and what it does
gsheets is a lightweight Python wrapper around the Google Sheets API v4 that simplifies reading and manipulating Google Spreadsheets from scripts. It abstracts away the low-level API calls, letting you fetch spreadsheets by ID or URL, access individual cells or ranges using spreadsheet coordinates (like 'A1') or zero-based positions, and iterate over worksheets and spreadsheets by title or ID. The package depends on google-api-python-client and oauth2client to handle OAuth authentication and API communication.
Typical workflows include fetching cell values, exporting worksheets to CSV files with custom naming schemes, and converting worksheet data into pandas DataFrames for data analysis. It targets developers and researchers who need programmatic access to Google Sheets without building authentication and API plumbing from scratch.
Use it for
- Fetch data from a shared Google Sheet into a Python script for automated processing or reporting.
- Export multiple worksheets from a spreadsheet to CSV files with names derived from sheet titles.
- Load Google Sheet data directly into a pandas DataFrame for data analysis and manipulation.
- Build a data pipeline that reads from Google Sheets, transforms the data, and writes results elsewhere.
- Iterate over all spreadsheets in a Google Drive account to audit or aggregate data across multiple sheets.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you need straightforward programmatic access to Google Sheets and are comfortable with OAuth setup.
The low install friction and permissive license make it a reasonable choice. However, note that oauth2client is deprecated and the latest release is from 2022; verify compatibility with your Google account setup and current API versions before relying on it for production workflows.
Install
gsheets on PyPI
Before you install
Low friction: pure Python wheel with only two runtime dependencies (google-api-python-client and oauth2client). Maintenance is active with recent commits, though the latest release was in 2022.
Requires OAuth 2.0 client credentials (JSON file) from Google Developers Console and prior enablement of the Sheets and Drive APIs for your Google account.
License in practice
MIT license is permissive; you can use, modify, and distribute gsheets freely in commercial and private projects without restriction.
Quickstart
pip install gsheets
from gsheets import Sheets
sheets = Sheets.from_files('~/client_secrets.json', '~/storage.json')
s = sheets.get('https://docs.google.com/spreadsheets/d/...')
value = s.sheets[0]['A1']Verify before relying
- Whether oauth2client (a deprecated library as of 2017) continues to work reliably with current Google authentication flows.
- Current state of compatibility with modern versions of google-api-python-client given the 2022 release date.
Package facts
| License | MIT permissive |
| Python support | Supports the current Python release >=3.7 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 2 packagesgoogle-api-python-clientoauth2client |
| Maintenance | Actively maintained 1,524 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 128,490 / month, #11,705 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 4 - BetaIntended Audience :: DevelopersIntended Audience :: Science/ResearchLicense :: OSI Approved :: MIT LicenseOperating System :: OS IndependentProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.7Programming Language :: Python :: 3.8Programming Language :: Python :: 3.9Topic :: Internet :: WWW/HTTPTopic :: Office/Business :: Financial :: Spreadsheet |
Evidence: gsheets-0.6.1-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 › “google sheets python api wrapper”
- gsheetsgsheets provides a Python wrapper around the Google Sheets API v4 to…
- gspread-pandasBridges Google Sheets and pandas DataFrames, letting you read…
- mcp-google-sheetsAn MCP server that bridges AI clients like Claude Desktop to Google…
Give your agent the search over MCP, or paste the wish link into any chat.
More WWW/HTTP packages
urllib3 is an HTTP client library that provides thread-safe connection pooling, SSL/TLS verification, multipart file uploads, request retries, compression support, and proxy handling for Python applications.
Requests is a Python HTTP library that simplifies sending HTTP/1.1 requests with automatic handling of headers, authentication, cookies, and response parsing.
h11 is a pure-Python HTTP/1.1 protocol implementation that handles parsing and serializing HTTP messages without any built-in I/O, letting you integrate it with any network layer you choose.
HTTPX is a fully featured HTTP client library for Python that provides both sync and async APIs, with support for HTTP/1.1 and HTTP/2, plus an integrated command-line client.
Install it if you are building new projects or modernizing existing ones that rely on HTTP.
A minimal low-level HTTP client library that sends HTTP requests with thread-safe and task-safe connection pooling, supporting HTTP/1.1, HTTP/2, proxies, and both sync and async interfaces.
aiohttp is an async HTTP client and server framework built on asyncio, supporting both WebSockets and middleware-based routing for building concurrent web applications.
Install it if you need async HTTP client or server capabilities in asyncio-based applications.
See also gspread-pandas · shillelagh · pygsheets · gspread-dataframe · df2gspread · gspread · xlsx2csv · gspread-asyncio · gspread-formatting · aspose-cells