How to store multiple public google sheet keys in app-secrets?

Community Cloud
1

Hi all, i’m still new to python and streamlit.
I’m trying to build a dashboard where the user can change the access to the datasource via a streamlit ‘selectbox’.
All good as long as i just want to switch between different tabs in a google sheet, but in order to access a different google sheet i need to somehow pass the new Google-Sheet-Link to the in app secrets.

How do i do that?

currently it is for one sheet:
public_gsheets_url = “https://docs.google.com/spreadsheets/d/137048TgXXXXXXX”

I’d like to have something like:
public_gsheets_url = “https://docs.google.com/spreadsheets/d/137048TgXXXXXXX”
public_gsheets_url2 = “https://docs.google.com/spreadsheets/d/137048TgXXXXXXY”

Thank you in advance!!

2

That looks fine. What is the problem?

1 Like
3

(post deleted by author)

4

Uuhhm - resolved without changing anything - don’t know what happened… thank you and sorry haha

5

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