{"id":21126,"library":"df2gspread","title":"df2gspread","description":"Library to export pandas DataFrames to Google Spreadsheets. Version 1.0.4, last released in 2017. No longer actively maintained.","status":"maintenance","version":"1.0.4","language":"python","source_language":"en","source_url":"https://github.com/maybelinot/df2gspread","tags":["google-sheets","pandas","data-export","spreadsheets","gspread"],"install":[{"cmd":"pip install df2gspread","lang":"bash","label":"pip install"}],"dependencies":[{"reason":"DataFrame input","package":"pandas","optional":false},{"reason":"Google Sheets API interaction","package":"gspread","optional":false},{"reason":"Authentication (deprecated in favor of google-auth)","package":"oauth2client","optional":true}],"imports":[{"note":"Direct import misses the nested module","wrong":"import df2gspread","symbol":"df2gspread","correct":"from df2gspread import df2gspread"},{"note":"upload is not a top-level function","wrong":"from df2gspread import upload","symbol":"upload","correct":"from df2gspread import df2gspread; df2gspread.upload(...)"}],"quickstart":{"code":"import pandas as pd\nfrom df2gspread import df2gspread\n\n# Create a DataFrame\ndf = pd.DataFrame({'col1': [1, 2], 'col2': [3, 4]})\n\n# Upload to Google Sheets (requires credentials)\ndf2gspread.upload(df, '1BxiMVs0XRA5nFMdKv_BdBZTgE3e8eFTe_7fGq6WpJ6E', 'Sheet1', credentials=None)\nprint('Uploaded successfully')","lang":"python","description":"Upload a pandas DataFrame to an existing Google Sheet using spreadsheet key and worksheet name."},"warnings":[{"fix":"Use gspread's service_account() method and pass gspread client's auth as credentials","message":"OAuth2client is deprecated; use google-auth or service account credentials","severity":"deprecated","affected_versions":"all"},{"fix":"Extract key between /d/ and /edit: '1Bxi...'","message":"Spreadsheet key must be extracted from the URL, not the full URL","severity":"gotcha","affected_versions":"all"},{"fix":"Pin gspread to <5.0.0 or migrate to df2gspread fork","message":"Library uses deprecated oauth2client; may break with newer gspread versions","severity":"breaking","affected_versions":">=1.0.4"}],"env_vars":null,"last_verified":"2026-04-27T00:00:00.000Z","next_check":"2026-07-26T00:00:00.000Z","problems":[{"fix":"Use 'from df2gspread import df2gspread' then 'df2gspread.upload'","cause":"Incorrect import: using 'import df2gspread' then 'df2gspread.upload'","error":"AttributeError: module 'df2gspread' has no attribute 'upload'"},{"fix":"Install oauth2client: pip install oauth2client, or switch to google-auth","cause":"oauth2client is no longer installed by default","error":"ImportError: No module named 'oauth2client'"}],"ecosystem":"pypi","meta_description":null,"install_score":null,"install_tag":null,"quickstart_score":null,"quickstart_tag":null}