Our take
Activeregular commits- 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 commit | 2026-07-30 (2 months ago) |
|---|---|
| Commits, last 90 days | 10 |
| Releases, last 12 months | 0 (latest v6.2.1, 2025-05-14) |
| Contributors | 100+ (top contributor: 30% of commits) |
| Issues closed, last 90 days | 3 (typically closed in 22 days) |
| Pull requests merged, last 90 days | 5 (typically merged in 4 days) |
| Project age | 14 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.
Stars
7,514Forks
981Change 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.