Inserting data via streamlit form to Google sheets

[TomJohn]

Yes, and it was discussed in the abovementioned post. @jcarroll suggested using pandas:

import pandas as pd

@st.cache_data(ttl=600)
def load_data(sheets_url):
    csv_url = sheets_url.replace('/edit#gid=', '/export?format=csv&gid=')
    return pd.read_csv(csv_url)


# ok let's load the data
questions_df = load_data(st.secrets["public_gsheets_url"])