burnash

gspread: Read and Write Google Sheets from Python

gspread is a Python library for reading, updating, formatting, and sharing Google Sheets through the Google Sheets API. It suits scripts and applications that need spreadsheet access, though its README says new maintainers are needed.

ActivePythonMITLibraryAPIAutomation
View on GitHub Compare
Stars
7.5k
Forks
981
Stars, last 30 days
+3
Last commit
2 months ago
Contributors
100+

Our take

Activeregular commits

Health score

49/100

How it is scored
Activity
34
Community
88
Issues
42
Pull requests
32

+3 stars in the last 30 days

  • More contributors than 78% of the projects we track
  • Slower to merge pull requests than 86% of the projects we track

gspread is a practical, actively developed Sheets client, but the lack of a recent release and the maintainers’ request for help are worth weighing before adopting it for critical workflows.

Good fit if

  • Your Python project needs to read or update Google Sheets, and the Google API authentication model suits your deployment.
  • You are comfortable using a library with recent commit activity and contributions from many people, while checking for a release that meets your needs.
  • You want an MIT-licensed library for spreadsheet automation.

Look elsewhere if

  • Your workflow requires a recent published release, since there has been no release in over a year.
  • You need maintainers to explicitly commit to ongoing support, given the README’s request for new maintainers.
  • Your application needs a local spreadsheet engine rather than access to Google Sheets through its API.
All health signals
Last commit2026-07-30 (2 months ago)
Commits, last 90 days10
Releases, last 12 months0 (latest v6.2.1, 2025-05-14)
Contributors100+ (top contributor: 30% of commits)
Issues closed, last 90 days3 (typically closed in 22 days)
Pull requests merged, last 90 days5 (typically merged in 4 days)
Project age14 years

Checked on 2026-10-11 with the GitHub API.

Project history

Daily GitHub snapshots since Oct 7, 2026. History covers stars and forks; health signals are not tracked historically.

Selected snapshot

Stars

7,514

Forks

981

Change since Nov 16, 2026: 0 stars·0 forks

Overview

gspread provides a Python interface to Google Sheets, so scripts and applications can work with spreadsheets without constructing API requests directly. It supports opening sheets by title, key, or URL, then accessing worksheets and cell ranges.

It is useful when a spreadsheet is part of a data workflow, a lightweight application, or an automation task. Authentication requires access to the Google API and appropriate spreadsheet permissions.

Key Features

  • Open spreadsheets by title, key, or URL.
  • Read cell values and ranges, with options for formatted values, formulas, and rectangular results.
  • Update individual cells, ranges, or multiple ranges in a batch.
  • Create, select, and delete worksheets.
  • Format cell ranges and add data validation rules.
  • Create spreadsheets and manage sharing permissions.

Use Cases

  • A Python script can retrieve spreadsheet rows for a scheduled data-processing task.
  • An operations team can automate updates to shared tracking sheets without editing cells by hand.
  • A small application can save user-submitted records into a spreadsheet when a database is unnecessary.
  • A reporting workflow can read formulas or displayed values and write refreshed results to selected ranges.

What you need

Detected in the repository

  • Python >=3.8 (from pyproject.toml)
  • A test suite and automated checks on GitHub Actions

License in plain words

MITpermissive

  • Commercial use: yes
  • Modify and redistribute: yes
  • You must keep: the copyright and license notice
  • Share your changes: no

A summary, not legal advice: the LICENSE file is what applies.

Getting Started

Install from PyPI:

pip install gspread

See the README and documentation for authentication and usage details.

Considerations

The library requires Python 3.8 or later and Google API credentials with access to the target spreadsheets. The repository is not archived and has recent commit activity, but it has had no release in over a year; its README also says the project currently needs new maintainers. The project is MIT-licensed.

Found this useful?

Share it with someone who would like gspread.