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 …

[image] hun2up: streamlit_gsheets library This library does not exist. What are you referring to?

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

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

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

Streamlit_gsheets library

Community Cloud

Franky1 September 5, 2023, 9:10am 2

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

Using Gsheets connection

Topic		Replies	Views
Reading data from google sheets Using Streamlit	5	5635	January 19, 2022
Inserting data via streamlit form to Google sheets Using Streamlit google-sheets , database , gsheetsdb	17	5559	August 9, 2024
Google Sheets connection error Using Streamlit debugging	4	197	April 20, 2025
Solved issue of pulling private google sheet into a streamlit app using gspread instead of gsheetsdb Show the Community! pandas , google-sheets	4	2137	March 22, 2023
Google sheet is connected to python and works BUT streamlit returns this error Using Streamlit	2	372	January 22, 2023

Streamlit_gsheets library

Related topics