Automate Boring Office Tasks with ChatGPT and Python

  Рет қаралды 528,021

Coding Is Fun

Coding Is Fun

Күн бұрын

Пікірлер: 285
@CodingIsFun
@CodingIsFun Жыл бұрын
*What do you think of ChatGPT? Have you been able to automate any tasks using it? Let me know in the comments!* All the code snippets, files and ChatGPT prompts used in this video can be found here ⤵ 👉 github.com/Sven-Bo/automate-office-tasks-using-chatgpt-python 👉 automate-office-chatgpt.streamlit.app/
@servicekingbd
@servicekingbd Жыл бұрын
I'm stronger day by day.Thanks for promoting me. Stay with chatGPT official channel.
@WirelessGus
@WirelessGus Жыл бұрын
I want to automate my world so I can spend time where life matters, people. ❤ Thank you for sharing your knowledge 📖 of how we can become free of these monotonous task we are ALL doing manually. A friend if mine who is studying for her masters cried of joy when I introduced her to chatGPT. 🤯
@maxpanicmovies
@maxpanicmovies Жыл бұрын
how about using python to automate microsoft teams messaging monitoring and automatic responses?
@carkawalakhatulistiwa
@carkawalakhatulistiwa Жыл бұрын
How about 365 copilot
@CodingIsFun
@CodingIsFun Жыл бұрын
@@carkawalakhatulistiwa What about it?
@AdrlanCC
@AdrlanCC Жыл бұрын
Great video! for someone who has a little bit of idea of what he wants, ChatGPT is a game changer. Thanks again for the video !
@CodingIsFun
@CodingIsFun Жыл бұрын
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video! 👍
@AdrlanCC
@AdrlanCC Жыл бұрын
@@CodingIsFun is it possible to generate a code that searches in the pdf files for a certain word and when it finds that word to rename and save the file with the found name? for example I have a Shop and I want after I scan the invoices from customers ,to rename them and save them with the name of the invoice. 🤔
@CodingIsFun
@CodingIsFun Жыл бұрын
@@AdrlanCC Why not simply trying it out? 😃
@AdrlanCC
@AdrlanCC Жыл бұрын
@@CodingIsFun I will 😀 but I wasn't sure how to write the prompt.
@Isaac-eh6uu
@Isaac-eh6uu Жыл бұрын
One of the better videos on using chat GPT. I'm sure coding this apps would have taken more time than writing the prompt but you still had to be very specific.
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for watching and leaving your thoughts. You're absolutely right, creating and tweaking the prompts took me some time.😊👍
@chamamemestre
@chamamemestre Жыл бұрын
Your videos are great as they highlight that for the vast majority of the cases, it's the user's responsibility for the effectiveness of chatGPT in understanding the task. Python works great with chatGPT, though I cannot say the same about VBA.
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for the positive feedback and watching the videos! Appreciate you taking the time to leave a comment. 👍
@Soheil-ev6ls
@Soheil-ev6ls Жыл бұрын
Yep. You need proper "Prompt Engineering" for this to work smoothly
@dont-want-no-wrench
@dont-want-no-wrench Жыл бұрын
you are giving it very precise directions, probably getting better results from that
@CodingIsFun
@CodingIsFun Жыл бұрын
Thank you for tuning in. Indeed, I found that I achieved better results when I composed clear and precise prompts.
@JordChase999
@JordChase999 Жыл бұрын
The step-by-step breakdown of each process is incredibly helpful. I can already imagine the amount of time and effort this automation will save. Thank you for sharing these valuable insights and empowering us to reclaim our time from mundane tasks.
@CodingIsFun
@CodingIsFun Жыл бұрын
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!
@manan8910
@manan8910 2 ай бұрын
I know there was a lot of trial and error whilst making these codes running correctly. Nice work man
@bc4198
@bc4198 Жыл бұрын
"ChatGPT, fix the algorithm so Sven's videos are back at the top of my feed. And then do my job for me. Please?"
@CodingIsFun
@CodingIsFun Жыл бұрын
Happy to have you back in the comments! Cheers for checking out the video! 👍
@stevenyu6835
@stevenyu6835 Жыл бұрын
It’s amazing. Previously people say talk is cheap, show me the code. From now on, code is cheap, let me know what you need
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for takin' the time to watch and leave a comment, much appreciated.
@jagotiberan2181
@jagotiberan2181 Жыл бұрын
This video gave me so many more ideas I hadn’t even thought of to automate several of my boring tasks 😂 thanks a bunch!
@CodingIsFun
@CodingIsFun Жыл бұрын
Glad you liked it. Thanks for watching. :)
@arch.blender1178
@arch.blender1178 Жыл бұрын
PDF editing!!! you've made my day.
@CodingIsFun
@CodingIsFun Жыл бұрын
Glad I could help! Thanks for watching! 💪
@tochtzin
@tochtzin Жыл бұрын
Thank you for this amazing step-by-step clip. I started using ChatGPT a few months ago to help me with similar scripts, but you've provided great examples that will reduce the number of errors I was receiving. Keep them coming please.
@CodingIsFun
@CodingIsFun Жыл бұрын
Glad it was helpful! Thanks for watching and taking the time to leave a comment
@franksampson477
@franksampson477 Жыл бұрын
Excellent and informative video. I imagine that in the future, one will be able to train AI tools to handle entire workflows independently. I can imagine that for workflows such as you demonstrate here, but also things like month-end billing and accounts payable handling and many more. We will tell the tool to define a month-end billing process that meets our requirements and to execute that process every month or at whatever interval is appropriate. If you are a small business owner that has had trouble finding and keeping a good bookkeeper, that would be a godsend.
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for checking out the video and sharing your thoughts. I'm curious to see what the future holds, and I can imagine that AI tools will be able to handle entire workflows independently in the future, like you said. 🤯
@maghambor
@maghambor Жыл бұрын
If you're a small business owner, your time is probably better invested using Zapier or something similar to integrate your various systems. Or even get a consultant to do it for you. And no, I would not trust this tech to try to run my bookkeeping system or dispatch program for me. At all. And that is because I can't code and I'm not going to start putting things into those systems which I don't really know what they're doing. I might get a consultant to do it for me, but those are yet to be available.
@Soheil-ev6ls
@Soheil-ev6ls Жыл бұрын
​@@CodingIsFun My bet is that this will be achieved in the near future, through integration with Microsoft Power Automate.
@Soheil-ev6ls
@Soheil-ev6ls Жыл бұрын
​@@maghambor Are you saying consultants are yet to be available? There's plenty of Automation consultancies out there.
@maghambor
@maghambor Жыл бұрын
@@Soheil-ev6ls Probably likely. But currently this is all a giant playground with very few serious implementations for companies. But give it a year or two and it will have changed the world.
@Katsiarina1
@Katsiarina1 Жыл бұрын
Amazing time we live in. Thanks for sharing!
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for the kind words and watching the video! Yeah, technology is pretty amazing these days. 🤯
@gringadoor5385
@gringadoor5385 Жыл бұрын
Twist, GPT sends an email to your manager that fires you instead and replaces your job with AI.
@CodingIsFun
@CodingIsFun Жыл бұрын
😳😢
@lindsayheyes925
@lindsayheyes925 Жыл бұрын
When you use it, your productivity can shoot up. It's just a tool. While Luddite coders are busy throwing their clogs into the machinery to "prove" that it doesn't work, their smart colleagues will master the tech and prove that THEY do work - and are more productive. So you are right in that the Luddites and Les Saboteurs will lose their jobs. Good - they hold their employers and their colleagues back... so 1970s. Meanwhile - this week - I've used it to re-create a lost program which had been written in VBASICA. Without AI, it had not been cost-effective to do it. I'm currently using it to create new apps which add value directly to the customer experience, none of which have been cost-effective to attempt until now. And it will not replace the Prompt Engineers, because Artificial Intelligence is a misnomer. It is no more intelligent than the box of tools in my garage, some of which were probably used by my Great Grandfather to build railway coaches in the same workshop where Stevenson's Rocket had been serviced. Just as a furniture maker or sculptor could use my tools to create amazing things, I can't because I don't have the skills. Aristotle knew the difference between us - an artificer needs ability, a teacher, and practice. He forgot to mention the tools. Nobody else can write the apps I am creating - they don't know what I have learnt. AI does - but doesn't know it. It needs me to be creative.
@bala6390
@bala6390 Жыл бұрын
😂😂😂
@ninjacat8113
@ninjacat8113 Жыл бұрын
Or even bigger twist, the AI controls someone into making a robot with its database on it, then it kills your boss ,then being your boss it kills you.
@EtchedinHistory-lu4iw
@EtchedinHistory-lu4iw Жыл бұрын
Hires homeless man to enter prompt
@stopthink9000
@stopthink9000 Жыл бұрын
Boss: Thanks for the automation! Now we'll hire a high schooler to do it part-time and you can pick up your final paycheck. Good Luck!
@CodingIsFun
@CodingIsFun Жыл бұрын
😅
@servicekingbd
@servicekingbd Жыл бұрын
I'm stronger day by day.Thanks for promoting me. Stay with chatGPT official channel.
@CodingIsFun
@CodingIsFun Жыл бұрын
Cheers for checkin' out the video and leavin' a comment.
@11111shruti
@11111shruti Жыл бұрын
yesterday, i was seeing your video of making a form template with pysimplegui and thought you should come up with ChatGPT... and now will watch this video of yours..
@CodingIsFun
@CodingIsFun Жыл бұрын
Maybe I should do a video on how to use ChatGPT with PySimpleGUI 😅 Anyways, thanks for watching and taking the time to leave a comment - I appreciate it! 💪
@shday4
@shday4 Жыл бұрын
What a great video, from XU considering going back to school for a another Bachelor's in computer science and I'm fascinated by what chat GPT will do to the process of applying technology to tasks
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for leaving a comment and for taking the time to watch! Glad you liked it. 👍
@videoanalyzers
@videoanalyzers Жыл бұрын
Fantastic. So curious to see where we will be in a couple of years
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for watching. I'm excited for what's to come as well!
@jalrox123
@jalrox123 Жыл бұрын
Wow. You are so good at teaching
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for the kind words! I am glad you enjoyed it. 👍
@cheerskeule7440
@cheerskeule7440 Жыл бұрын
Insane. Thank you man
@CodingIsFun
@CodingIsFun Жыл бұрын
My pleasure! Appreciate you taking the time to watch and leave a comment. :)
@joseg3102
@joseg3102 8 ай бұрын
This is awesome!
@CodingIsFun
@CodingIsFun 8 ай бұрын
Thanks! 🙏 Cheers, Sven ✌️
@gregory4290
@gregory4290 Жыл бұрын
This may be a silly question, but I am completely new to coding. When you copy the code and paste it into an empty python file, how do you get that? Is it a program that runs python files? What exactly do I need to download to run the code? Thanks!
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for watching. You would need to install Python on your machine first. To install and run Python: - Go to the official Python website (python.org) and download the latest version of Python (Python 3 is recommended) - Run the installation file and follow the on-screen instructions - Verify the installation by opening the terminal or command prompt and typing "python" - If the installation was successful, you will see the Python prompt (>>>) indicating that Python is ready to use - Open a text editor and type in your Python code - Save the file with a .py extension (e.g., "hello.py") - Open a terminal or command prompt and navigate to the directory where you saved the file - Type "python filename.py" (replace "filename" with the name of your file) and press enter I hope it helps! :)
@leventguner8882
@leventguner8882 Жыл бұрын
OMG!
@tylerpotts4304
@tylerpotts4304 Жыл бұрын
Great tutorial! I gave it a thumbs up. I noticed that you got a few deprecation warnings in your examples. One of the limitations of ChatGPT as noted by the developers is limited knowledge of world events after 2021. Perhaps this also implies that it doesn't have knowledge of any Python libraries updated after 2021? I know it doesn't do web crawling so I'm not sure how it could know of new updates to Python libraries. Regardless, it's a great tool.
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for watching and for giving the tutorial a thumbs up! I also noticed the Python depreciation and future warning as pointed out in the video. And yes, ChatGPT's knowledge is only current up to 2021, so any updates to Python libraries that came out after that, it's not aware of.
@MrBernaln2
@MrBernaln2 Жыл бұрын
I used the DAN promt. Asked it to summarize a WSJ link and it did so. Chat has connection , just needs the right promt.
@tylerpotts4304
@tylerpotts4304 Жыл бұрын
@@MrBernaln2 Was your WSJ article from 2021 or earlier?
@phindilemandzendze3611
@phindilemandzendze3611 Жыл бұрын
Wow . This brought lot of solution to my offce problem.thnx
@CodingIsFun
@CodingIsFun Жыл бұрын
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!
@ashleybasson5664
@ashleybasson5664 Жыл бұрын
Sven: Chat, write the script for a KZbin video on automating boring stuff with ChatGPT and Python that will cause the viewers to like the video, and subscribe to the channel.” ChatGPT: Easy-peasy…
@CodingIsFun
@CodingIsFun Жыл бұрын
Haha 😂 Exactly like this 😅
@WirelessGus
@WirelessGus Жыл бұрын
thanks for sharing your knowledge. #respect 🤝
@CodingIsFun
@CodingIsFun Жыл бұрын
My pleasure! Appreciate you taking the time to watch and leave a comment. 👍
@cristian15154
@cristian15154 Жыл бұрын
Excellent information, thanks!
@CodingIsFun
@CodingIsFun Жыл бұрын
Glad to hear you liked it! Thank you for commenting and watching. 👍
@zahraahmadi2234
@zahraahmadi2234 4 ай бұрын
I want to schedule the shifts of the operating room personnel by applying restrictions with the software automatically? What software do you recommend?
@CodingIsFun
@CodingIsFun 4 ай бұрын
Thanks for watching. It's hard to recommend a specific software without more details. If you need more personalized advice, you can schedule a consulting call with me here: pythonandvba.com/go/consulting-call Cheers, Sven ✌️
@CNCPRINTBLOGSPOT
@CNCPRINTBLOGSPOT Жыл бұрын
Hardcore awesome thank you so much! Thank you ❤️ very nice tutorials, such tutorial where can every office person can profit are awesome 👍
@CodingIsFun
@CodingIsFun Жыл бұрын
Glad to hear you liked it! Thank you for commenting and watching. ✌
@circuitmasters5258
@circuitmasters5258 Жыл бұрын
Man this is spooky 😂, chatgpt is kicking arse on all fronts
@CodingIsFun
@CodingIsFun Жыл бұрын
😬
@kavinyudhitia
@kavinyudhitia Жыл бұрын
Ooohhh awesome!! Thanks for sharing!
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for the positive feedback! Appreciate you taking the time to leave a comment. 👍
@gurdeepsingh1975
@gurdeepsingh1975 Жыл бұрын
Awesome video once again!
@CodingIsFun
@CodingIsFun Жыл бұрын
Glad you liked it! Thanks for watching and taking the time to leave a comment! 💪
@sachin.tandon
@sachin.tandon Жыл бұрын
Very impressive!
@CodingIsFun
@CodingIsFun Жыл бұрын
Glad you liked it. Thanks for watching.
@RiminiVirage
@RiminiVirage Жыл бұрын
Excellent video, thank you.
@CodingIsFun
@CodingIsFun Жыл бұрын
Glad to hear you liked it! Thank you for commenting and watching.
@rp5047
@rp5047 Жыл бұрын
Amazing decodes
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for checkin' out the video and leavin' a comment, much appreciated.
@rentacowisgoogle
@rentacowisgoogle Жыл бұрын
I love asking it to come up with a plausible code audit report for some code it spit out earlier. let it make the report and then say "sounds good, go ahead" without even reading it and see what it comes back with. Boy does it love error handling.
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for watching the video. It's always great to see how ChatGPT handles different tasks. Glad you're having fun with it! 👍
@mazz777
@mazz777 Жыл бұрын
Hi great video I do not know how to use python can you explain briefly where are you drop that code in to initiate the emails to be created?
@CodingIsFun
@CodingIsFun Жыл бұрын
Thank you for watching the video. To get started, you will need to install Python on your computer. Once that is done, you can create a Python script in the same folder as your email distribution list (stored in an Excel file). From there, simply run the script and the emails will be generated.
@gildaslefur2435
@gildaslefur2435 Жыл бұрын
@@CodingIsFun And if you are not sure how to install Python on your computer, just ask ChatGPT! For example, I typed: "How to install python on Windows 11?" and it gave me detailed instructions in 5 steps with the proper link to the right website to get the installer. This thing is really cool if you make good use of it!
@AmrAtef_CRE
@AmrAtef_CRE Жыл бұрын
thank you for this awesome video
@CodingIsFun
@CodingIsFun Жыл бұрын
My pleasure! Appreciate you taking the time to watch and leave a comment.
@minhngo154
@minhngo154 Жыл бұрын
thanks for the video, I tried the code to merge PDF but it was shown as error ModuleNotFoundError: No module named 'PyPDF2'. How can I fix this?
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for watching. Please have a look here: chatgpt-static.s3.amazonaws.com/chats/gq12619.html
@happy2u91221
@happy2u91221 Жыл бұрын
Great video! Very good demonstration.
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for leaving a comment and for taking the time to watch! Glad you liked it.
@yiktube
@yiktube Жыл бұрын
Can you make a video about a google map bot that send messages to a list of google map companies urls stored in google sheet please. ( Chat option hiden in desktop and visible only in apps ) using python.
@CodingIsFun
@CodingIsFun Жыл бұрын
Thank you for watching the video & your suggestion.
@d4tset785
@d4tset785 Жыл бұрын
What do you recommend for a beginner, i would like to learn data science!, is it goodnidea to do a bootcamp on.line or to selfstudy without bootcamp?
@CodingIsFun
@CodingIsFun Жыл бұрын
Hey there! Both ways have their merits. I personally did a 9-week full-time Data Science bootcamp at Le Wagon, which I found really helpful. However, it does come at a cost. On the other hand, if you're self-disciplined, self-study using resources like Kaggle, Coursera, or DataCamp can be a cost-effective option. Decide based on your learning style and budget. Happy learning! 💻📈📚
@ΣυμεώνΠαπαδόπουλος-λ4ο
@ΣυμεώνΠαπαδόπουλος-λ4ο Жыл бұрын
Great tutorial as always. Thank you very much!
@CodingIsFun
@CodingIsFun Жыл бұрын
Glad you liked it! *Thanks for watching!* 👍
@AndrewRoberts11
@AndrewRoberts11 Жыл бұрын
Have you tried substituting Powershell for Python?
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for watching. At work, I also Powershell and Batch scripts. Mainly because they are integrated in Windows.
@zkiyyeller3525
@zkiyyeller3525 Жыл бұрын
Thank you very much Sven awesome content as always. Are you working with MS 356 or Office 2021? Will I be better off buying one over the other to run this automation with python?
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for watching! Happy to hear that you liked this video too. I am currently using Office 2016, but the version of Office you use for Python automation does not matter. Either version will work.
@zkiyyeller3525
@zkiyyeller3525 Жыл бұрын
@@CodingIsFun Thank you so much! You are an inspiration Sir!
@arhennam6477
@arhennam6477 Жыл бұрын
Great video! thanks for sharing Im not developper, which app do you use to past the chatgpt's code please
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for watching. In the video, I used VS Code.
@hyo1106
@hyo1106 10 ай бұрын
hello, thanks a lot! inspiring !!
@CodingIsFun
@CodingIsFun 10 ай бұрын
Glad to hear you liked it! Thank you for commenting and watching. Cheers, Sven ✌️
@divz2646
@divz2646 Жыл бұрын
Sir can we use it to make karoke of original songs or combine songs to make mashups?
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for watching. Just give it a try and ask chatGPT. Happy Coding! :)
@huseinramadhan6156
@huseinramadhan6156 Жыл бұрын
hi sir, thank you for sharing these, it very helpful. what video editor app that you use? especially to zoom the video like in 03:54
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for watching. I am using camtasia.
@youriwatson
@youriwatson Жыл бұрын
Awesome tutorial, thanks!
@CodingIsFun
@CodingIsFun Жыл бұрын
Glad to hear you liked it! Thank you for commenting and watching. 👍
@TomCoutfit
@TomCoutfit Жыл бұрын
Hi. Just setting out on my Python journey but how have you set that up? Are you running it through Idle Shell? Thanks
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for watching. To install Python: Download the Python installer from official website ( www.python.org/downloads/ ), run it, select "Add Python to PATH" option, then hit "Install Now". Once done, install the required dependencies using pip: Open your Command Prompt or Terminal, type "pip install " and hit enter. I hope it helps! Happy Coding!
@Dmitrii-q6p
@Dmitrii-q6p Жыл бұрын
why you ask him? ask ChatGPT LOL (it really works like that)
@Brovha
@Brovha Жыл бұрын
Which operating system are you using?
@CodingIsFun
@CodingIsFun Жыл бұрын
Windows
@Brovha
@Brovha Жыл бұрын
@Coding Is Fun wow thank you so much for the reply
@dfkgjdflkg
@dfkgjdflkg Жыл бұрын
You can add to the salary increase letter an "Or, I am quitting for I will have many other job offers based on what I have done for your company"
@CodingIsFun
@CodingIsFun Жыл бұрын
...but in anycase, thanks for watching the video :)
@abhijeetsingh2472
@abhijeetsingh2472 11 ай бұрын
Please tell, where are you copying and pasting the chatgpt provided codes
@CodingIsFun
@CodingIsFun 11 ай бұрын
In VS Code
@reflectedthoughts3376
@reflectedthoughts3376 Жыл бұрын
What if I have multiple pdf files all having information about a visitor. I need to copy the name and other related things from the pdf and paste it into Excel which is tedious and I want it automated. The visitors are 107 and so to copy paste there specific information is boring
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!
@Traveltoexplore675
@Traveltoexplore675 Жыл бұрын
In which software i have to paste the codes to generate the results?
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for watching. You need to have Python installed and you can use any text editor you like. I have used VS code in the video.
@thepragmatic6383
@thepragmatic6383 Жыл бұрын
Finally, did you get your raise?
@CodingIsFun
@CodingIsFun Жыл бұрын
Working on it! 😬
@FinanciallySavvyParent
@FinanciallySavvyParent Жыл бұрын
This is fantastic
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for leaving a comment and for taking the time to watch! Glad you liked it. 😃
@nikhil-di3vn
@nikhil-di3vn Жыл бұрын
Can chatGPT access files on the computer?
@CodingIsFun
@CodingIsFun Жыл бұрын
No, it cannot.
@h2nrlc
@h2nrlc 6 ай бұрын
i wonder if im running in javascript is it possible? i nver try it before
@CodingIsFun
@CodingIsFun 6 ай бұрын
Thanks for watching. Sorry, but I am not sure what you mean. Cheers, Sven ✌️
@h2nrlc
@h2nrlc 6 ай бұрын
@@CodingIsFun i mean i made command to chatgpt to get the script but in javascript languange
@person1Exp
@person1Exp Жыл бұрын
amazing, can you write a code to do the same thing with Macbook default mail app on mac? I created a code and can do it, but it doesnt attach any attachments to it :(
@CodingIsFun
@CodingIsFun Жыл бұрын
Thank you for watching! If you're working with macOS, keep in mind that the code may require some tweaking to work properly. Unfortunately, I don't have a Mac at the moment, so I'm unable to test it out for you.
@person1Exp
@person1Exp Жыл бұрын
@@CodingIsFun Thanks for reading my comment and replying so quickly. There are ways to setup a macos though like hyper-v or setting up a vm. I appreciate if you let me know once you get a hold of MacOs. 👍
@person1Exp
@person1Exp Жыл бұрын
@@CodingIsFun Or maybe you know some proper youtube channel you can guide me to? Thank you.
@plamenaleksandrov9063
@plamenaleksandrov9063 Жыл бұрын
how does the AI enters your PC data and analyze It
@CodingIsFun
@CodingIsFun Жыл бұрын
It doesn't. As shown in the video, you need to be specific with your prompt about the file/data location.
@Xceedch667
@Xceedch667 Жыл бұрын
Is there any code to automatically copying incoming certain whatsapp messages to another program like excel or word?
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for watching! I'm not sure if there's existing code for what you need, but you'll probably need the WhatsApp API to make it happen. Good luck with your project and have fun coding!
@javshah105
@javshah105 Жыл бұрын
Thanks a lot
@CodingIsFun
@CodingIsFun Жыл бұрын
My pleasure! Thanks for watching :)
@driouichelmahdi
@driouichelmahdi Жыл бұрын
Thank You Bro 👍👍👍👍👍
@CodingIsFun
@CodingIsFun Жыл бұрын
An absolute pleasure! Thanks for watching and the first comment! 🎉🚀
@AllNamesAreTakenROFL
@AllNamesAreTakenROFL Жыл бұрын
I tried to automate outlook printing email attachments but the code never works.
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for watching. I'd like to suggest that you consider modifying your prompt. Sometimes, the wording of a prompt can make a big difference in the response that is generated. By making a few changes, you may be able to get a response that works.
@vExXn1
@vExXn1 Жыл бұрын
How can I make the same thing as in 1st Example but to send automatically at certain date?
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for watching. That is an excellent question also for ChatGPT ;) 👉 ibb.co/f0FWFBh
@AishaKhan-ev2tk
@AishaKhan-ev2tk 9 ай бұрын
Hey can you make a video where we can automate data entry tasks having different pdf format and needs to be added on CRM website.
@CodingIsFun
@CodingIsFun 9 ай бұрын
Thanks for watching and your suggestion! Cheers, Sven ✌️
@ibaha411
@ibaha411 Жыл бұрын
Can you make a video on how to use all these techniques in streamlit apps, Specifically, how to print a streamlit page to a pdf?
@CodingIsFun
@CodingIsFun Жыл бұрын
Thank you for watching the video & your suggestion.
@ibaha411
@ibaha411 Жыл бұрын
@CodingIsFun, do you know if it’s doable to print a streamlit page to a pdf file?
@georgeolivares6952
@georgeolivares6952 Жыл бұрын
Amazing!
@CodingIsFun
@CodingIsFun Жыл бұрын
Glad you liked it. Thanks for watching. :)
@youtubeuser1052
@youtubeuser1052 Жыл бұрын
It's fascinating that it repeatedly uses deprecated libraries/functions despite "knowing" that they are deprecated and "knowing" the equivalent non-deprecated method. I'm not sure what to make of this. Is this deliberate to make it more human or a strange flaw? Does ChatGPT generally make mistakes and only figure out the correct answer if the mistake is pointed out to it?
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for watching. I asked ChatGPT about it. Here is the answer: "As an AI language model, ChatGPT generates code based on patterns it has learned from large datasets of existing code. While it has been trained to use the most up-to-date libraries and functions, it may still generate code with deprecated libraries/functions due to various factors. ChatGPT generally strives to generate correct code, but like any tool, it may make mistakes. If you notice issues with the generated code, it's a good idea to review and update it as necessary." I then asked the following: Can you explain how you are able to provide the correct code even when the generated code is deprecated? Here is the answer: "As an AI language model, ChatGPT has access to a vast amount of information from a diverse range of sources, including documentation, code repositories, and programming guides. This allows me to know the correct code even when the generated code is deprecated."
@youtubeuser1052
@youtubeuser1052 Жыл бұрын
@@CodingIsFun I tried it out for a couple of tasks I'd been thinking about lately and there does seem to be a pattern of generating incorrect code and when I point out the error ChatGPT replies with "you're right, here's the correct code". I think also, if you ask it to do something impossible it gives an incorrect answer instead of admitting it's impossible
@picklenickil
@picklenickil Жыл бұрын
The only thing missing are the cmd statements to get those library and venv setup
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for watching. You can actually ask ChatGPT for each prompt how to install any third party package and how to set up a virtual env.
@picklenickil
@picklenickil Жыл бұрын
@@CodingIsFun yes, that's true for most packages, but chatGPT of10 invents packages. Example I was trying to make an Android widget that draws over other apps, in react native. I knew it could be done in flutter but team loves react. It very confidently suggested some npm packages that seemed legit and we agreed on them. Later we found out that none of them existed.
@sayhi2kojo1
@sayhi2kojo1 Жыл бұрын
Are u from Austria
@CodingIsFun
@CodingIsFun Жыл бұрын
Nope, from Germany
@sayhi2kojo1
@sayhi2kojo1 Жыл бұрын
@@CodingIsFun at least I was close
@se6369
@se6369 Жыл бұрын
Why use Python instead of Visual Basic for Applications? VBA is already integrated with Office.
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for watching. Here is my opinion about it: kzbin.info/www/bejne/fZa7YZprj89nh9U Also, I have done a similar video using ChatGPT to generate VBA code. You can find the video here: kzbin.info/www/bejne/d3bKq6V7jr6Vpbc
@se6369
@se6369 Жыл бұрын
@@CodingIsFun Thanks!
@kevinsmall5232
@kevinsmall5232 Жыл бұрын
Wish I knew this when I had to stitch 500+ pdf pages together
@CodingIsFun
@CodingIsFun Жыл бұрын
Next time then ;)
@KimYoungUn69
@KimYoungUn69 Жыл бұрын
Thanks, my manager is now daily receiving around 1000 emails for salary increase untill he replies with *approved* and a signature. Kindly Regards
@CodingIsFun
@CodingIsFun Жыл бұрын
You are welcome!
@RobertLoPinto
@RobertLoPinto Жыл бұрын
FYI, it was a deprecation warning, not depreciation.
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for the hint. You are absolutely right - I mispronounced it.
@RobertLoPinto
@RobertLoPinto Жыл бұрын
@@CodingIsFun No worries. I've been in many team meetings where even my lead developer made the same error. I guess it's better to have said depreciate instead of defecate!
@hellofrombd1960
@hellofrombd1960 Жыл бұрын
So, It’s time to search new job. If chatGpt can do such kind of codes .Then what will be the task of programmers? 🤔🤔🤔
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for watching the video! It could be also a tool to help us do our jobs better. 😅 Let's see what the future brings us 💪
@11111shruti
@11111shruti Жыл бұрын
@@CodingIsFun : i agree. think that it will accelerate the development faster. mediocre and low level coding will take a hit.
@ohnitiel
@ohnitiel Жыл бұрын
Given how many people fail to properly use Google, I am certain they'll also fail to user ChatGPT or any other AI that may come... The way it was done in the video is some of the best case cenarios. Code written in Python and someone with a programmers mindset, detailing each step exactly how it should be
@CodingIsFun
@CodingIsFun Жыл бұрын
@@ohnitiel When I first started using Excel and ChatGPT together, I kept it simple. But as I started tackling more "complex" tasks, I found it easier to break 'em down into smaller chunks and give detailed instructions for each step. And who knows, maybe as these models get better and better, they'll be able to handle more general prompts..
@aliaffan88
@aliaffan88 Жыл бұрын
AI will not make u jobless, a person using AI will.
@Melvin_bec
@Melvin_bec Жыл бұрын
Höre ich da deutsch raus?🤔
@CodingIsFun
@CodingIsFun Жыл бұрын
Jopp, ich bin Deutscher
@Melvin_bec
@Melvin_bec Жыл бұрын
@@CodingIsFun Den Akzent hört man leicht raus😂 aber gutes Video
@CodingIsFun
@CodingIsFun Жыл бұрын
@@Melvin_bec Danke!
@hannaha.2917
@hannaha.2917 Жыл бұрын
What inspires you to make these vids?
@CodingIsFun
@CodingIsFun Жыл бұрын
Hey Hannah, thanks for watching! I enjoy sharing awesome tools like ChatGPT, Python, and VBA, along with my learning experiences. It's all about making things simpler and learning new skills together! ✌
@jarosaw4013
@jarosaw4013 Жыл бұрын
But video is superb
@CodingIsFun
@CodingIsFun Жыл бұрын
Thank you very much! :)
@elsheep6951
@elsheep6951 Жыл бұрын
Am I the only one who gets the message from Chat GPT that it's busy? I was having fun seeing what it could do then one day.. "Thanks but we have all the users we can handle come back later". :(
@CodingIsFun
@CodingIsFun Жыл бұрын
Nope, that sometimes happens
@steeneugenpoulsen8174
@steeneugenpoulsen8174 Жыл бұрын
Here is a revolutionary solution instead. Stop DEFINING work as boring, work and work related stuff is most of our lives.
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for watching and throwing in your two cents.
@3V1TW1N
@3V1TW1N Жыл бұрын
Kann es sein das du eigentlich deutsch sprichst?
@CodingIsFun
@CodingIsFun Жыл бұрын
Japp, ich bin Deutscher
@jerry27syd
@jerry27syd Жыл бұрын
Praise ChatGPT
@CodingIsFun
@CodingIsFun Жыл бұрын
👍
@nathanaelaaron8292
@nathanaelaaron8292 Жыл бұрын
Power of god
@CodingIsFun
@CodingIsFun Жыл бұрын
Thank you for watching the video and taking the time to leave a comment!
@Bobberg90
@Bobberg90 Жыл бұрын
Content warnings are probably because you're potentially uploading personal data to ChatGPT.
@CodingIsFun
@CodingIsFun Жыл бұрын
Hmm, but I did not upload any personal information 🤔
@vincent1237
@vincent1237 Жыл бұрын
Are you deutsch
@CodingIsFun
@CodingIsFun Жыл бұрын
Ja!
@bc4198
@bc4198 Жыл бұрын
Lol, people are already afraid of hackers - now we won't even get to use computers anymore 😆. 🤬 Now I scared myself 😞
@CodingIsFun
@CodingIsFun Жыл бұрын
😬
@sabitridevisonthalia8213
@sabitridevisonthalia8213 Жыл бұрын
Imagine my boss finding out 😇😇
@CodingIsFun
@CodingIsFun Жыл бұрын
🤫
@Frdy12345
@Frdy12345 Жыл бұрын
Amazing, time to say bye to programming jobs.
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks! Let's see how it develops 😅
@maulikmadhavi
@maulikmadhavi Жыл бұрын
Unless you are typing query in Google while coding multiple times. Need to keep up and innovate uplift from monotonous boring tasks. You need to be ready to challenge up yourself
@maghambor
@maghambor Жыл бұрын
I think many of these videos are made by people who don't actually have current systems to work within and they tend to be generic. I would, for example, need a specific system to speak with another specific system and it's just fast doing it manually than learning how to code. So no, this tech is not where it needs to be and the people, like you, promoting it, don't understand what type of prompts people like me need. The tech is getting there but due to lack of collaboration between companies with the needs for it and people knowing how to write prompts and code, it's still probably 1-2 years away from making a difference just looking at it from where I'm sitting.
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for watching and throwin' in your two cents.
@crc0889
@crc0889 Жыл бұрын
Deprecation. Not depreciation. Pronounced deprekation.
@CodingIsFun
@CodingIsFun Жыл бұрын
Thank you very much for the hint. I appreciate it! 👍
@crc0889
@crc0889 Жыл бұрын
@@CodingIsFun thank you for your video! I love the ingenuity.
@yashikalanjewar6857
@yashikalanjewar6857 Жыл бұрын
omg!!!
@CodingIsFun
@CodingIsFun Жыл бұрын
🤯
@walidmat8972
@walidmat8972 Жыл бұрын
hey sven their is a scam acount (a copy of your same pic, name) who comment under your video and send people to a whatsapp acount
@walidmat8972
@walidmat8972 Жыл бұрын
one of your post that you have poste 4weeks ago
@CodingIsFun
@CodingIsFun Жыл бұрын
Thank you for informing me. I have also noticed and reported the account.
@sujungpark5764
@sujungpark5764 Жыл бұрын
😱🤔😥
@garethde-witt6433
@garethde-witt6433 Жыл бұрын
Don’t it’s asking for trouble the tasks maybe boring but I rather do boring than trust ai.
@CodingIsFun
@CodingIsFun Жыл бұрын
Thanks for giving the video a watch and leaving your thoughts!
@hmmm8158
@hmmm8158 Жыл бұрын
Unemployment will be soaring lol
@CodingIsFun
@CodingIsFun Жыл бұрын
😬
@ThePolaroid669
@ThePolaroid669 Жыл бұрын
wow, you're so gorgeous!
@CodingIsFun
@CodingIsFun Жыл бұрын
Thank you!
The most important Python script I ever wrote
19:58
John Watson Rooney
Рет қаралды 212 М.
$1 vs $500,000 Plane Ticket!
12:20
MrBeast
Рет қаралды 122 МЛН
Vampire SUCKS Human Energy 🧛🏻‍♂️🪫 (ft. @StevenHe )
0:34
Alan Chikin Chow
Рет қаралды 138 МЛН
She wanted to set me up #shorts by Tsuriki Show
0:56
Tsuriki Show
Рет қаралды 8 МЛН
JISOO - ‘꽃(FLOWER)’ M/V
3:05
BLACKPINK
Рет қаралды 137 МЛН
No More VBA. ChatGPT to automates boring work with Office Scripts
6:42
MyOnlineTrainingHub
Рет қаралды 151 М.
Use This Trick to Automate Any Excel Task (Better Than Macros)
10:53
Kenji Explains
Рет қаралды 121 М.
ChatGPT: Automating Excel with VBA like never before 🤯
10:56
Coding Is Fun
Рет қаралды 182 М.
AutoGPT Tutorial - More Exciting Than ChatGPT
23:56
Santrel Media
Рет қаралды 760 М.
Create Stunning Python GUIs in 10 Minutes With Drag & Drop
11:38
Coding Is Fun
Рет қаралды 105 М.
5 Amazing Ways to Automate Your Life using Python
18:40
Internet Made Coder
Рет қаралды 271 М.
Automate Excel using Python + ChatGPT-4o 🤯
7:40
Coding Is Fun
Рет қаралды 23 М.
Automating Boring Tasks Using ChatGPT and Python
12:38
The PyCoach
Рет қаралды 136 М.
$1 vs $500,000 Plane Ticket!
12:20
MrBeast
Рет қаралды 122 МЛН