Python Web App using INTERACTIVE AGGRID Table connected to GOOGLE SHEET |JavaScript Injection | смотреть онлайн

Hi everyone ! Here's another video on Streamlit- AgGrid Implementation with usage of Button Renderer within AgGrid tables. Additionally, also show-casing the automation with Google Sheets as it's Database.
Thank you for all the feedbacks and comments in my previous two videos - which helped me to create this demo app and the video.

? You can find the code here - https://github.com/avrabyt/YouTube-Tutorials/blob/main/Streamlit-Python/Streamlit-AgGrid-Usage/pages/aggrid-button-app.py
? Live Demo App - https://avra-youtube-aggrid.streamlit.app/

? GitHub code for all my YouTube tutorials (Support with ? if you like it!)- https://github.com/avrabyt/YouTube-Tutorials

⏪ Streamlit Tutorials - https://youtube.com/playlist?list=PLqQrRCH56DH8JSoGC3hsciV-dQhgFGS1K

? Suggested video to watch before hand for a quick start:
1. Streamlit AgGrid Part 1 - https://youtu.be/F54ELJwspos
2. Streamlit AgGrid Part 2 - https://youtu.be/Zs9-8trPadU
3. STREAMLIT PYTHON WEB APP connected to GOOGLE SHEET as DATABASE | - https://youtu.be/EMZyVWgUU5A
4. How to automate Google Sheets using Python - https://youtu.be/ZVfzDOWiOQ0

? Resources to read :
1. My Notion post for connecting Google Sheet as Database https://www.notion.so/Streamlit-Google-Sheets-Automation-76c67cfa6d784b2eba195cc454a4dbaa
2. Streamlit's Blog Post - https://docs.streamlit.io/knowledge-base/tutorials/databases/private-gsheet
3. AgGrid Button Implementation Blog - https://blog.ag-grid.com/cell-renderers-in-ag-grid-every-different-flavour/
4. Stylin Buttons CSS - https://www.w3schools.com/css/css3_buttons.asp

? Streamlit - https://streamlit.io
? AG Grid - https://www.ag-grid.com
Gspread - https://github.com/burnash/gspread
▶️ A big shout out to the amazing component build by Pablo , without which this may not have been possible - https://github.com/PablocFonseca/streamlit-aggrid

--------------------------------------------------------------------------------
Creating content and investing time was only possible because of the constant support and feedbacks from you all. Grateful for that !
☕️ Want to support me in creating more free contents ? https://www.buymeacoffee.com/AvraCodes
? GitHub - https://github.com/avrabyt
? Stay connect with me over Twitter - https://twitter.com/Avra_b
? Read my blogs here - https://medium.com/@avra42
? Website - https://avratanubiswas.github.io/
? Want to share your Blog Posts, I'll be happy to host here - https://avratanubiswas.github.io/cats-and-codes/

? Don't forget to subsribe to my channel if you like my videos ! ✨

? By becoming a patron, you'll get access to exclusive content, codes, or videos beforehand, one-to-one web app development / relevant discussion, live-chat with me on specific videos and other perks. ( FYI : Basic Tier is 50% cheaper than ChatGPT/monthly with benefits which an AI can't help with ? ):
https://patreon.com/user?u=82100262&utm_medium=clipboard_copy&utm_source=copyLink&utm_campaign=creatorshare_creator&utm_content=join_link

And of course, I will check your feedbacks and would definitely love to cover those as well, so please feel free to leave your comments and suggestions ?

#streamlit #aggrid #python #googlesheets #webdevelopment #webapp #pythonforbeginners #pythonprogramming #googlesheet #pythonprogramming #pythonprogramming #dataanalytics #uidevelopment

Video Segments
0:00 Introduction about the video and Web App
5:25 Workflow : Writing the App
6:30 Installation and working with packages
9:50 Implementing a basic AgGrid table
11:01 Render Buttons within AgGrid Table
18:03 Adding Function to the rendered button
22:42 Wrapping within a Submit Button for ease of use
24:33 Automate Streamlit Plots
26:21 Download the AgGrid data
27:28 Quick recap untill now what we did
28:34 Connect AgGrid with Database (Google Sheet)
33:20 Summarize the app
34:26 Wrap up





Looking forward to hear from you all ! ?
Ta-Da ! ?
————————————
A gentle reminder , times are difficult for all of us lately . With an ongoing pandemic and a tragic war, feeling overwhelmed and mentally exhausted is very common . Let’s try not to be harsh on ourselves and take good care of our physical and mental well being for the brighter tomorrow. Love and strength ❤️
—————————————