gsheets-connection icon indicating copy to clipboard operation
gsheets-connection copied to clipboard

Unclear how to use multiple private sheet connections

Open emilrueh opened this issue 1 year ago • 2 comments

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!

emilrueh avatar Sep 03 '24 20:09 emilrueh

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.

janduplessis883 avatar Nov 08 '24 14:11 janduplessis883

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.

Connorgentle avatar Jan 07 '25 20:01 Connorgentle