Automating Repetitive Work

Marcus was building the same report every Monday morning for two years

Marcus is a marketing manager at a SaaS company. Every Monday at 8 AM, he opens five browser tabs: Google Analytics, HubSpot, the ad dashboard, the social media dashboard, and a shared Google Sheet. He copies numbers from each one. He pastes them into a slide deck template. He calculates week-over-week changes by hand. He writes a three-paragraph summary.

It takes three hours. Every. Single. Week.

One Tuesday, Marcus stayed late and spent 90 minutes setting up an AI-powered workflow. He built a prompt template that takes raw numbers and generates the summary. He set up a simple automation that pulls the data into one place. He created a prompt that formats the slide deck text.

The next Monday, the report took ten minutes. Marcus spent the other two hours and fifty minutes on strategy work his boss had been asking about for months.

That three hours wasn't just time — it was Marcus's best morning energy, burned on copy-paste. AI gave it back.

Time vampires: the tasks that drain your week without adding value

A time vampire is any task that:

• You do repeatedly (weekly, daily, or multiple times per day)
• Follows roughly the same steps every time
• Doesn't require deep creative thinking or complex judgment
• Would take the same amount of time whether it's your first year or your tenth

Think of it like a dishwasher. Before dishwashers, you spent 30 minutes after every meal scrubbing plates. The dishwasher didn't eliminate the work entirely — you still load it, add soap, unload it. But the actual scrubbing? The repetitive, low-skill, time-consuming part? That runs without you.

AI automation works the same way. You still set it up, review the output, and make decisions. But the repetitive middle part — the scrubbing — happens without you.

The time vampire identification matrix

Three levels of AI automation

You don't have to build a complex system. Start simple and level up.

Level 1: Template-based automation (start here)

You create a reusable prompt template with blanks that change each time.

Example — weekly report summary:

You are a marketing analyst writing a weekly performance summary.

Here are this week's numbers:
- Website visits: [PASTE NUMBER]
- New leads: [PASTE NUMBER]
- Conversion rate: [PASTE NUMBER]
- Ad spend: [PASTE NUMBER]
- Revenue attributed: [PASTE NUMBER]

Last week's numbers for comparison:
- Website visits: [PASTE NUMBER]
- New leads: [PASTE NUMBER]
- Conversion rate: [PASTE NUMBER]
- Ad spend: [PASTE NUMBER]
- Revenue attributed: [PASTE NUMBER]

Write a 3-paragraph executive summary highlighting:
1. The biggest win this week
2. The biggest concern
3. One recommended action for next week

Use a professional but conversational tone. Include the
week-over-week percentage change for each metric.

Save this template. Every Monday, paste in the new numbers. Done in 2 minutes instead of 45.

Level 2: Batch processing (handle 100 tasks at once)

Instead of running one thing through AI at a time, you batch them.

Examples of batch processing:

The key insight: AI doesn't get tired. Processing one item or fifty items takes roughly the same mental effort from you — you just paste more data.

Level 3: Simple workflows ("When X happens, AI does Y")

This is where you connect AI to triggers so it runs automatically.

Tools that make this easy (no code required):

Estimating your time savings

Here's a simple formula to calculate the ROI of automating a task:

Time saved per month =
  (Manual time per task × Frequency per month)
  − (Automated time per task × Frequency per month)
  − Setup time amortized over 6 months

Realistic time savings by automation level

The automation priority matrix

Not every time vampire deserves automation. Use this to prioritize:

• Top-right (high frequency, high time): Automate first. This is where Marcus's Monday report lived.
• Top-left (low frequency, high time): Automate if the setup is easy. Quarterly reports fit here.
• Bottom-right (high frequency, low time): Consider templates. Quick replies, status updates.
• Bottom-left (low frequency, low time): Don't bother automating. The setup cost exceeds the savings.

Building your automation habit

The biggest mistake people make isn't failing to automate — it's automating one thing and then going back to doing everything else manually. Make it a habit:

1. The Friday review: Every Friday, spend 10 minutes asking: "What did I do this week that felt like a waste of my skills?" Write it down.
2. The Monday build: Every Monday, spend 15 minutes automating one thing from your Friday list. Even if it's just saving a prompt template.
3. The compound effect: After 3 months of this habit, you'll have 12+ automations running. That's easily 10-20 hours per month reclaimed.

Back to Marcus's Monday morning

He still opens the same five tabs. He still pastes in the same categories of data. But the part that used to take three hours — the calculations, the narrative, the deck text — now takes ten minutes.

He didn't change jobs. He didn't hire anyone. He spent 90 minutes on a Tuesday solving a problem that had been draining his best morning energy for two years. That's the whole point.

Key takeaways

• Time vampires are tasks you do repeatedly that follow the same steps. If you can explain it to a new hire in 5 minutes, AI can probably do it.
• Start with templates (Level 1), not workflows (Level 3). A saved prompt template that you paste numbers into saves 50-70% of the time and takes 15 minutes to set up.
• Batch processing is your secret weapon. Instead of running one task through AI, run fifty. AI doesn't get tired.
• Build the habit, not just the automation. The Friday review + Monday build rhythm compounds into 10-20 hours saved per month within a quarter.