gsheets

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

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

gsheets on PyPI

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

Evidence: gsheets-0.6.1-py3-none-any.whl

Keywords: spreadhseets, google, api, v4, wrapper, csv, pandas

Tags

More WWW/HTTP packages