How to WRITE data to a google sheet

[roland71]

Update: I found a solution, but this one is overwriting the existing data in the sheet.

        sheet_data = [
            {'Timestamp': current_timestamp, 'User_Input': user_input, 'User_Output': user_output]}
        ]
conn.update(worksheet="My_Sheet", data=sheet_data)

Is there a way to use append here?

---

Hello. Following this tutorial I can read data from a google sheet.
But what is the setting for WRITING data to a sheet?

Connect Streamlit to a private Google Sheet - Streamlit Docs

[dataprofessor]

Hi @roland71

Please see this related forum post for a code snippet to write data to a Google Sheet

Inserting data via streamlit form to Google sheets

This is the code for inserting new data to the sheet import gspread from oauth2client.service_account import ServiceAccountCredentials scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive'] creds = ServiceAccountCredentials.from_json_keyfile_name('testingdb-b6d4d-d0a2646c069a.json', scope) client = gspread.authorize(creds) sh = client.open('TestSheet').worksheet('names') row = [name,adr,age,symptoms,gender,email] sh.append_row(row)

Hope this helps!

[blackary]

Here’s an example app that shows how you can do this through the GSheet connector https://github.com/streamlit/gsheets-connection/blob/main/examples/pages/Service_Account_Example.py