newerolder
q1rk  //  note

how to automate repetitive tasks, one evening

somewhere in your week there's an hour that repeats: the same renaming, the same copy-paste between two apps, the same reminder email written from scratch. you've done it so many times you've stopped noticing it's work.

that hour is the cheapest one you'll ever buy back. automating it doesn't take a programming background anymore - it takes knowing the three tool shapes and matching one to the task. that's the whole skill, and it fits in an evening.

worked example throughout: maya, who runs a small shop and every friday exports orders, renames the file, copies totals into a sheet, and emails a summary. forty minutes, every friday, forever - until tonight.

a row of dull grey gears with one phosphor-green gear turning on its own

step 1: catch the repeat offenders

for the next ten minutes, list every task you've done more than three times this month, exactly as it happens. maya's list:

  • export orders, rename the file to the date
  • copy three totals into the tracking sheet
  • write the same friday summary email with new numbers

the tell of an automatable task: same steps, same order, decisions you could explain to a new hire in one sentence. if it needs judgment at every step it stays yours; if it needs judgment at one step, automate everything around that step.

step 2: match the task shape to the tool shape

1
two apps need to talkweb apps passing data (form -> sheet, shop -> email) - that's automation software wiring services together, no code
2
your own computer repeats itselffiles, folders, renaming, clicks - that's your os's built-in automations or a small script
3
the task needs wordsdrafts, summaries, reformatting text - that's an ai assistant with a saved prompt you reuse

task automation software, in practice, means the first shape. the need is real for anyone whose work lives in web apps; the popular options, straight:

  • make.com - visual scenarios, generous free tier, the deepest logic (branching, filters). the lean pick if your automation has any "if" in it. (make.com)
  • zapier - the biggest app catalog and the gentlest start, priced up fast as tasks grow.
  • n8n - self-hosted and yours end to end, for when you'd rather own the machine than rent it - the same instinct as owning the rest of your stack.

for shape two, you likely already own the tool: shortcuts on mac, power automate on windows. for shape three, any of the major assistants works - the leverage is in saving the prompt, not picking the bot.

three pedestals holding the three tool shapes: linked arrows, a folder, a speech bubble

step 3: maya's friday, rebuilt

  • the export and rename - a shortcuts/power automate flow watches the downloads folder and renames any orders file to orders-2026-07-17.csv format. fifteen minutes to build.
  • the totals - a make.com scenario reads the new file from the folder, writes the three totals into the tracking sheet. twenty minutes the first time, including connecting the accounts.
  • the email - a saved prompt: "here are this week's totals: [paste]. write my friday summary in my usual format" - with last week's email pasted in as the format sample. two minutes every friday instead of fifteen.

friday now costs maya five minutes of checking instead of forty of doing. the automation isn't impressive to look at. it's just her hour, back, every week - about 33 hours a year from one evening of setup.

40 minmaya's friday, before
5 minafter one evening of setup
~33 hbought back per year

the rule that keeps it sane

automate the second time you notice the repeat, not the first - once is an event, twice is a pattern. and never automate a process you don't understand manually: the automation inherits every flaw of the process it copies, at speed.

when a task resists all three shapes, that's usually the signal it needs a person - or that it's two tasks wearing one name. split it and try again.

a clock face dissolving into particles that collect in a jar - the hour bought back

your hour

  • list this month's repeat offenders - ten minutes, no filtering
  • circle the worst one and name its shape: apps talking, computer repeating, or words
  • build just that one: connect the two apps, record the os automation, or save the prompt with a format sample
  • put a note in your calendar for next month: check what the automation did, then retire the next offender

faq

how do i automate repetitive tasks without coding?

match the task to a tool shape: automation software like make.com or zapier for web apps passing data, your os's built-in shortcuts for file and folder work, and an ai assistant with a saved prompt for anything made of words.

what tasks should not be automated?

anything you don't yet understand manually, anything needing judgment at every step, and anything you've only done once. automate the pattern, not the event.

is task automation software worth it for one person?

the free tiers of the major tools cover most one-person workloads, so the cost is an evening of setup. one recovered weekly hour pays that back in the first month - the same leverage argument as ai automation tools.

more in the notes.

all notes