gspread

Google Spreadsheets Python API

gspread Permissive license Active ★ 7,494 v6.2.1 released 2025-05-14

Install

gspread on PyPI

pip

pip install gspread

uv

uv add gspread

poetry

poetry add gspread

Package facts

License	not declared (permissive)
Python support	supports the current Python release (>=3.8)
Install friction	low — pure-Python wheel
Runtime dependencies	2 — google-auth, google-auth-oauthlib
Maintenance	actively maintained — 456 days since the last release
Last repo commit	2026-07-30
First released	2011-12-12
Popularity	one of the top 1,000 most-downloaded packages on PyPI (30-day window, as of 2026-08-13)
Known vulnerabilities	none known (OSV.dev, checked 2026-08-13)

Evidence: gspread-6.2.1-py3-none-any.whl

Keywords: spreadsheets, google-spreadsheets, google-sheets

Development Status :: 5 - Production/StableIntended 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.11Programming Language :: Python :: 3.8Programming Language :: Python :: 3.9Topic :: Office/Business :: Financial :: SpreadsheetTopic :: Software Development :: Libraries :: Python Modules

About gspread

from the package's own PyPI description — quoted content, verbatim

Google Spreadsheets Python API v4

main workflow (image) GitHub licence (image) GitHub downloads (image) documentation (image) PyPi download (image) PyPi version (image) python version (image)

Simple interface for working with Google Sheets.

Features:

Open a spreadsheet by title, key or URL.
Read, write, and format cell ranges.
Sharing and access control.
Batching updates.

Installation

pip install gspread

Requirements: Python 3.8+.

Basic Usage

Create credentials in Google API Console
Start using gspread

```python import gspread

First you need access to the Google API. Based on the route you

chose in Step 1, call either service_account(), oauth() or...

Read as markdown · JSON record · Source repository · Docs

AI interpretation — verify before relying

AI-generated interpretation of the package facts above; every digit, version, license, or vulnerability id it cites is grounded in the facts already shown on this page

gspread provides a Python interface to Google Sheets, enabling you to open, read, write, format, and share spreadsheets programmatically via the Google Sheets API.

Low friction: pure Python wheel with only two runtime dependencies (google-auth and google-auth-oauthlib). Active maintenance with recent commits and 7494 GitHub stars; last release 456 days ago indicates stable, mature project.

MIT license (permissive) means you can use, modify, and distribute gspread freely in commercial and private projects with minimal restrictions.

Usage

pip install gspread

import gspread

gc = gspread.service_account()
wks = gc.open("My Spreadsheet").sheet1
wks.update([[1, 2], [3, 4]], "A1")

Requires Python 3.8+; you must first create and configure Google API credentials (service account or OAuth) before calling gspread methods.

Verdict: gspread is a stable, well-maintained library for Google Sheets automation with permissive licensing and minimal dependencies. It's suitable for production use across Python 3.8–3.11, though setup requires prior Google API credential configuration.

Needs verification

Whether google-auth and google-auth-oauthlib have known vulnerabilities or maintenance concerns not captured in this fact sheet.
Specific performance characteristics or rate-limiting behavior when working with large spreadsheets.

google sheets python apiread write google spreadsheetsautomate google sheetsspreadsheet automation pythongoogle docs sheets clientpython google sheets library