gspread

Some features may not work without JavaScript. Please try enabling it if you encounter problems.

Google Spreadsheets Python API

These details have not been verified by PyPI

Project links

Homepage

Project description

Super simple Google Spreadsheets Python API.

Features

Google Sheets API v4.
Open a spreadsheet by title, key or url.
Read, write, and format cell ranges.
Sharing and access control.
Batching updates.

Example

import gspread

gc = gspread.service_account()

# Open a spreadsheet by title
sh = gc.open("Iris Data")

# Get the first sheet
wk = sh.sheet1

# Update a range of cells using the top left corner address
wk.update('A1', [['Species', 'Sepal length'], ['Iris setosa', 5.1]])

# Format the header
wk.format('A1:B1', {'textFormat': {'bold': True}})

License

MIT

Hashes for gspread-5.4.0.tar.gz
Algorithm	Hash digest
SHA256	`b6172b62fa899e3e4199d2d0ea1008b64305554ba08d3d3a96e9123824fdec48`
MD5	`6346c57a49e9f0b0431bdfc17093e4e8`
BLAKE2b-256	`9b627cce536823e659435e65c3aa9d7998623726e52f6e9b9ac2aedeb3367b66`

Hashes for gspread-5.4.0-py3-none-any.whl
Algorithm	Hash digest
SHA256	`21704b47d007c3b5fd34eddfa4c4a9dcd1ecc1dc615083b9c636127726e66c18`
MD5	`7de2de1ef53e6c27cbc4b5d752ad8dd4`
BLAKE2b-256	`794b3445dbb3a6129020fc3291bd019dcb2ffdb63a00fba1ea7fb0a51d092390`