Example of saving st.feedback submissions to Google sheets

Show the Community!
1

I put together a demo app to show how to use gsheets-connection and st.feedback to collect app feedback into a Google sheet so it’s easy to gather feedback without requiring a database or other backend setup.

The code is at GitHub - ranton256/streamlit_feedback_to_sheets: This is an example of how to save Streamlit feedback from st.feedback to a Google sheet.
The app is at https://feedback2sheets.streamlit.app/

And obviously, leave me some feedback on my feedback app.

Disclaimer: I reserve the right to delete all feedback if it is inappropriate, abusive, or just boring. This is only an example after all.

Thanks,
-Richard

5 Likes
2

Curious, if you’re going to go through the hoops of setting up a service account, etc. why not just use a database? What’s the draw of using Google Sheets?

This is coming from someone that put off learning how to use a database for way too long. It turns out it’s super easy, or at least it is now that gen AI can write queries and migrations for you.

My workflow is now:

  • use SQLAlchemy. SQLite for local db instead of a CSV/JSON, then move to hosted PostgreSQL
  • to view and manage the DB I use DBeaver
  • if you need to make changes you can do theM via DBeaver or ask Claude/ChatGPT to write a migration function that you can run in your main block
  • :warning: make sure to tell the LLM to warn you if anything you’re doing isn’t easily reversible and how you should do it in a safe way
  • if you get stuck you can export DDL and provide it to your LLM of choice to show it the current state of your DB when your SQLAlchemy model falls out of sync of your actual DB
1 Like
3

Hi, @Dimitri_S ,
I’m not trying to discourage people from using a database, and as you say it’s not that hard, but I don’t always want to deal with setting up the DB somewhere and hosting it, and everything else that goes with having an additional piece of infra.

Your suggestions are spot-on for anything worth a little setup, especially for people with SQL experience.

-Richard

2 Likes
4

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.