The documentation and previous threads on this topic don’t seem comprehensive. I found this awesome Medium article with a solution that actually works for reading and writing to Google Sheets
One difference is that I included this line to covert the secrets to a Python dict
Convert st.secrets[“gcp_service_account”] to a regular dictionary
gcp_service_account_info = dict(st.secrets[“gcp_service_account”])
Hope this helps!