---
id: gspread
version: "6.2.1"
license: unclear
license_treatment: permissive
maintenance: active
---

# gspread — Google Spreadsheets Python API

License: permissive · Maintenance: active · Popularity: top 1,000 on PyPI

## Install

pip install gspread
uv add gspread
poetry add gspread

## Description

# Google Spreadsheets Python API v4

![main workflow](https://img.shields.io/github/actions/workflow/status/burnash/gspread/main.yaml?logo=github)
![GitHub licence](https://img.shields.io/pypi/l/gspread?logo=github)
![GitHub downloads](https://img.shields.io/github/downloads-pre/burnash/gspread/latest/total?logo=github)
![documentation](https://img.shields.io/readthedocs/gspread?logo=readthedocs)
![PyPi download](https://img.shields.io/pypi/dm/gspread?logo=pypi)
![PyPi version](https://img.shields.io/pypi/v/gspread?logo=pypi)
![python version](https://img.shields.io/pypi/pyversions/gspread?style=pypi)

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

```sh
pip install gspread
```

Requirements: Python 3.8+.

## Basic Usage

1. [Create credentials in Google API Console](http://gspread.readthedocs.org/en/latest/oauth2.html)

2. 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...

## AI interpretation — verify before relying

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

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.

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