{"library":"gspread","type":"library","category":null,"description":"gspread is a Python API for Google Sheets, providing a simple interface to interact with spreadsheets. It supports Google Sheets API v4 and offers features like opening spreadsheets by title, key or URL, reading, writing, and formatting cell ranges, sharing, access control, and batching updates. It is currently at version 6.2.1 and is actively maintained with frequent minor and patch releases.","language":"python","status":"active","version":"6.2.1","tags":["google-sheets","spreadsheets","automation","api","google-api"],"last_verified":"Tue Jun 09","install":[{"cmd":"pip install gspread","imports":["import gspread","import gspread\ngc = gspread.service_account()","import gspread\ngc = gspread.oauth()","import gspread\ngc = gspread.api_key('YOUR_API_KEY')","from gspread.exceptions import APIError"]}],"homepage":"https://docs.gspread.org","github":"https://github.com/burnash/gspread","docs":"https://gspread.readthedocs.io/en/latest/","changelog":null,"pypi":"https://pypi.org/project/gspread/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"compatibility":{"summary":{"python_range":"3.10–3.9","success_rate":100,"avg_install_s":3.7,"avg_import_s":1.39,"wheel_type":"wheel"},"url":"https://checklist.day/v1/registry/gspread/compatibility"}}