Google Sheets Python Packages

gspread

Google Sheets Python API

43.2M 7K 976

gspread-dataframe

Read/write Google spreadsheets using pandas DataFrames

3.8M 261 24

pygsheets

Google Sheets Python API v4

2.4M 2K 214

xlwings

xlwings is a Python library that makes it easy to call Python from Excel and vice versa. It works with Excel on Windows and macOS as well as with Google Sheets and Excel on the web.

1.1M 3K 535

gspread-pandas

A package to easily open an instance of a Google spreadsheet and interact with worksheets through Pandas DataFrames.

370K 410 55

workspace-mcp

Control Gmail, Google Calendar, Docs, Sheets, Slides, Chat, Forms, Tasks, Search & Drive with AI - Comprehensive Google Workspace / G Suite MCP Server & CLI Tool

201K 3K 847

df2gspread

Manage Google Spreadsheets in Pandas DataFrame with Python

97K 131 34

st-gsheets-connection

Streamlit Connection for Google Sheets.

61K 158 58

pytablereader

A Python library to load structured table data from files/strings/URL with various data format: CSV / Excel / Google-Sheets / HTML / JSON / LDJSON / LTSV / Markdown / SQLite / TSV.

27K 110 13

solar-rs485-monitor

Python RS485 solar inverter monitor with configurable protocol parsing, JSON output, multi-sink logging (SQLite, ThingSpeak, MariaDB, OpenSearch, Google Sheets), and a Streamlit dashboard.

22K 0 0

googleapi

High-level python interface for Google APIs

9K 0 0

gsab

Google Sheets as a Backend - a database-like interface for Google Sheets (Python library + CLI).

5K 0 0

tha-google-runner

A Tabular Helper API library that wraps Google Sheets with a typed, consistent interface built on gspread.

4K 0 0

investorzilla

Use your investments spreadsheet (Excel, Google Sheets) containing assets’ ledger and balance to get powerful insights of your investments health and performance, in multiple currencies, including crypto and market indexes.

2K 7 1

sqlitebiter

A CLI tool to convert CSV / Excel / HTML / JSON / Jupyter Notebook / LDJSON / LTSV / Markdown / SQLite / SSV / TSV / Google-Sheets to a SQLite database file.

2K 876 49

eftoolkit

A Python toolkit for DuckDB, S3, and Google Sheets utilities

2K 0 0

easygoogle

Python library to handle most used google authentications

2K 3 1

crdch-model

CRDC-H model in LinkML, developed by the Center for Cancer Data Harmonization (CCDH)

1K 18 8

autodrive

Simple but robust tool for interacting with the Google Drive and Sheets apis via python.

1K 2 1

lab-student-survey

Python package for lab student survey. A single command fetches the spreadsheet generated from Google Forms and uploads the analysis results to Google Drive. Automatically calculates mean, standard deviation, correlation coefficient, p-value, Cronbach's alpha, and performs cluster analysis.

855 1 0