{"id":28266,"library":"spreadsheet","title":"Spreadsheet","description":"A Python tool for manipulating Google Spreadsheets. Version 1.2.1 is the latest release. The project appears to be in maintenance mode with no recent updates (last commit in 2019).","status":"active","version":"1.2.1","language":"python","source_language":"en","source_url":"https://github.com/lyda/spreadsheet","tags":["google-spreadsheets","google-data-api","spreadsheet","legacy","gdata"],"install":[{"cmd":"pip install spreadsheet","lang":"bash","label":"Install from PyPI"}],"dependencies":[{"reason":"Required for Google Data API interaction","package":"gdata","optional":false}],"imports":[{"note":"Direct import of module does not provide Spreadsheet class","wrong":"import spreadsheet","symbol":"Spreadsheet","correct":"from spreadsheet import Spreadsheet"},{"note":"","wrong":"","symbol":"Client","correct":"from spreadsheet import Client"}],"quickstart":{"code":"from spreadsheet import Spreadsheet\n# Requires Google account credentials\nsheet = Spreadsheet('username@email.com', 'password')\nws = sheet.worksheet('Sheet1')\nws.update_cell(1, 1, 'Hello World')","lang":"python","description":"Basic usage: authenticate with Google account, access a worksheet, and update a cell. Note: uses older Google Data API (not Sheets API v4)."},"warnings":[{"fix":"Consider migrating to google-api-python-client with google-auth for Sheets API v4.","message":"Depends on gdata library which is no longer maintained and uses the deprecated Google Data API (not Sheets API v4). May stop working as Google sunsets older APIs.","severity":"breaking","affected_versions":"all"},{"fix":"Use a Google App Password if 2FA enabled, or switch to a modern library like gspread or pygsheets.","message":"The library uses username/password authentication (Google's ClientLogin) which is now disabled by Google for many accounts (OAuth 2.0 required). Authentication may fail.","severity":"gotcha","affected_versions":"all"}],"env_vars":null,"last_verified":"2026-05-09T00:00:00.000Z","next_check":"2026-08-07T00:00:00.000Z","problems":[{"fix":"Run 'pip install gdata' before using spreadsheet.","cause":"Missing required library gdata which is not automatically installed.","error":"ImportError: No module named gdata"},{"fix":"Enable 'Less secure app access' or use an App Password if 2FA is enabled, or migrate to OAuth 2.0 based library.","cause":"Google has disabled ClientLogin for many accounts; authentication fails.","error":"gdata.service.BadAuthentication"}],"ecosystem":"pypi","meta_description":null,"install_score":null,"install_tag":null,"quickstart_score":null,"quickstart_tag":null}