Hey Thank you for your kind words. I agree with you . Im planning to invest on some paid software/ microphone soon . And also hopeful will be able add more time on creating more videos . Stay in touch , will be happy to receive your feedbacks 🤗🎈
Have you looked at using st.autheticate(name?) To allow access of different types(CRUD) TO only authenticated users ... As well as filtering the data to present only that users data from a sheet containing data for multiple users?
Do you mean the component - Streamlit authenticator? - github.com/mkhorasani/Streamlit-Authenticator This component is pretty useful , but I haven’t tried the way you described . I presume your use case perhaps bit complicated . However , you can use Firestore, to allow particular users to login and work on any database ( Google spreadsheet /SQLite ) . I’ve a video with firebase login . Please check it here - th-cam.com/video/KLmSfHcOXlc/w-d-xo.html Let me know how it goes . 🤗🎈
Hey, thx for the tutorial, but i'm a bit confused, how do i get a file with toml extension? I created a txt with the parameters needed as shown but is a txt not a toml extension
Hi, thanks for your feedback ! If I understood you correctly, what you obtain is a .json file (basically what you downloaded). All you need to do is create secret.toml file and copy the contents as mentioned. In your case, renaming from .txt to .toml will work . Furthermore, .toml file format is mostly supported with any IDEs. Let me know if it works for you, stay in touch, cheers !
@@Avra_b thx for the answer I fix that, but the problem is that My program is using oauth2client=4.0.0 and Im getting this errror googleapiclient.discovery_cache: file_cache is only supported with oauth2client
@@tomasoon ah I see , I haven’t tested with the newest version or came across this . How about downgrading it and maintaining a separate environment for this project ? Nevertheless, there must be a solution for the update as well , I’ll try to look for it . Incase you find one, please share with us .
Hi , I’m glad that you liked this video . I’m pretty sure it would work, since it’s just instead of Streamlit cloud you are deploying over heroku . However. I haven’t tried it myself , but expecting it to work :) Stay in touch
Hi! I keep getting errors saying that gspread module is not installed. my requirement.txt file is like this: pandas==1.5.1 streamlit==1.14.0 openpyxl < 3.0.10 xlrd < 2.0 schedule < 1.1.0 gspread==5.6.2 oauth2client == 4.1.3 gspread_pandas == 3.2.2 What do I need to do to make it work?
Hi thanks for your feedback . Have you checked my latest video on usage of Google Sheet connected to Streamlit web app ? Here’s the link - th-cam.com/video/sOFM334iILs/w-d-xo.html You will also find the code to the app / a blog post in the description which I presume Will definitely help you with the requirements file . Good luck and let me know 🤗
Hi Calaf , thank you for your feedback. Indeed it is possible. There's a possible workaround I can think of rn - Once the user input is recieved, the mathematical operations can be done within that runnning session of Streamlit using basic python operations (infact can be stored using SessionState) and finally update it to the database . What do you think ? Can that be implemented ? Best Avra
Thanks for the video tutorial. Question ? What does the secret_file format look like in the .toml file. I have the .json file, but I am not sure if you pass the file as a string or if you copy the content of the file as a variable within the .toml file. Can you provide a illustration of how this looks? I am getting errors with this part of the code. Thanks again.
Hi Davis, apologies for the late reply . I have added the section relevant to your question in my public notion page , please refer there - www.notion.so/Streamlit-Google-Sheets-Automation-76c67cfa6d784b2eba195cc454a4dbaa Basically, you copy the content from your .json file which you download, and paste it inside the .toml file as strings. I hope this helps. Feel free to write if there's further doubt.
@@Avra_b Thanks, Can you send me a link to your Streamlit /Notion automation ? That sounds interesting.... How do you like Notion compared to TaskAde ? Taskade has like a Zoom feature built in. If I could automate that with some Python, it would be a game changer.. Anyway, thanks for the tutorials....
@@SolidBuildersInc Here' s the link for the Streamlit- Notion automation - th-cam.com/video/f7wcXCekrnE/w-d-xo.html This was one of my very first videos, when Notion's API just came out . I must say, a lot can be explored further, and the video was very spotaneous and amateurish. May be, someday I will make another extended video. I'm very fond of Notion and it's rapid growth. Honestly, haven't worked with TaskAde much . I'll try it out more , and for sure I'll be happy to discuss and share my thoughts on it. Please do connect me on twitter also , and let's stay in touch , Cheers !
I'm basically doing the same thing but it's producing the KeyError gcp_service_account not found. Even though I have included that in the header. Can you help me with this mate. A bit stuck with a project. Would love your assistance. Thanks 😊
Hi , thank you for you feedback. I agree with you , that’s possible for sure . This basic application can be extended further in numerous ways with the help of the gspread module , or other work around. Cheers
Link to the code and relevant links :
www.notion.so/Streamlit-Google-Sheets-Automation-76c67cfa6d784b2eba195cc454a4dbaa
Thanks for the great tutorials!! A friendly suggestion: Your videos would be even better with less/zero background noise.
Hey Thank you for your kind words. I agree with you . Im planning to invest on some paid software/ microphone soon . And also hopeful will be able add more time on creating more videos . Stay in touch , will be happy to receive your feedbacks 🤗🎈
You are awesome, bro!
You too 🤗🎈Stay in touch and feel free to leave your feedbacks 🤗
Have you looked at using st.autheticate(name?) To allow access of different types(CRUD) TO only authenticated users ... As well as filtering the data to present only that users data from a sheet containing data for multiple users?
Do you mean the component - Streamlit authenticator? - github.com/mkhorasani/Streamlit-Authenticator
This component is pretty useful , but I haven’t tried the way you described . I presume your use case perhaps bit complicated . However , you can use Firestore, to allow particular users to login and work on any database ( Google spreadsheet /SQLite ) . I’ve a video with firebase login . Please check it here - th-cam.com/video/KLmSfHcOXlc/w-d-xo.html
Let me know how it goes . 🤗🎈
Hey, thx for the tutorial, but i'm a bit confused, how do i get a file with toml extension? I created a txt with the parameters needed as shown but is a txt not a toml extension
Hi, thanks for your feedback ! If I understood you correctly, what you obtain is a .json file (basically what you downloaded). All you need to do is create secret.toml file and copy the contents as mentioned. In your case, renaming from .txt to .toml will work . Furthermore, .toml file format is mostly supported with any IDEs. Let me know if it works for you, stay in touch, cheers !
@@Avra_b thx for the answer I fix that, but the problem is that My program is using oauth2client=4.0.0 and Im getting this errror googleapiclient.discovery_cache: file_cache is only supported with oauth2client
@@tomasoon ah I see , I haven’t tested with the newest version or came across this . How about downgrading it and maintaining a separate environment for this project ? Nevertheless, there must be a solution for the update as well , I’ll try to look for it . Incase you find one, please share with us .
@@Avra_b I found the solution! thx for the answers!
@@tomasoon I’m glad you could work it out . Thank you for your feedbacks and stay in touch :)
Hi Avra
Good tutorial just one thing to ask will this work if the app is deployed on Heroku
Hi , I’m glad that you liked this video . I’m pretty sure it would work, since it’s just instead of Streamlit cloud you are deploying over heroku . However. I haven’t tried it myself , but expecting it to work :) Stay in touch
Hi! I keep getting errors saying that gspread module is not installed. my requirement.txt file is like this:
pandas==1.5.1
streamlit==1.14.0
openpyxl < 3.0.10
xlrd < 2.0
schedule < 1.1.0
gspread==5.6.2
oauth2client == 4.1.3
gspread_pandas == 3.2.2
What do I need to do to make it work?
Hi thanks for your feedback . Have you checked my latest video on usage of Google Sheet connected to Streamlit web app ? Here’s the link - th-cam.com/video/sOFM334iILs/w-d-xo.html
You will also find the code to the app / a blog post in the description which I presume Will definitely help you with the requirements file . Good luck and let me know 🤗
Is it possible to do arithmetic operations on database based on user input using stremlit?
Hi Calaf , thank you for your feedback. Indeed it is possible. There's a possible workaround I can think of rn - Once the user input is recieved, the mathematical operations can be done within that runnning session of Streamlit using basic python operations (infact can be stored using SessionState) and finally update it to the database . What do you think ? Can that be implemented ?
Best
Avra
@@Avra_b Thank u for your response. I will check it.... thank u again
Thanks for the video tutorial. Question ? What does the secret_file format look like in the .toml file. I have the .json file, but I am not sure if you pass the file as a string or if you copy the content of the file as a variable within the .toml file. Can you provide a illustration of how this looks? I am getting errors with this part of the code. Thanks again.
Hi Davis, apologies for the late reply . I have added the section relevant to your question in my public notion page , please refer there - www.notion.so/Streamlit-Google-Sheets-Automation-76c67cfa6d784b2eba195cc454a4dbaa
Basically, you copy the content from your .json file which you download, and paste it inside the .toml file as strings. I hope this helps. Feel free to write if there's further doubt.
@@Avra_b Thanks, Can you send me a link to your Streamlit /Notion automation ?
That sounds interesting.... How do you like Notion compared to TaskAde ?
Taskade has like a Zoom feature built in. If I could automate that with some Python, it would be a game changer..
Anyway, thanks for the tutorials....
@@SolidBuildersInc Here' s the link for the Streamlit- Notion automation - th-cam.com/video/f7wcXCekrnE/w-d-xo.html
This was one of my very first videos, when Notion's API just came out . I must say, a lot can be explored further, and the video was very spotaneous and amateurish. May be, someday I will make another extended video. I'm very fond of Notion and it's rapid growth. Honestly, haven't worked with TaskAde much . I'll try it out more , and for sure I'll be happy to discuss and share my thoughts on it. Please do connect me on twitter also , and let's stay in touch , Cheers !
I'm basically doing the same thing but it's producing the KeyError gcp_service_account not found. Even though I have included that in the header. Can you help me with this mate. A bit stuck with a project. Would love your assistance. Thanks 😊
Is it fixed ?
Thank you for this tutorial, can you do a video using streamlit and MySQL database ?
Thanks for your suggestion . I’ll try to make one for sure . Stay in touch :)
You could add Update and Delete :)
Hi , thank you for you feedback. I agree with you , that’s possible for sure . This basic application can be extended further in numerous ways with the help of the gspread module , or other work around. Cheers
thanks man.
Great content
I’m glad that you liked it . Stay in touch :)
Finally an Indian who has proper accent 😁
Hahah
That’s quite funny to hear , but thank you 🤗
And his hair is so nice... ish... :D
Finally a blond girl who has proper intelligence.
See? That's what you did here. A microaggression.
@@cesarkopp2 Dear Mr.Kopp, I was pulling my friend's leg. :)
th-cam.com/video/0x9Pq4qzaXc/w-d-xo.html
You are great 😊
Means a lot . Thank you and stay in touch 🤗