Automate Boring Office Tasks with ChatGPT and Python

Рет қаралды 509,223

Күн бұрын

👉 Explore All My Excel Solutions: pythonandvba.com/solutions
𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
Tired of spending hours on tedious office tasks? In this video, I'll show you how to use ChatGPT and Python to automate some of those boring tasks. We'll be looking at automating Outlook, creating PowerPoint presentations, generating charts from Excel data, and manipulating PDFs.
First up, we'll go over how to use ChatGPT and Python to automate tasks in Outlook like sending emails to a list of recipients pulled from an Excel file. Then we'll move on to using ChatGPT and Python to create slides and add text and images to them for PowerPoint presentations.
Next, we'll look at how to use ChatGPT and Python to create interactive charts based on data from an Excel file. And lastly, we'll cover how to use ChatGPT and Python to automate PDF tasks like merging multiple documents.
As a bonus, we'll also take a look at how to use ChatGPT to write emails for you so you don't have to.
Overall, this video will give you a good idea of how you can use ChatGPT and Python to automate some of those repetitive tasks that take up so much of your time.
🌍 𝗟𝗜𝗡𝗞𝗦:
▶ The code and files can be found here: github.com/Sven-Bo/automate-o...
▶ The website with links to all ChatGPT prompts: automate-office-chatgpt.strea...
⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
00:00 - Intro
00:33 - 1. Example: Distribute Excel files with Outlook
03:21 - 2. Example: Automate PowerPoint
06:13 - 3. Example: Create an interactive chart from Excel data
07:07 - 4. Example: Merge PDFs
08:44 - 5. Example: Write Emails
09:14 - 6. Example: Create a Streamlit website
09:45 - Outro
𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): pythonandvba.com/mytoolbelt
📊 Data Visualization Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): pythonandvba.com/grafly
🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): pythonandvba.com/emojify
📑 Excel Templates: pythonandvba.com/go/excel-tem...
🎓 My Courses: pythonandvba.com/go/courses
📚 Books, Tools, and More: pythonandvba.com/resources
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn: / sven-bosau
📸 Instagram: / codingisfun_official
💻 GitHub: github.com/Sven-Bo
💬 Discord: pythonandvba.com/discord
📬 Contact: pythonandvba.com/contact
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:
▶ pythonandvba.com/coffee-donation

Пікірлер: 279

@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 Жыл бұрын

I'm stronger day by day.Thanks for promoting me. Stay with chatGPT official channel.

@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 Жыл бұрын

how about using python to automate microsoft teams messaging monitoring and automatic responses?

@carkawalakhatulistiwa Жыл бұрын

How about 365 copilot

@CodingIsFun Жыл бұрын

@@carkawalakhatulistiwa What about it?

@dont-want-no-wrench Жыл бұрын

you are giving it very precise directions, probably getting better results from that

@CodingIsFun Жыл бұрын

Thank you for tuning in. Indeed, I found that I achieved better results when I composed clear and precise prompts.

@Katsiarina1 Жыл бұрын

Amazing time we live in. Thanks for sharing!

@CodingIsFun Жыл бұрын

Thanks for the kind words and watching the video! Yeah, technology is pretty amazing these days. 🤯

@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 Жыл бұрын

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

@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 Жыл бұрын

@@AdrlanCC Why not simply trying it out? 😃

@AdrlanCC Жыл бұрын

@@CodingIsFun I will 😀 but I wasn't sure how to write the prompt.

@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 Жыл бұрын

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

@arch.blender1178 Жыл бұрын

PDF editing!!! you've made my day.

@CodingIsFun Жыл бұрын

Glad I could help! Thanks for watching! 💪

@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 Жыл бұрын

Glad you liked it. Thanks for watching. :)

@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 Жыл бұрын

Thanks for the positive feedback and watching the videos! Appreciate you taking the time to leave a comment. 👍

@Soheil-ev6ls Жыл бұрын

Yep. You need proper "Prompt Engineering" for this to work smoothly

@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 Жыл бұрын

Thanks for watching and leaving your thoughts. You're absolutely right, creating and tweaking the prompts took me some time.😊👍

@cristian15154 Жыл бұрын

Excellent information, thanks!

@CodingIsFun Жыл бұрын

Glad to hear you liked it! Thank you for commenting and watching. 👍

@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 Жыл бұрын

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 Жыл бұрын

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 Жыл бұрын

@@CodingIsFun My bet is that this will be achieved in the near future, through integration with Microsoft Power Automate.

@Soheil-ev6ls Жыл бұрын

@@maghambor Are you saying consultants are yet to be available? There's plenty of Automation consultancies out there.

@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.

@RiminiVirage Жыл бұрын

Excellent video, thank you.

@CodingIsFun Жыл бұрын

Glad to hear you liked it! Thank you for commenting and watching.

@gringadoor5385 Жыл бұрын

Twist, GPT sends an email to your manager that fires you instead and replaces your job with AI.

@CodingIsFun Жыл бұрын

😳😢

@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 Жыл бұрын

😂😂😂

@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 Жыл бұрын

Hires homeless man to enter prompt

@CNCPRINTBLOGSPOT Жыл бұрын

Hardcore awesome thank you so much! Thank you ❤️ very nice tutorials, such tutorial where can every office person can profit are awesome 👍

@CodingIsFun Жыл бұрын

Glad to hear you liked it! Thank you for commenting and watching. ✌

@servicekingbd Жыл бұрын

I'm stronger day by day.Thanks for promoting me. Stay with chatGPT official channel.

@CodingIsFun Жыл бұрын

Cheers for checkin' out the video and leavin' a comment.

@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 Жыл бұрын

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

@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 Жыл бұрын

Happy to have you back in the comments! Cheers for checking out the video! 👍

@gurdeepsingh1975 Жыл бұрын

Awesome video once again!

@CodingIsFun Жыл бұрын

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

@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 Жыл бұрын

Thanks for takin' the time to watch and leave a comment, much appreciated.

@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 Жыл бұрын

Glad it was helpful! Thanks for watching and taking the time to leave a comment

@cheerskeule7440 Жыл бұрын

Insane. Thank you man

@CodingIsFun Жыл бұрын

My pleasure! Appreciate you taking the time to watch and leave a comment. :)

@user-li7mq5hp9g Жыл бұрын

Great tutorial as always. Thank you very much!

@CodingIsFun Жыл бұрын

Glad you liked it! *Thanks for watching!* 👍

@kavinyudhitia Жыл бұрын

Ooohhh awesome!! Thanks for sharing!

@CodingIsFun Жыл бұрын

Thanks for the positive feedback! Appreciate you taking the time to leave a comment. 👍

@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 Жыл бұрын

😅

@joseg3102 2 ай бұрын

This is awesome!

@CodingIsFun Ай бұрын

Thanks! 🙏 Cheers, Sven ✌️

@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 Жыл бұрын

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! 💪

@happy2u91221 Жыл бұрын

Great video! Very good demonstration.

@CodingIsFun Жыл бұрын

Thanks for leaving a comment and for taking the time to watch! Glad you liked it.

@WirelessGus Жыл бұрын

thanks for sharing your knowledge. #respect 🤝

@CodingIsFun Жыл бұрын

My pleasure! Appreciate you taking the time to watch and leave a comment. 👍

@AmrAtef_CRE 6 ай бұрын

thank you for this awesome video

@CodingIsFun 6 ай бұрын

My pleasure! Appreciate you taking the time to watch and leave a comment.

@hyo1106 4 ай бұрын

hello, thanks a lot! inspiring !!

@CodingIsFun 4 ай бұрын

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

@videoanalyzers Жыл бұрын

Fantastic. So curious to see where we will be in a couple of years

@CodingIsFun Жыл бұрын

Thanks for watching. I'm excited for what's to come as well!

@youri655 Жыл бұрын

Awesome tutorial, thanks!

@CodingIsFun Жыл бұрын

Glad to hear you liked it! Thank you for commenting and watching. 👍

@rp5047 Жыл бұрын

Amazing decodes

@CodingIsFun Жыл бұрын

Thanks for checkin' out the video and leavin' a comment, much appreciated.

@sachin.tandon Жыл бұрын

Very impressive!

@CodingIsFun Жыл бұрын

Glad you liked it. Thanks for watching.

@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 Жыл бұрын

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 Жыл бұрын

@@CodingIsFun Thank you so much! You are an inspiration Sir!

@circuitmasters5258 Жыл бұрын

Man this is spooky 😂, chatgpt is kicking arse on all fronts

@CodingIsFun Жыл бұрын

😬

@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 Жыл бұрын

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 Жыл бұрын

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 Жыл бұрын

@@MrBernaln2 Was your WSJ article from 2021 or earlier?

@driouichelmahdi Жыл бұрын

Thank You Bro 👍👍👍👍👍

@CodingIsFun Жыл бұрын

An absolute pleasure! Thanks for watching and the first comment! 🎉🚀

@ashleybasson5664 Жыл бұрын

Sven: Chat, write the script for a KZfaq 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 Жыл бұрын

Haha 😂 Exactly like this 😅

@jalrox123 Жыл бұрын

Wow. You are so good at teaching

@CodingIsFun Жыл бұрын

Thanks for the kind words! I am glad you enjoyed it. 👍

@georgeolivares6952 Жыл бұрын

Amazing!

@CodingIsFun Жыл бұрын

Glad you liked it. Thanks for watching. :)

@FinanciallySavvyParent Жыл бұрын

This is fantastic

@CodingIsFun Жыл бұрын

Thanks for leaving a comment and for taking the time to watch! Glad you liked it. 😃

@phindilemandzendze3611 Жыл бұрын

Wow . This brought lot of solution to my offce problem.thnx

@CodingIsFun Жыл бұрын

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

@javshah105 Жыл бұрын

Thanks a lot

@CodingIsFun Жыл бұрын

My pleasure! Thanks for watching :)

@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 Жыл бұрын

Thanks for watching the video. It's always great to see how ChatGPT handles different tasks. Glad you're having fun with it! 👍

@Ilovemesumgravy 3 ай бұрын

I wanted to maximize the use of ChatGPT in coding and I believe this is a good stepping stone on how it actually can be done. Subscribed!

@CodingIsFun 3 ай бұрын

Welcome aboard and happy coding/prompting! 🎉 Cheers, Sven ✌️

@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 Жыл бұрын

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 11 ай бұрын

OMG!

@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 Жыл бұрын

...but in anycase, thanks for watching the video :)

@huseinramadhan6156 6 ай бұрын

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 6 ай бұрын

Thanks for watching. I am using camtasia.

@AndrewRoberts11 Жыл бұрын

Have you tried substituting Powershell for Python?

@CodingIsFun Жыл бұрын

Thanks for watching. At work, I also Powershell and Batch scripts. Mainly because they are integrated in Windows.

@arhennam6477 Жыл бұрын

Great video! thanks for sharing Im not developper, which app do you use to past the chatgpt's code please

@CodingIsFun Жыл бұрын

Thanks for watching. In the video, I used VS Code.

@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 Жыл бұрын

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!

@user-yj3mf1dk7b Жыл бұрын

why you ask him? ask ChatGPT LOL (it really works like that)

@thepragmatic6383 Жыл бұрын

Finally, did you get your raise?

@CodingIsFun Жыл бұрын

Working on it! 😬

@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 Жыл бұрын

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 Жыл бұрын

@@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!

@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 Жыл бұрын

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! 💻📈📚

@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 Жыл бұрын

Thanks for watching. Please have a look here: chatgpt-static.s3.amazonaws.com/chats/gq12619.html

@whoslappedthepie Жыл бұрын

How do you feed it the XLSX File? I don't understand this part

@CodingIsFun Жыл бұрын

I am not feeding the Excel file. I am just describing where my data is located

@divz2646 Жыл бұрын

Sir can we use it to make karoke of original songs or combine songs to make mashups?

@CodingIsFun Жыл бұрын

Thanks for watching. Just give it a try and ask chatGPT. Happy Coding! :)

@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 Жыл бұрын

Thank you for watching the video & your suggestion.

@Brovha Жыл бұрын

Which operating system are you using?

@CodingIsFun Жыл бұрын

Windows

@Brovha Жыл бұрын

@Coding Is Fun wow thank you so much for the reply

@AllNamesAreTakenROFL Жыл бұрын

I tried to automate outlook printing email attachments but the code never works.

@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.

@kevinsmall5232 10 ай бұрын

Wish I knew this when I had to stitch 500+ pdf pages together

@CodingIsFun 10 ай бұрын

Next time then ;)

@Traveltoexplore675 Жыл бұрын

In which software i have to paste the codes to generate the results?

@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.

@nikhil-di3vn Жыл бұрын

Can chatGPT access files on the computer?

@CodingIsFun Жыл бұрын

No, it cannot.

@vExXn1 Жыл бұрын

How can I make the same thing as in 1st Example but to send automatically at certain date?

@CodingIsFun Жыл бұрын

Thanks for watching. That is an excellent question also for ChatGPT ;) 👉 ibb.co/f0FWFBh

@plamenaleksandrov9063 Жыл бұрын

how does the AI enters your PC data and analyze It

@CodingIsFun Жыл бұрын

It doesn't. As shown in the video, you need to be specific with your prompt about the file/data location.

@abhijeetsingh2472 5 ай бұрын

Please tell, where are you copying and pasting the chatgpt provided codes

@CodingIsFun 5 ай бұрын

In VS Code

@h2nrlc 8 күн бұрын

i wonder if im running in javascript is it possible? i nver try it before

@CodingIsFun 8 күн бұрын

Thanks for watching. Sorry, but I am not sure what you mean. Cheers, Sven ✌️

@h2nrlc 7 күн бұрын

@@CodingIsFun i mean i made command to chatgpt to get the script but in javascript languange

@reflectedthoughts3376 9 ай бұрын

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 9 ай бұрын

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!

@picklenickil Жыл бұрын

The only thing missing are the cmd statements to get those library and venv setup

@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 Жыл бұрын

@@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.

@jarosaw4013 Жыл бұрын

But video is superb

@CodingIsFun Жыл бұрын

Thank you very much! :)

@Xceedch667 Жыл бұрын

Is there any code to automatically copying incoming certain whatsapp messages to another program like excel or word?

@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!

@RobertLoPinto Жыл бұрын

FYI, it was a deprecation warning, not depreciation.

@CodingIsFun Жыл бұрын

Thanks for the hint. You are absolutely right - I mispronounced it.

@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!

@AishaKhan-ev2tk 3 ай бұрын

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 2 ай бұрын

Thanks for watching and your suggestion! Cheers, Sven ✌️

@mehrabanbarimani Жыл бұрын

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 Жыл бұрын

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.

@mehrabanbarimani Жыл бұрын

@@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. 👍

@mehrabanbarimani Жыл бұрын

@@CodingIsFun Or maybe you know some proper youtube channel you can guide me to? Thank you.

@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 Жыл бұрын

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 Жыл бұрын

@@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

@hannaha.2917 Жыл бұрын

What inspires you to make these vids?

@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! ✌

@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 Жыл бұрын

Thank you for watching the video & your suggestion.

@ibaha411 Жыл бұрын

@CodingIsFun, do you know if it’s doable to print a streamlit page to a pdf file?

@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 Жыл бұрын

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 Жыл бұрын

@@CodingIsFun : i agree. think that it will accelerate the development faster. mediocre and low level coding will take a hit.

@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 Жыл бұрын

@@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 Жыл бұрын

AI will not make u jobless, a person using AI will.

@jerry27syd Жыл бұрын

Praise ChatGPT

@CodingIsFun Жыл бұрын

👍

@sayhi2kojo1 Жыл бұрын

Are u from Austria

@CodingIsFun Жыл бұрын

Nope, from Germany

@sayhi2kojo1 Жыл бұрын

@@CodingIsFun at least I was close

@yashikalanjewar6857 11 ай бұрын

omg!!!

@CodingIsFun 11 ай бұрын

🤯

@nathanaelaaron8292 Жыл бұрын

Power of god

@CodingIsFun Жыл бұрын

Thank you for watching the video and taking the time to leave a comment!

@se6369 Жыл бұрын

Why use Python instead of Visual Basic for Applications? VBA is already integrated with Office.

@CodingIsFun Жыл бұрын

Thanks for watching. Here is my opinion about it: kzfaq.info/get/bejne/fcuIY8pmv9CYgac.html Also, I have done a similar video using ChatGPT to generate VBA code. You can find the video here: kzfaq.info/get/bejne/d6uXrdV2vr_Gn4k.html

@se6369 Жыл бұрын

@@CodingIsFun Thanks!

@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 Жыл бұрын

Nope, that sometimes happens

@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 Жыл бұрын

You are welcome!

@bc4198 Жыл бұрын

Lol, people are already afraid of hackers - now we won't even get to use computers anymore 😆. 🤬 Now I scared myself 😞

@CodingIsFun Жыл бұрын

😬

@Lnd2345 Жыл бұрын

Amazing, time to say bye to programming jobs.

@CodingIsFun Жыл бұрын

Thanks! Let's see how it develops 😅

@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

@steeneugenpoulsen8174 Жыл бұрын

Here is a revolutionary solution instead. Stop DEFINING work as boring, work and work related stuff is most of our lives.

@CodingIsFun Жыл бұрын

Thanks for watching and throwing in your two cents.

@Bobberg90 9 ай бұрын

Content warnings are probably because you're potentially uploading personal data to ChatGPT.

@CodingIsFun 9 ай бұрын

Hmm, but I did not upload any personal information 🤔

@Melvin_bec 10 ай бұрын

Höre ich da deutsch raus?🤔

@CodingIsFun 10 ай бұрын

Jopp, ich bin Deutscher

@Melvin_bec 9 ай бұрын

@@CodingIsFun Den Akzent hört man leicht raus😂 aber gutes Video

@CodingIsFun 9 ай бұрын

@@Melvin_bec Danke!

@3V1TW1N Жыл бұрын

Kann es sein das du eigentlich deutsch sprichst?

@CodingIsFun Жыл бұрын

Japp, ich bin Deutscher

@vincent1237 Жыл бұрын

Are you deutsch

@CodingIsFun Жыл бұрын

Ja!

@sabitridevisonthalia8213 Жыл бұрын

Imagine my boss finding out 😇😇

@CodingIsFun Жыл бұрын

🤫

@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 Жыл бұрын

Thanks for watching and throwin' in your two cents.