{"library":"spreadsheet-db","title":"spreadsheet-db","type":"library","description":"A lightweight Python library that uses Google Sheets as a database. Currently at version 1.3, with no regular release cadence.","language":"python","status":"active","last_verified":"Sat May 09","install":{"commands":["pip install spreadsheet-db"],"cli":null},"imports":["from spreadsheet_db import SpreadsheetDB"],"auth":{"required":false,"env_vars":[]},"links":{"homepage":null,"github":"https://github.com/da-huin/spreadsheet_db","docs":null,"changelog":null,"pypi":"https://pypi.org/project/spreadsheet-db/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null},"quickstart":{"code":"from google.oauth2.service_account import Credentials\nfrom spreadsheet_db import SpreadsheetDB\nimport os\n\ncreds = Credentials.from_service_account_file(\n    os.environ.get('GOOGLE_APPLICATION_CREDENTIALS', 'credentials.json')\n)\ndb = SpreadsheetDB('MySheet', credentials=creds)\ndb.insert({'name': 'Alice', 'age': 30})\nresult = db.select({'name': 'Alice'})\nprint(result)","lang":"python","description":"Initialize with credentials and use insert/select like a database.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}