df2gspread

What it is and what it does

df2gspread is a Python bridge for moving table data between Google Spreadsheets and DataFrames. It provides two main functions: upload() to write a DataFrame to a Google Sheet, and download() to read a Sheet into a DataFrame. The package handles Google Drive authentication via OAuth 2.0 and abstracts away the complexity of the Google Sheets API.

The package is designed for workflows where data lives in Google Drive and needs periodic sync with Python analysis pipelines. It requires manual credential setup—downloading an OAuth JSON file from Google Cloud Console and authorizing the application once—before it can read or write. No runtime dependencies are declared in the package metadata.

Use it for:

• Export analysis results directly to a shared Google Sheet for team review.
• Automate periodic data pulls from Google Sheets into a Python pipeline for further processing.
• Sync tabular data stored in Google Drive with local DataFrames for offline analysis.
• Replace manual copy-paste of spreadsheet data by programmatically uploading cleaned data.
• Build a data collection tool that reads responses from a Google Form stored as a Sheet.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Transfers tabular data between Google Spreadsheets and DataFrames, enabling bidirectional sync of spreadsheet data for analysis and processing.

Yes, if you need to sync data with Google Sheets and can tolerate the OAuth setup overhead and dormant maintenance status. No, if you require active maintenance, Python 3 certainty, or a more modern Google Sheets integration. The GPLv3 copyleft license is a hard blocker for proprietary code.

Install

df2gspread on PyPI

pip install df2gspread

uv add df2gspread

poetry add df2gspread

Installing df2gspread

Before you install

High install friction due to requiring manual Google OAuth credential setup and authentication flow before the package can function. Last release was in 2019; the repository remains active but development is dormant.

License in practice

GPLv3 copyleft license means any code that imports and uses df2gspread must also be distributed under GPLv3 or a compatible license—a significant constraint for proprietary or differently-licensed projects.

Quickstart

pip install df2gspread

from df2gspread import df2gspread as d2g
d2g.upload(df, '/path/to/spreadsheet', 'Sheet1')

Requires Google OAuth 2.0 credentials file (~/.gdrive_private) and initial browser-based authorization before any upload or download can succeed.

Verify before relying

• Whether a DataFrame library is a runtime dependency (not listed but used in all documented examples).
• Current compatibility with modern Google Sheets API versions and authentication flows.
• Python 3 support status (classifiers list only Python 2.7; latest release is 2019).

Package facts

Evidence: df2gspread-1.0.4.tar.gz

Keywords: information

Tags

More Utilities packages