How to WRITE data to a google sheet

[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!