{"id":21101,"library":"databricks-google-sheets","title":"Databricks Google Sheets Connector","description":"A Python library for reading and writing Google Sheets data from Databricks notebooks. Version 0.8.0 supports Python >=3.6. It wraps the Google Sheets API and provides a simple DataFrame-centric interface. Releases are infrequent; no breaking changes recently announced.","status":"active","version":"0.8.0","language":"python","source_language":"en","source_url":"https://github.com/vbalasu/databricks-google-sheets","tags":["databricks","google-sheets","etl","spark"],"install":[{"cmd":"pip install databricks-google-sheets","lang":"bash","label":"Install from PyPI"}],"dependencies":[{"reason":"Required for authentication with Google Sheets API.","package":"google-auth","optional":false},{"reason":"Underlying library to interact with Google Sheets.","package":"gspread","optional":false},{"reason":"Used to represent data as DataFrames.","package":"pandas","optional":false}],"imports":[{"wrong":"from databricks_google_sheets import GoogleSheetsClient","symbol":"DatabricksGoogleSheets","correct":"from databricks_google_sheets import DatabricksGoogleSheets"}],"quickstart":{"code":"from databricks_google_sheets import GoogleSheetsClient\nimport os\n\n# Set credentials via environment variables or Databricks secrets\nscope = ['https://www.googleapis.com/auth/spreadsheets']\ncreds = GoogleSheetsClient.get_credentials(\n    service_account_key=os.environ.get('GOOGLE_APPLICATION_CREDENTIALS', '')\n)\nclient = GoogleSheetsClient(creds)\n\n# Read a sheet\nurl = 'https://docs.google.com/spreadsheets/d/your-sheet-id/edit'\ndf = client.read_from_url(url, sheet_name='Sheet1')\nprint(df.head())","lang":"python","description":"Initialize client with service account credentials and read a sheet into a DataFrame."},"warnings":[{"fix":"Store the key file in DBFS or use Databricks secrets with dbutils.secrets.get() and write to a temp file.","message":"The library expects a service account key file path, not JSON string. Use absolute path or Databricks secret scope.","severity":"gotcha","affected_versions":"<=0.8.0"},{"fix":"Implement rate limiting or batch updates using gspread directly if needed.","message":"Google Sheets API quotas are low for free tier. Frequent writes may exceed limits.","severity":"gotcha","affected_versions":"all"},{"fix":"Always convert data to pandas DataFrame before calling write_to_sheet.","message":"The method `write_to_sheet` expects a DataFrame; passing a list may cause silent errors.","severity":"deprecated","affected_versions":">=0.5.0"}],"env_vars":null,"search_vec":"'0.8.0':19 '3.6':22 'announc':44 'api':28 'break':41 'centric':35 'chang':42 'connector':4 'data':14 'databrick':1,16,45 'datafram':34 'dataframe-centr':33 'etl':49 'googl':2,12,26,47 'google-sheet':46 'infrequ':39 'interfac':36 'librari':7 'notebook':17 'provid':30 'python':6,21 'read':9 'recent':43 'releas':37 'sheet':3,13,27,48 'simpl':32 'spark':50 'support':20 'version':18 'wrap':24 'write':11","created_at":"2026-04-27T16:58:05.398120+00:00","updated_at":"2026-04-27T16:58:05.398120+00:00","problems":null,"ecosystem":"pypi","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":"0.8.0","cli_name":"","cli_version":null,"type":"library","homepage":null,"github":"https://github.com/vbalasu/databricks-google-sheets","docs":null,"changelog":null,"pypi":"https://pypi.org/project/databricks-google-sheets/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"categories":["gcp","data"],"base_url":null,"auth_type":null,"provenance":{"verified_status":"passing","verified_at":"2026-06-30","last_verified":"2026-06-30","next_check":"2026-07-30","install_tag":null}}