---
id: gsheets
version: "0.6.1"
license: MIT
license_treatment: permissive
maintenance: active
---

# gsheets — Pythonic wrapper for the Google Sheets API

License: permissive · Maintenance: active · Downloads: 128.5K/mo

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

gsheets provides a Python wrapper around the Google Sheets API v4 to read spreadsheet data, access cells by coordinate or position, and export worksheets to CSV or pandas DataFrames.

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

pip install gsheets
uv add gsheets
poetry add gsheets

## Installing gsheets

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.

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

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.

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_current
- Install friction: low
- Maintenance: active
- Downloads: 128.5K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

google sheets python api wrapper, read google spreadsheets python, sheets api client library, export google sheets to csv, google sheets to pandas dataframe, spreadsheet data access python, google-sheets, data-export, spreadsheet-automation

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