The Ultimate Guide to Automating Boring Tasks with AI Scripts

by

You spend two hours every Friday manually copying data from one Excel sheet to another, renaming 50 different PDF files, and emailing them to your boss. What if I told you that you could completely automate this using AI, even if you don’t know a single line of programming code?

The real power of ChatGPT isn’t writing emails; it’s writing Python scripts that do your job for you. Here is a step-by-step guide on how I use AI to automate boring computer tasks.

Step 1: Install Python (The Engine)

To run the scripts the AI makes for you, your computer needs to understand the Python language.

  1. Go to python.org and download the latest installer for Windows.
  2. Run the installer. Crucial Step: At the very bottom of the first screen, check the box that says “Add Python to PATH”. If you forget this, nothing will work.
  3. Click Install Now.
Troubleshooting step 1

Step 2: Formulate the Perfect Prompt

You need to explain your boring task to the AI like you are talking to a 5-year-old. Assume the AI knows nothing about your folder structure.

Here is an example prompt:

“I am on a Windows 11 PC. I have a folder located at C:\Users\Dave\Desktop\Invoices. Inside are 50 PDF files. I want a Python script that will look at the creation date of each file, and rename the file to ‘Invoice_YYYY_MM_DD.pdf’. If a file with that name already exists, add a ‘-1’ to the end of it. Do not use any complex libraries, just standard Python.”

Troubleshooting step 2

Step 3: Run the Code

The AI will spit out a block of code.

  1. Open the Windows Start Menu, type Notepad, and hit Enter.
  2. Paste the code from ChatGPT into Notepad.
  3. Click File > Save As.
  4. Change “Save as type” from Text Documents to All Files.
  5. Name the file AutoRename.py and save it to your desktop.
  6. Double-click AutoRename.py. A black box will flash on the screen for half a second, and boom—all 50 of your PDFs are instantly renamed.

Step 4: Debugging (When it inevitably fails)

Sometimes the script won’t work on the first try. A black box will appear, some red text will flash, and it will close. Do not panic.

To see the error, open Command Prompt, type python C:\Users\Dave\Desktop\AutoRename.py, and hit Enter. The error message will stay on the screen.

Highlight the error message, press Ctrl+C, paste it back into ChatGPT, and say: “I ran the script and got this error. Fix it.” The AI will apologize, find its mistake, and give you an updated, working script.

FAQ

Can I automate clicking buttons on a website?

Yes. Ask the AI to write a “Selenium Python script.” However, this requires a bit more technical setup, as you have to install the Selenium library and a webdriver for Chrome. Start with simple file-renaming tasks first before attempting web automation.

Leave a Comment