Registry / gcp / st-gsheets-connection

st-gsheets-connection

library0.1.0pypypi✓ verified 80d ago

A Streamlit Connection for Google Sheets, providing a simple interface to read and write data using the official Streamlit Connections API. Current version is 0.1.0, with moderate release cadence.

gcp database

pip install st-gsheets-connection

github ↗package ↗

INSTALL

IMPORT

SIG · ST-GSHEETS-CONNECT

st-gsheets-connection

gcppythonv0.1.0

Install

19.0s avg

Import

—

Disk

502MB

Pass rate

5/ 10

Env Coverage5 / 10

glibc

3.9–3.13

musl

3.9–3.13

Install & Compatibility

Where this runs

tested against v0.1.0 · pip install

no network on importno background threads

Install × environment matrix

Each cell = how many times install + import succeeded across repeated harness runs. Partial = flaky.
glibc = Debian/Ubuntu slim · musl = Alpine Linux

musl

py 3.10–3.95 runs

build_error

glibc

py 3.10–3.95 runs

installs and imports cleanly · install 19.0s · import 0.000s · 497MB

502MB installed

● package 502MB

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

GSheetsConnection

✓ from streamlit_gsheets import GSheetsConnection

✗ from st_gsheets_connection import GSheetsConnection

gsheets_connection

✓ from streamlit_gsheets import gsheets_connection

✗ from st_gsheets_connection import gsheets_connection

Basic example: creates a connection and reads a worksheet into a Pandas DataFrame.

import streamlit as st from st_gsheets_connection import GSheetsConnection conn = st.connection("gsheets", type=GSheetsConnection) df = conn.read(worksheet="Sheet1") st.dataframe(df)

Debug

Known issues

breakingVersion 0.1.0 includes a breaking change: the connection now requires Streamlit's new `st.connection` API. Old pattern using `GSheetsConnection` directly without `st.connection` no longer works.

fix

Use `conn = st.connection("gsheets", type=GSheetsConnection)` instead of `GSheetsConnection(...)` directly.

affects: <0.1.0

gotchaThe package name on PyPI is `st-gsheets-connection`, but the import module is `st_gsheets_connection`. Hyphen vs underscore mismatch often causes import errors.

fix

Install with `pip install st-gsheets-connection`, then import with `from st_gsheets_connection import GSheetsConnection`.

affects: all

deprecated`gspread` version 6.0 is not compatible with the latest version of `gspread-dataframe`. Ensure you install compatible versions.

fix

Pin gspread to <6.0 or use gspread-dataframe compatible with gspread 6.0.

affects: 0.0.4+

Upgrade

Version history

0.1.0latest on PyPI · released Aug 15, 2024

Audit

Dependencies

streamlitrequiredRequired as the framework for the connection.

gspreadrequiredUnderlying Google Sheets API client.

Agent activity

32 hits · last 30 days

node