Every founder knows the feeling: you’re copying data from one tool, pasting it into another, reformatting a CSV, sending a follow-up email. It takes twenty minutes, and you do it twice a week. That’s nearly three hours a month on something a script could do in seconds.
But starting from scratch can feel overwhelming. You think you need to be a developer, or that it’ll take days to build something reliable. The truth is, you can automate your first workflow in about thirty minutes using a simple script and a cron job. Let me walk you through it.
First, pick one task. Just one. A good candidate is something you do regularly, that takes more than five minutes, and that follows the same steps every time. For me, it was generating a weekly CSV report from our analytics dashboard and emailing it to the team.
Next, break that task into steps. Write them down as if you were explaining to a colleague. For the CSV report, the steps were: pull data from the API, clean the columns, save as CSV, send an email. That’s it.
Now, write a script that does each step. You can use any language, but Python is great for this because it has libraries for everything. If you’re not a coder, start with a simple Bash script. The point is to get the logic down, not to write perfect code.
Once the script works when you run it manually, schedule it. On a Mac or Linux, use cron. On Windows, use Task Scheduler. You want it to run automatically at a set time. For my report, I set it to run every Monday at 9 AM. That’s the moment the busywork disappears.
You’ll hit hiccups. The API might change, or your script might break when a field is empty. That’s normal. The fix is usually simple, and you’ll learn more from debugging than from any tutorial.
After you’ve automated one workflow, you’ll see others. You’ll start noticing repetitive tasks everywhere—and you’ll know you can script them away. That’s the mindset shift that saves you hours every week.
Start small, but start today. Pick that one task, write a script, schedule it. Thirty minutes from now, you’ll have a piece of busywork that’s gone forever.