gsheets-connection

gsheets-connection copied to clipboard

hello @sanaz-shahraeini [add main.py with compatible modules&codes

sanaz-shahraeini

Is there any particular reason why the package requires pandas below version 2? Streamlit itself works fine with later versions. https://github.com/streamlit/gsheets-connection/blob/6d50cc196602cac909ffc9a47668b525ada7ccf7/setup.py#L13C1-L14C1

miks2021

To avoid the below error, `raise URLError(err) urllib.error.URLError: ` Use the updated code as shown below, `import ssl import streamlit as st from streamlit_gsheets import GSheetsConnection ssl._create_default_https_context = ssl._create_unverified_context #...

testwebsites2023

I was using this for a project and it works well when deploying on Streamlit Community Cloud, but I wanted to deploy on another service to have a custom domain....

LeoArtaza

import problem

5

Getting this issue while trying to import: `from streamlit_gsheets.gsheets_connection import GSheetsConnection # noqa ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\123\AppData\Local\Programs\Python\Python311\Lib\site-packages\streamlit_gsheets\gsheets_connection.py", line 39, in from validators.utils import ValidationFailure ImportError: cannot import name 'ValidationFailure' from 'validators.utils'`...

Sheikh-Hamoodi

ryangary321

ryangary321

updates: - [github.com/astral-sh/ruff-pre-commit: v0.5.6 → v0.11.9](https://github.com/astral-sh/ruff-pre-commit/compare/v0.5.6...v0.11.9) - [github.com/pre-commit/mirrors-mypy: v1.11.1 → v1.15.0](https://github.com/pre-commit/mirrors-mypy/compare/v1.11.1...v1.15.0) - [github.com/pre-commit/pre-commit-hooks: v4.6.0 → v5.0.0](https://github.com/pre-commit/pre-commit-hooks/compare/v4.6.0...v5.0.0)

pre-commit-ci[bot]

import streamlit_gsheets ->. No module named 'streamlit.dataframe_util'

1

Medhatr

Unclear how to use multiple private sheet connections

2

In the toml config file we are supposed to add a single sheet and single tab under [connections.gsheets] followed by auth and creds that could be used accross multiple sheets....

emilrueh