Update data from streamlit to Google Sheets

Using Streamlit
,
1

Hello.

I want to update data from streamlit to Google Sheets, but I keep getting stuck. I’ll post the full code as well.

https://github.com/AlphakaST/Test

AttributeError: ‘GSheetsConnection’ object has no attribute ‘insert_df’

I get an error. If I replace it with update, it’s the same.

I have the Google Sheet API and JSON up in secrets.toml, and the tab I want to connect to is ‘Sheet1’. I’ve also shared my Google user account email ID.

+) I’m trying to do this for classroom use in a classroom of 20 people, will it work if I connect with Google Sheets? If not, I’m going to try MySQL (though I’ll have to study up)

2

Do you expect the connection to have a method insert_df? Or a method update? Why?

3

Implemented with GPT-4O, with some modifications. I don’t know much about the code, so I’ve looked at the streamlit docs and Q&A, but I’ve posted this out of frustration. I hope you understand.

4

I would really appreciate it if you could also provide a guide.

5

I don’t think you found those methods in the streamlit docs and Q&A. What are you trying to do that is not covered by the docs?

6

Thanks for the advice. I’ll try again