Download
gspread is a Python API for Google Sheets. A service account is a special type of Google account intended to represent a non-human user that needs to authenticate and be authorized to access data in Google APIs [sic]. Since it’s a separate account, by default it does not have access to any spreadsheet until you share it with this account. Just like any other Google account. To access spreadsheets via Google Sheets API you need to authenticate and authorize your application. Older versions of gspread have used oauth2client. Google has deprecated it in favor of google-auth. If you’re still using oauth2client credentials, the library will convert these to google-auth for you, but you can change your code to use the new credentials to make sure nothing breaks in the future. If you familiar with the Jupyter Notebook, Google Colaboratory is probably the easiest way to get started using gspread.
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
- Requires Python 2.7+ or Python 3+
Project Samples
