The code I have provided functions correctly; however, it fails to insert a new record into the Google Sheet. Instead, it replaces the most recent entry with the new user data, updating only the last row rather than adding a new row. For testing purposes, I currently have only one field in the Google Sheet. I kindly request your assistance in resolving this issue, as it updates the last record instead of inserting a new one.
example/st_app_gsheets_using_service_account.py
import pandas as pd
import streamlit as st
from streamlit_gsheets import GSheetsConnection
st.title(“Read Google Sheet as DataFrame”)
conn = st.connection(“gsheets”, type=GSheetsConnection)
#st.write(st.secrets[‘connections’])
df = conn.read(worksheet=“Sheet3”)
st.dataframe(df)
with st.form(key=“muhammad”):
company = st.text_input(label=“stdnamee”)
submit_button = st.form_submit_button(label=“submit the data”)
if submit_button:
vendor_data = pd.DataFrame([{“name”:company}])
update_df = pd.concat([df , vendor_data] , ignore_index=True)
conn.update(worksheet=“Sheet3”, data=update_df)
st.title("ok ok ok ok ")
this is my app name — https://mfatesting.streamlit.app/