It was 3:14 AM on a Tuesday in March 2021. I was sitting in my underwear, staring at a laptop screen that was glowing with the kind of clinical white light that makes you feel like a failure. I had just accidentally sent 402 automated ‘test’ emails to a client’s actual, live customer list. The subject line? ‘Test 123 – ignore this if you aren\’t a robot.’ It wasn’t a joke. It was a disaster. I felt a cold pit in my stomach that stayed there for three days. My boss didn’t fire me, but the silence in our Slack channel the next morning was louder than any screaming match could have been.
That is the reality of automation that the ‘productivity gurus’ on Twitter don’t tell you. They make it sound like you just click three buttons and suddenly you’re sipping margaritas while a bot does your data entry. It’s a lie. Or at least, it’s a half-truth. You can absolutely automate your entire workflow without touching a single line of Python or Javascript, but you’re going to break things. You’re going to feel stupid. And you’re going to spend a lot of time fixing things that weren’t even broken to begin with. But once it works? It’s the closest thing to magic I’ve ever found in a boring office job.
The part where I tell you that Notion is a trap
I know people will disagree with me here—actually, I know people will want to hunt me down for saying this—but Notion is the absolute worst place to start if you want to automate your life. I hate it. I really do. I’ve tried to love it, but it’s a bloated, slow, aesthetic-obsessed mess that encourages you to spend four hours ‘organizing’ your workspace instead of actually doing the work. It’s digital lint. People spend more time picking out the perfect icon for their ‘Project Tracker’ than they do tracking projects. If you want to automate, you need tools that are invisible, not tools that require a 45-minute YouTube tutorial just to figure out how to make a database.
What I mean is—actually, let me put it differently. You don’t need a ‘system’ that looks pretty. You need a pipe. You need data to move from Point A to Point B without you having to copy-paste it. I spent 214 minutes in a single week—I tracked this with a stopwatch in October—just moving names from an Excel sheet into our CRM. That is nearly four hours of my life I will never get back. Four hours of clicking. If you’re doing that, you’re not a worker; you’re a bridge. And bridges don’t get promoted.
Automation isn’t about being fancy; it’s about being lazy enough to refuse to do the same thing twice.
The only three tools you actually need
Forget the 50-tool lists. You only need three things to build a self-running engine. I call it the Golden Trio, though that sounds a bit too much like a marketing pitch, so let’s just call it ‘the stuff that actually works.’
- A Trigger: This is where it starts. An email, a Typeform submission, a new row in a Google Sheet.
- A Logic Gate: This is Zapier. I know people love Make.com because it’s cheaper, but Make’s interface looks like a neon spaghetti factory. It’s confusing for the sake of being confusing. I stick with Zapier even though I paid $84 last month for it. It’s expensive, and I hate their pricing tiers, but it works.
- A Destination: Where the data goes. Slack, your email, a task manager like Todoist (which is infinitely better than Notion, don’t @ me).
Anyway, I was talking to a friend who works in HR at a mid-sized firm—let’s call it ‘Generic Corp’—and she was complaining about how she spends her entire Monday manually sending ‘Welcome’ emails to new hires. I set up a simple Zap for her: Typeform entry triggers a Gmail draft. It took 12 minutes. She cried. Literally. That’s the power of this stuff when you stop trying to make it complicated.
How to map a workflow without losing your mind
Don’t start in the software. This is where everyone messes up. They open Zapier and start clicking around and get overwhelmed by the 5,000 integrations. I did this for six months and accomplished nothing. Now, I use a piece of paper. Or a whiteboard if I’m feeling performative. I draw a box for the ‘Input’ and a box for the ‘Output.’ If there’s a step in the middle that requires a human to make a decision, I draw a diamond.
I might be wrong about this, but I think most people’s jobs are actually just 4-5 of these boxes repeated over and over. If you can’t draw it on a napkin, you can’t automate it. I tried to automate my entire morning routine once—including my coffee maker and my smart lights—and I ended up sitting in the dark with no caffeine because the API for my toaster changed. Total waste of time. Stick to the boring stuff. Automate your invoices, your meeting reminders, and your file naming conventions.
Here is a specific example: I tracked my sole-wear on six pairs of boots over three winters (I’m obsessive about gear, okay?) and I used a simple automation to ping me every 100 miles of walking to check the heels. I used a Google Form I could hit on my phone, which sent the data to a Sheet, which calculated the mileage. It sounds nerdy because it is, but I haven’t had to get a full resole in two years because I catch the wear early. That’s 300 dollars saved because of a ‘no-code’ script. It’s not just for work.
The ‘Unfair’ Take: Why I refuse to use Airtable
I’m going to say it: Airtable is just Excel for people who want to feel like they’re building an app. I refuse to recommend it to my friends. It’s fine, I guess, but it’s another one of those tools that sucks you into a black hole of ‘customization’ that doesn’t actually produce anything. I’ve seen teams spend three weeks building an Airtable base that does exactly what a Google Sheet with one VLOOKUP could do. It’s pretentious software.
What you actually want is simplicity. If a tool has a ‘Gallery View’ that you spend more than five minutes looking at, it’s a distraction. Automating your workflow is about removing steps, not adding a prettier interface to the steps you already have. I used to think I needed the most powerful tools. I was completely wrong. I needed the ones that stayed out of my way.
One time at my old job at a logistics firm, I built this massive, interconnected system using five different ‘no-code’ tools. It was a masterpiece. Then, the guy who took over my role accidentally deleted one folder in Google Drive and the whole thing collapsed like a house of cards. He didn’t know how to fix it because it was too complex. That was a huge wake-up call. If you build a system that only you can understand, you haven’t automated your job—you’ve just built a prison for yourself.
Keep it simple. One trigger. Two actions. Max.
Stop thinking and just break something
The biggest hurdle isn’t the ‘code’—there is no code. The hurdle is the fear of that 3 AM email disaster I mentioned earlier. You’re going to mess up. You’re going to send a ‘Hello [First_Name]’ email to a CEO. It’s fine. The world keeps spinning. The efficiency you gain on the other side of that embarrassment is worth the occasional glitch.
I still haven’t figured out how to automate my actual deep work—the writing, the thinking, the real stuff—and I don’t think I want to. There’s something scary about the idea of a life that’s 100% efficient. But the data entry? The scheduling? The ‘just checking in’ emails? Give that to the robots. They don’t get bored, and they don’t need coffee.
Is it possible to automate too much? I don’t know. I’m still trying to find that line. But I do know that I haven’t manually moved a row of data in fourteen months, and I’ve never been happier.
Just don’t use Notion. Seriously.