Google Sheets Python Packages

gspread

Google Sheets Python API

gspread-dataframe

Read/write Google spreadsheets using pandas DataFrames

pygsheets

Google Sheets Python API v4

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.

gspread-pandas

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

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

df2gspread

Manage Google Spreadsheets in Pandas DataFrame with Python

st-gsheets-connection

Streamlit Connection for Google Sheets.

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.

googleapi

High-level python interface for Google APIs

eftoolkit

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

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.

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.

easygoogle

Python library to handle most used google authentications

crdch-model

CRDC-H model in LinkML, developed by the Center for Cancer Data Harmonization (CCDH). This Python package contains the dataclasses necessary to build and operate over data objects according to the CRDC-H model.

broad-genepy

A useful module for any CompBio

autodrive

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

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.

fastapi-csv

🏗️ Create APIs from CSV files within seconds, using fastapi

sheetwork

A handy package to load Google Sheets to your database right from the CLI and with easy configuration via YAML files.

gsheet-pandas

Download and upload pandas dataframes to the Google sheets

quakecl

A command line tool that displays the recent earthquakes and aftershocks in Nepal.

alfrd

ALFRD : Automated Logical FRamework for executing scripts Dynamically This program is written for the SMILE project supported by the ERC starting grant.

marian

just a personal project, not ready for consumption