secrets.toml looks like this
[connections.gsheets_weekly_survey]
spreadsheet = “https://docs.google.com/spreadsheets/…”
worksheet = “” # worksheet GID is used when using Public Spreadsheet URL, when usign service_account it will be picked as folder_id
type = “service_account” # leave empty when using Public Spreadsheet URL, when using service_account → type = “service_account”
project_id = “”
private_key_id = “”
private_key = “”
client_email = “”
client_id = “”
auth_uri = “”
token_uri = “”
auth_provider_x509_cert_url = “”
client_x509_cert_url = “”
[connections.gsheets_weekly_checkin]
spreadsheet = “https://docs.google.com/spreadsheets/…”
worksheet = “” # worksheet GID is used when using Public Spreadsheet URL, when usign service_account it will be picked as folder_id
type = “service_account” # leave empty when using Public Spreadsheet URL, when using service_account → type = “service_account”
project_id = “”
private_key_id = “”
private_key = “”
client_email = “”
client_id = “”
auth_uri = “”
token_uri = “”
auth_provider_x509_cert_url = “”
client_x509_cert_url = “”
streamlit_app.py looks like this
Connect to Google Sheets
conn = st.connection(“gsheets_weekly_survey”, type=GSheetsConnection)
df = conn.read(worksheet=“Form Responses 1”)
conn_weekly_checkin = st.connection(“gsheets_weekly_checkin”, type=GSheetsConnection)
df_checkin = conn_weekly_checkin.read(worksheet=“Form Responses 1”)
I get ValueError: Spreadsheet must be specified
[https://discuss.streamlit.io/t/how-to-connect-google-spreadsheet-more-sheets/31444](How to connect google spreadsheet more sheets?)