Again "Spreadsheet must be specified"

[NicholasA0712]

Hi Community,

I recently posted my problem here:

GSheets Connection - "Spreadsheet must be specified"

Hi Community, I have encountered some issues with my private expense tracker app (maybe I will further improve the project and set it to public). The app is connected to a private google sheet using streamlit_gsheets (GSheetsConnection). When I run the app locally, everything runs fine with the connection to google sheets and quering the data. Originally the deployment on the streamlit cloud worked as well, but after about one week of usage I ran into this error message: File "/home/adminuse…

The solution seemed to work, but unfortunately only briefly before the problem appeared again. Since nothing in the dependencies or the secrets.toml file has changed I assume it must be connected to the gsheets package.
Since the app still works fine when I run it locally I have absolutely no idea what the exact issue might be.
Every help is appreciated.

Kind regards,
Nicholas

[ferdy]

Could you tell us your requirements.txt?

[NicholasA0712]

Sure

pandas == 1.5.3
plotly == 5.9
datetime
streamlit_option_menu == 0.3.6
st-gsheets-connection == 0.0.3

Already worked for a few days with these requirements.

[jewes]

why no gsheets available database connection? Spreadsheet must be specified error. hard no solve. anyone to help this error? thanks

[JOSE1]

I’ve just discovered what was the problem in my case, since I was receiving the same message only for the deployed app, while locally app worked fine.
I didn’t have set secrets on Settings->Secrets tab. When I pasted secrets.toml content here, It worked.