---
id: df2gspread
version: "1.0.4"
license: GPLv3
license_treatment: copyleft
maintenance: dormant
---

# df2gspread — Export tables to Google Spreadsheets.

License: copyleft · Maintenance: dormant · Downloads: 99.4K/mo

## 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 above — 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

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

- License: GPLv3 (copyleft)
- Python support: unspecified
- Install friction: high
- Maintenance: dormant
- Downloads: 99.4K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

google sheets data sync, export dataframe to google spreadsheet, import google sheets data, spreadsheet data transfer, google drive table integration, sheets pandas bridge, google-sheets, data-sync, spreadsheet-integration

[View on SkillFed](https://skillfed.io/packages/df2gspread) · [View on PyPI](https://pypi.org/project/df2gspread/)