Unclear how to use multiple private sheet connections
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!
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.
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.