burnash/gspread

Health v2 · maintenance only

Adoption not part of the score

7503 stars · 980 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

A Python client library for the Google Sheets API v4, providing a simple interface to open, read, write, format, and share spreadsheets. It supports authentication via service accounts, OAuth, and API keys.

Use cases

• read and write data to google sheets from python
• sync a database or csv export into a spreadsheet
• automate spreadsheet updates in a scheduled script
• share and manage permissions on google sheets programmatically
• append rows to a sheet from a web app backend
• format cell ranges in google sheets via code

When to choose

• you need Python access to Google Sheets with a simple, high-level API
• you want to automate reading, writing, or formatting spreadsheet data
• you need service-account or OAuth authentication for Sheets

When to avoid

• you need a full-featured spreadsheet engine or offline spreadsheet processing
• you work with Excel or other non-Google spreadsheet formats
• you need guaranteed long-term maintenance - the project is currently seeking new maintainers

Facets

library · maturity maintenance

database-driver sdk spreadsheets apis developer-tools python cross-platform google-sheets google-sheets-api-v4 spreadsheets google-api oauth2 automation

Member repositories

For agents

markdown · JSON · MCP: product_card(name="burnash/gspread")