Create a Google Sheets Data Entry Form with Python & Streamlit | Quick & Easy Tutorial

Поділитися
Вставка
  • Опубліковано 22 лис 2024

КОМЕНТАРІ • 119

  • @CodingIsFun
    @CodingIsFun  Рік тому +6

    *Here are the links:* ⤵
    Live demo: vendor-data-entry.streamlit.app/
    Source Code: github.com/Sven-Bo/google-sheets-data-entry-form-with-streamlit
    Gsheets-connection package: github.com/streamlit/gsheets-connection

  • @ildan_haebwa
    @ildan_haebwa Рік тому +3

    I was having difficulties because an error occurred in streamlit web distribution.
    I was able to solve the problem by watching the video.
    Among the streamlit content I am studying, your video is the best.
    thank you.
    Please continue to produce good streamlit content.

    • @CodingIsFun
      @CodingIsFun  11 місяців тому +1

      Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video! 👍

  • @juanwea223
    @juanwea223 10 місяців тому

    Great video as always. I would like the video about the login to see how you can control which user can see certain info!

    • @CodingIsFun
      @CodingIsFun  10 місяців тому

      Thanks for watching. Login (authentication) is already on 'videos-to-do' list! Stay tuned! ✌️

  • @AyieMedia
    @AyieMedia 22 дні тому

    Awesome tutorial. Many thing i learn from this video

    • @CodingIsFun
      @CodingIsFun  18 днів тому

      Glad I could help! Thanks for watching and for the kind words. -Sven ✌️

  • @GeniusLila
    @GeniusLila Рік тому +3

    Thank you immensely for this invaluable content! Your effort is truly appreciated. 😊 Could you consider crafting another video demonstrating how to incorporate eye-catching statistics, just like Google does in their forms with pie charts, line graphs, or bar graphs? It'd be amazing to see this in action for data like gender ratios, age distribution, course preferences, and more. I'm curious if Streamlit alone can handle this or if you'd recommend building a separate admin dashboard. Could you share your insights on that process? Can't wait to see what's next! 👍

    • @CodingIsFun
      @CodingIsFun  Рік тому

      Thanks for watching and your suggestion! 👍

    • @bolokangmpoma
      @bolokangmpoma 6 місяців тому

      @@CodingIsFun As i'm walking on implementing something similar to this, I would want to know if you have done a video on this comment. I'm enjoying this so far

  • @jacksonmarube4056
    @jacksonmarube4056 5 місяців тому

    Well explained, I would love a tutorial on the security bit

    • @CodingIsFun
      @CodingIsFun  5 місяців тому

      Thanks for watching. What exactly do you mean? Cheers, Sven ✌️

  • @akokkalis1
    @akokkalis1 Рік тому +1

    Again an excellent informative video. Please make a 2nd video alsoa nd include also a login functionality.

    • @CodingIsFun
      @CodingIsFun  Рік тому

      Thanks for watching. Glad you liked this one too and your request is well noted! 👍

  • @ricardo.alves.campos
    @ricardo.alves.campos Рік тому

    Excellent as always, a second video about login would be awesome!

    • @CodingIsFun
      @CodingIsFun  11 місяців тому +1

      As always, thanks a lot for your comments! I added the login feature on my "videos-to-do-list" ;)

    • @MS-tu5ew
      @MS-tu5ew 4 місяці тому

      I would be very interested also.

  • @HendrikYap
    @HendrikYap Рік тому +1

    Thank you for the lesson. Yeah now we need authentication and also how to let user update their own details.

    • @CodingIsFun
      @CodingIsFun  Рік тому +1

      Thanks for watching. Well noted! 👍

  • @Healthtipsalways01
    @Healthtipsalways01 Рік тому

    Thank you for providing the neat demonstration, it helped me very much

  • @luisfernandoperezarmas7198
    @luisfernandoperezarmas7198 9 місяців тому

    This video is a treasure. Thank you so much...

    • @CodingIsFun
      @CodingIsFun  9 місяців тому

      Glad to hear you liked it! Thank you for commenting and watching. Cheers, Sven ✌️

  • @swelanauguste6176
    @swelanauguste6176 Рік тому +2

    Thanks for the all the videos. Can you do a streamlit auth video with postgres?

    • @CodingIsFun
      @CodingIsFun  Рік тому +1

      Thank you for watching the videos! I will create another video to add authentication, but I cannot promise to use a PostgreSQL database for that. Nonetheless, the steps/code will be very similar.

  • @ipmanbot
    @ipmanbot Рік тому

    thank you, I really enjoyed learning this, please show me other exercises, like login session and others

    • @CodingIsFun
      @CodingIsFun  Рік тому

      Thanks for watching and your request is well noted! 👍

  • @aminedj430
    @aminedj430 11 місяців тому

    great i will be using this in my next project wish i am working on now i needed a database for my collected info i think i can even add tableau to this.

    • @CodingIsFun
      @CodingIsFun  11 місяців тому

      Glad it was helpful and good luck with your project! 🤞

  • @zkiyyeller3525
    @zkiyyeller3525 Рік тому

    I always appreciate your content Sven. You would use this over google forms if the rest of your app is in streamlit correct?

    • @CodingIsFun
      @CodingIsFun  Рік тому

      Thank you for watching. I'm happy to hear that you like the content. I think it really depends on your use case. MS Forms is great and works right out of the box. However, if you need more customization options, the combination of Streamlit and Google Sheets could be another solution.

  • @linh-loantran8272
    @linh-loantran8272 Рік тому +1

    Thanks very much for the video. Always enjoy and learn so much from your contents. Could you please integrate the authentication to protect this application?

    • @CodingIsFun
      @CodingIsFun  Рік тому

      Happy to hear that you enjoyed this one as well! Yes, in the coming weeks, I will create another video to show how to add the authentication.

  • @mytube1000javed
    @mytube1000javed Рік тому +1

    Good. But what are benefits or advantages? Instead of entering data directly into gsheet?

    • @CodingIsFun
      @CodingIsFun  11 місяців тому

      Thanks for watching. It just an (practical) on how to connect Streamlit with Google Sheets.

  • @zazzleq6139
    @zazzleq6139 Рік тому

    Haha 😂 that woman diving into the water was so funny

  • @nssdesigns
    @nssdesigns 9 місяців тому

    This is super interesting and I can already think of uses for something like this. Do you have any videos on pulling data from spreadsheets Excel or Google Sheets and using that data to fill in online forms... like reverse scraping?

  • @florianroeseler2404
    @florianroeseler2404 Рік тому +1

    That’s very practical, thank you!

    • @CodingIsFun
      @CodingIsFun  Рік тому

      Glad it was helpful, Florian. Thanks for watching and your comments! 👍

  • @gongshow87
    @gongshow87 Рік тому

    The Login screen would be super helpful, we'd need to keep the created login credentials somewhere else right?

    • @CodingIsFun
      @CodingIsFun  Рік тому

      Well noted! Yes, you would also need to set up a database to store/retrieve/update/delete the credentials.

  • @franklinajisogun
    @franklinajisogun 5 місяців тому

    Hey, thanks for the video. What color theme are you using on VSCode? Thanks.

    • @CodingIsFun
      @CodingIsFun  5 місяців тому

      Thanks for watching. I am using Cobalt3: marketplace.visualstudio.com/items?itemName=alex-pattison.theme-cobalt3
      Cheers, Sven ✌️

    • @franklinajisogun
      @franklinajisogun 5 місяців тому

      @@CodingIsFun Thanks

  • @eimdev
    @eimdev 11 місяців тому

    Thanks for the video. Is there any limitation for using the Google API?

    • @CodingIsFun
      @CodingIsFun  11 місяців тому

      Thanks for watching. Have a look at the following Google Sheets rate limits: developers.google.com/sheets/api/limits
      I hope it helps! :)

  • @InteligenciadeNegocios
    @InteligenciadeNegocios 11 місяців тому

    Thank you for your help, just a quick question, i am facing the following error: Spreadsheet must be specified

    • @CodingIsFun
      @CodingIsFun  11 місяців тому

      Hard to tell from a distance why you are facing an issue

  • @jajwarehouse1
    @jajwarehouse1 Рік тому +2

    Does this work if multiple users input data concurrently, or does it overwrite the google sheet with the last update?

    • @CodingIsFun
      @CodingIsFun  Рік тому +1

      Thanks for watching. Multiple users could use it at the same time.

  • @ReliableAIBooks
    @ReliableAIBooks 8 місяців тому +1

    i want to add image upload in this form can u help?

  • @AirFerrari
    @AirFerrari Рік тому

    This was very helpful thank you!

    • @CodingIsFun
      @CodingIsFun  Рік тому

      Glad it was helpful! Thanks for watching and leaving a comment! :)

  • @UzairSukor
    @UzairSukor 8 місяців тому

    This is great, but I have issue add new submission. It only update the previous submission instead of add in another new row.
    And is it normal for the slow run?

    • @CodingIsFun
      @CodingIsFun  7 місяців тому

      Thank you for watching. Please check out my code:
      github.com/Sven-Bo/google-sheets-data-entry-form-with-streamlit/blob/main/vendor_app.py
      You will need to append the new data to your dataframe. I hope it helps! Happy coding! Cheers, Sven ✌️

  • @tritruong1299
    @tritruong1299 11 місяців тому

    Love your contents, can you do a project similar but using sharepoint api to update list ?

    • @CodingIsFun
      @CodingIsFun  11 місяців тому

      Thanks for watching! I'm happy to hear that you are enjoying my videos, and thank you for your video suggestion. I can't make any promises, but your suggestion is well noted.

  • @zoneinfo5584
    @zoneinfo5584 Рік тому

    Superb

  • @HM-bs4cc
    @HM-bs4cc Рік тому

    Great 👏👏

  • @asseeltarish7217
    @asseeltarish7217 11 місяців тому

    can you please tell me what python and streamlit versions you are using in this video because i am facing a lot of compatibility issues between them and other libraries such as st-gsheets-connection

    • @christophoramorim3147
      @christophoramorim3147 6 місяців тому

      Também estou com o mesmo problema, instalei apenas o python e vs code para começar e esta dando erro. Estou usando atualmente o python na versão 3.12.3

  • @haninawaya9967
    @haninawaya9967 Рік тому

    It is really amazing

    • @CodingIsFun
      @CodingIsFun  11 місяців тому

      Glad you liked it. Thanks for watching and taking the time to leave a comment! 👍

  • @musharrafmk4315
    @musharrafmk4315 Рік тому +1

    Thanks a lot sir but i m encountering with an error
    My app is working well when i locally host my app and it is even appending the data in my sheets but when i deploy it i m getting this as error
    ModuleNotFoundError: This app has encountered an error. The original error message is redacted to prevent data leaks. Full error details have been recorded in the logs (if you're on Streamlit Cloud, click on 'Manage app' in the lower right of your app).
    Traceback:
    File "/home/adminuser/venv/lib/python3.9/site-packages/streamlit/runtime/scriptrunner/script_runner.py", line 534, in _run_script
    exec(code, module.__dict__)
    File "/mount/src/appointments/appointments.py", line 4, in
    from streamlit_gsheets import GSheetsConnection

    • @CodingIsFun
      @CodingIsFun  11 місяців тому +1

      Thanks for watching. Have you included in the requirements.txt file in your GitHub repo?

  • @RedCloudServices
    @RedCloudServices 11 місяців тому

    Does Streamlit connect to postgresql for a CRUD ui?

    • @CodingIsFun
      @CodingIsFun  11 місяців тому

      Thanks for watching. Yes, it does. Have a look here: docs.streamlit.io/knowledge-base/tutorials/databases/postgresql

  • @sneffetsd
    @sneffetsd Рік тому

    really would like to see how to make authentication with firebase.

    • @CodingIsFun
      @CodingIsFun  Рік тому +1

      Thanks for watching and your suggestion! 👍

  • @zafiqsyaddiqradzi
    @zafiqsyaddiqradzi Рік тому

    how do you retrieve the data from the spreadsheet to the streamlit?

    • @CodingIsFun
      @CodingIsFun  11 місяців тому

      Thanks for watching. Feel free to check out the code I provided on GitHub. Happy Coding!

  • @trdais369
    @trdais369 9 місяців тому

    Hello sir, i have the problem when using input worksheet as mine, and the problem is
    "ValueError: Spreadsheet must be specified"
    and my error in coding was
    "existing_data = conn.read(worksheet="Data", usecols=list(range(6)), ttl=5)"
    Do u know how to fix it?
    Thanks a lot

    • @CodingIsFun
      @CodingIsFun  9 місяців тому

      Thanks for watching. Did you share the technical user email address in Google Sheets as shown in the video? Cheers, Sven ✌️

  • @raphaelwerneck
    @raphaelwerneck 7 місяців тому

    Is it possible to delete a row? I am trying using the st.data_editor but is not working. Ty so much

    • @CodingIsFun
      @CodingIsFun  6 місяців тому +1

      Thanks for watching. Yes, that is possible. Have a look here: github.com/Sven-Bo/google-sheets-data-entry-form-with-streamlit/blob/main/vendor_app.py#L156
      Happy Coding! Cheers, Sven ✌️

    • @raphaelwerneck
      @raphaelwerneck 6 місяців тому

      @@CodingIsFun ty so much!

  • @user-ue8jm2qm9c
    @user-ue8jm2qm9c 11 місяців тому

    can streamlit makes an option to choose time? i want to have a dropdown to select a data (can be from live or just from csv) ie Week over Week (such as last 7 days), or month over month (previous 30 days), or even a quarter (previous 90 days)? seems like i cant find the option to do so, as a dropdown

    • @CodingIsFun
      @CodingIsFun  11 місяців тому

      Thank you for watching! Unfortunately, the question you asked is not related to the video content. If you have any questions or need help, I suggest you join my Discord channel at pythonandvba.com/discord . Just make sure to read the forum rules before posting any questions.

  • @merekissagalyev5994
    @merekissagalyev5994 Рік тому +1

    Dear Sven! I am still getting this error when i try to st.dataframe(existing_data)
    I have done everything what you said in your last video, however still stuck with it. Please help me out

  • @agushendra
    @agushendra 4 місяці тому

    Hi, I got "No module named 'streamlit_gsheets'" error when running the app (7:01), I ran the app on my local computer and the st-gsheets-connection version is 0.0.4, can you help me to figure out the solution?

    • @CodingIsFun
      @CodingIsFun  4 місяці тому

      Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.

  • @uchiha_sasuke_48
    @uchiha_sasuke_48 Рік тому +1

    I'm also developed a similar project. But instead of Google sheets, I've used MySQL database.
    After successfully deploying my streamlit app in Community cloud, my app was not rendering. It was taking at least 15 min to render my web page. Could you please tell me a solution? 😢

    • @CodingIsFun
      @CodingIsFun  Рік тому +1

      Thanks for watching. Hard to tell from a distance. Sorry, that I cannot help!

    • @favourphilicvictor1059
      @favourphilicvictor1059 Рік тому +1

      Please let me know when you finally are able to deploy a streamlit app with mysql successfuly. I am having similar challenge

  • @sma9276
    @sma9276 7 місяців тому

    Dear Sir, I cannot create .streamlit folder in my mac. so I got this error "ValueError: Spreadsheet must be specified"

    • @CodingIsFun
      @CodingIsFun  7 місяців тому

      Please have a look here: chat.openai.com/share/b587e0d4-aa17-43eb-acd7-ccc7278e98b0
      I hope it helps! Happy Coding! Cheers, Sven ✌️

  • @LitoDev800
    @LitoDev800 10 місяців тому

    Hello, thank you for the video, I get the following errors when deploying my app:
    streamlit.runtime.caching.storage.cache_storage_protocol.CacheStorageKeyNotFoundError: Key not found in mem cache, &
    streamlit.runtime.caching.storage.cache_storage_protocol.CacheStorageKeyNotFoundError: Local disk cache storage is disabled (persist=None)

    • @CodingIsFun
      @CodingIsFun  10 місяців тому

      Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.

  • @rajchandra6913
    @rajchandra6913 6 місяців тому

    Hi I followed all
    The output scren is showng
    ValueError: Spreadsheet must be specified

    • @CodingIsFun
      @CodingIsFun  6 місяців тому

      Thanks for watching. Did you share your technical email address with the spreadsheet as shown in the video? Cheers, Sven ✌️

    • @rajchandra6913
      @rajchandra6913 6 місяців тому

      @@CodingIsFun my bad
      I wrote the forlder name without ' . ' before streamlit
      It's working fine now

  • @zollycp5044
    @zollycp5044 8 місяців тому

    Hi! i follow your step. but, i found an error while installing gsheets-connection like this
    note: This error originates from a subprocess, and is likely not a problem with pip.
    ERROR: Failed building wheel for pandas
    Failed to build pandas
    ERROR: Could not build wheels for pandas, which is required to install pyproject.toml-based projects
    I've already search on the internet to solve, but its still the same.

    • @CodingIsFun
      @CodingIsFun  8 місяців тому

      Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.

  • @haninawaya9967
    @haninawaya9967 Рік тому

    First comment 😊

  • @datadiego
    @datadiego 8 місяців тому

    where is the entry_form file sheet ?

    • @CodingIsFun
      @CodingIsFun  8 місяців тому

      Thanks for watching. You can easily create the spreadsheet yourself. I just used it as an example. And since it is private (as shown in the video), you will not have permission to access the sheet. Happy Coding! Cheers, Sven ✌

  • @hugovs27
    @hugovs27 4 місяці тому

    from streamlit_gsheets import GsheetsConnection Ln 2 Col 6

  • @julmasson6403
    @julmasson6403 Рік тому +1

    Dear Sven, thanks a lot for this video, this really helps for a project I need to implement.
    when following your steps, I got an error when testing the dataframe with st.dataframe(existing_data) at 6min.40 in the video.
    it returns the error "Spreadsheet must be specified" whereas you explicitly said it was not required.
    Do you know what I'm doing wrong ?
    thanks a lot
    Julien

    • @CameLinis
      @CameLinis Рік тому

      Check your secrets.toml if named correctly

    • @CodingIsFun
      @CodingIsFun  11 місяців тому

      Hi Julien. Thanks for watching. Kindly double check if you have set up the secrets.toml file correctly.

  • @skabdullahnewaz8232
    @skabdullahnewaz8232 6 місяців тому

    Can i share it to whatsapp?

    • @CodingIsFun
      @CodingIsFun  6 місяців тому +1

      I don't know what you mean

  • @osuccb9352
    @osuccb9352 3 місяці тому

    Please slow down. Great tutorial but you're going through it way too quick

    • @CodingIsFun
      @CodingIsFun  3 місяці тому

      Thanks for watching. You can always pause the video or rewatch certain parts. Cheers, Sven ✌️

  • @historyofislam7509
    @historyofislam7509 5 місяців тому

    Auto ML UI

  • @salman_3833
    @salman_3833 3 місяці тому

    not sure why but i keep getting this error!
    ValueError: numpy.dtype size changed, may indicate binary incompatibility. Expected 96 from C header, got 88 from PyObject
    and it points to "from streamlit_gsheets import GSheetsConnection"

    • @CodingIsFun
      @CodingIsFun  3 місяці тому

      Thanks for watching. Please clone the repo and try again. Cheers, Sven ✌️

  • @levinoppers8151
    @levinoppers8151 9 місяців тому

    data = worksheet.spreadsheet.values_get(
    AttributeError: 'Worksheet' object has no attribute 'spreadsheet'
    this the error i get, but this isnt even in my python script, it worked fine before for like a week and now suddenly i get this error.

    • @CodingIsFun
      @CodingIsFun  9 місяців тому

      Intersting. When I check my live demo app it still works as expected: vendor-data-entry.streamlit.app/