Unclear how to use multiple private sheet connections

[emilrueh]

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.

Is there a way to use more than one sheet and or sheet tab with the same creds? If so could that be documented more clearly?

Thank you kindly for any help!

[janduplessis883]

I have a simular question:

I want to use the secure connection, but want to specify my spreadsheet variable from within my streamlit app.
i.e. let the user define the google sheet url for a text_input field.

As far as I am aware streamlit does not let you write to secrets.toml

Your help is much appreciated.

[Connorgentle]

Hi there, likewise to janduplessis883 I am trying to use GSheetsConnection in a manner where users can provide the url for a particular google sheet, and then my app can connect to it (assuming they already shared the google sheet with the client_email).

Do you have any suggestions for how to implement this?

Thank you.