You've got a task that eats an hour every week. You do it the same way each time, and you suspect a computer could do it for you. You just don't know whether it's worth the effort to find out.
Usually it is, if the task fits a certain shape. Here's how to tell.
What a script is good at
A script is a short program that follows the same steps every time, without getting bored or making a typo. That makes it a good fit for tasks that are repetitive, rule-based, and tedious.
| Task | What the script does |
|---|---|
| Sorting and renaming files | Puts files in a consistent folder structure with consistent names |
| Cleaning up exports | Fixes the same formatting problems in every report or spreadsheet |
| Merging and removing duplicates | Combines scattered copies and keeps the best one |
| Moving data between tools | Copies information from one system to another so nobody re-types it |
| Routine reports | Builds the weekly or monthly summary on a schedule |
| Bulk changes | Applies one change to many accounts or files at once |
If a task follows rules you could write down on an index card, it's a candidate.
A real example: years of photos into one timeline
I've consolidated years of my own media and family photos into a single year, month, day folder structure, built for long-term storage and archiving. It had piled up over years, and now it's all in one place.
Every photo has a predictable home, a folder for its year, month, and day, and finding one doesn't depend on any single company's app.
I write these scripts in Python because it's portable. The same script runs on Windows, Mac, or Linux, so it isn't tied to one platform.
Do you really need to keep paying for photo storage?
Many people pay every month for cloud photo storage as if they had no choice. But how often do you go back ten years to look at one photo? For most of us, rarely.
Sometimes it makes sense to pick a cut-off date. Keep the recent years where you can reach them easily, and put everything older on a few local backups. Keep at least two copies on separate drives, and check once in a while that you can open them.
That isn't right for everyone. If you browse your whole library daily, the subscription may be worth it. The point is that it's a choice, not a requirement.
What isn't worth automating
- One-off jobs. If it takes ten minutes once a year, do it by hand.
- Tasks that change every time. A script needs rules. If each run needs a human decision, it can't help much.
- Anything you don't fully understand yet. Do it by hand a few times first, so you know what the rules are.
How to decide
Ask three questions: how often do I do this, how long does it take, and how often does someone make a mistake? A weekly task that takes an hour and goes wrong now and then is a strong candidate.
This is the kind of work I do for small businesses and individuals, as part of IT support and consulting, and what a consultant does explains the rest. If you're comparing options, how IT work is priced explains what to expect, a Mac Mini as an office server covers keeping your files on a machine you own, and locked out of iCloud or Google covers the account side for individuals. For the business version of connecting tools, see connecting your CRM to QuickBooks.
If you have a task like this, get in touch for a free consultation and tell me what you do over and over. Sometimes the answer is a script, sometimes it's AI, and sometimes it's "leave it alone".