Streamlit_gsheets library

Community Cloud
1

I want to call the data from google sheets with streamlit_gsheets library, but I think it doesn’t support that library. Is there anything else to use for calling data from google sheets?

<requirements.txt>

streamlit==1.26.0
pandas
plotly==5.16.1
sqlalchemy==1.4.39
pymysql==1.1.0
streamlit_gsheets
```

──────────────────────────────────────── pip ───────────────────────────────────────────
Collecting streamlit==1.26.0
Downloading streamlit-1.26.0-py2.py3-none-any.whl (8.1 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 8.1/8.1 MB 96.4 MB/s eta 0:00:00[2023-09-05 08:57:33.593952]
Collecting pandas
Downloading pandas-2.1.0-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (12.7 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 12.7/12.7 MB 164.4 MB/s eta 0:00:00[2023-09-05 08:57:34.133780]
Collecting plotly==5.16.1
Downloading plotly-5.16.1-py2.py3-none-any.whl (15.6 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 15.6/15.6 MB 237.6 MB/s eta 0:00:00[2023-09-05 08:57:34.341758]
Collecting sqlalchemy==1.4.39
Downloading SQLAlchemy-1.4.39-cp39-cp39-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl (1.6 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.6/1.6 MB 143.5 MB/s eta 0:00:00[2023-09-05 08:57:35.370344]
Collecting pymysql==1.1.0
Downloading PyMySQL-1.1.0-py3-none-any.whl (44 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 44.8/44.8 KB 109.6 MB/s eta 0:00:00[2023-09-05 08:57:35.439989]
ERROR: Could not find a version that satisfies the requirement streamlit_gsheets (from versions: none)
ERROR: No matching distribution found for streamlit_gsheets
WARNING: You are using pip version 22.0.3; however, version 23.2.1 is available.
You should consider upgrading via the ‘/home/adminuser/venv/bin/python -m pip install --upgrade pip’ command.
Checking if Streamlit is installed
────────────────────────────────────────────────────────────────────────────────────────
[08:57:36] :exclamation: installer returned a non-zero exit code
[08:57:36] :exclamation: Error during processing dependencies! Please fix the error and push an update, or try restarting the app.
[08:59:10] :exclamation: Streamlit server consistently failed status checks
[08:59:10] :exclamation: Please fix the errors, push an update to the git repo, or reboot the app.

2

This library does not exist. What are you referring to?

3

If it’s GitHub - streamlit/gsheets-connection

You need to refer the full Github link in your requirements.txt: git+https://github.com/streamlit/gsheets-connection

Hope this helps

4

You can use the gspread library with OAuth2 to access Google Sheets

5

I got the library from the youtube ‘funcoding’ but I solve the problem with using secrets.toml from the streamlit documentation! Thnx:)

6

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.