3 min read

I gave my agent my worst task. Here's what happened.

Everyone has that one task they dread every week. I handed mine to an AI agent and watched. This is the play-by-play.

Everyone has the task. The one that sits on your to-do list all week. The one you push to Friday afternoon, then push to Monday, then finally grind through on a Tuesday night when you can't avoid it anymore.

For me, it was reconciling client data across three spreadsheets that never quite matched. Different column names, different date formats, duplicate entries, missing rows. Every week, the same pain.

I gave it to my agent. Here's what happened.

The handoff

I opened the folder with the three spreadsheets, started Claude Code, and typed:

"These three spreadsheets track the same clients but they're all formatted differently. Reconcile them into one clean master list. Flag any conflicts where the data doesn't match."

That was the entire prompt. Plain English. No technical instructions.

What I expected

Honestly? I expected it to fail. Or to produce something I'd need to redo from scratch. I've been burned by "AI tools" before that produce confident-sounding garbage.

What actually happened

The agent read all three files. It identified that the client names were spelled slightly differently across sheets (one had "Robert," another had "Bob," the third had "R. Johnson"). It asked me: "These look like the same person. Want me to merge them under one name?"

I said yes, use the full name.

It found 4 duplicate entries, 2 date conflicts (one sheet said a meeting was on June 3, another said June 4), and 6 clients who were in one sheet but missing from the others.

It produced a single clean spreadsheet with all the data merged, the conflicts flagged in a "Notes" column, and a summary at the top: "47 clients total. 4 duplicates merged. 2 date conflicts flagged for your review. 6 clients added from sheets where they were missing."

How long it took

The agent finished in about 3 minutes. My usual time for this task: 2-3 hours.

What I learned

The agent didn't do anything magical. It did exactly what I would have done: read the files, compare them, find the mismatches, merge the data. The difference is that it did it without getting distracted, without making typos, and without dreading the task for three days first.

The trust moment

The first time, I checked everything. Every merged row, every flagged conflict, every total. It was all correct.

The second time, I spot-checked a few rows. Still correct.

By the third time, I just reviewed the summary at the top and moved on with my week. That's when I realized: I didn't just save 2 hours. I saved the mental weight of having that task on my list.

Your worst task

Everyone has one. The expense reports. The client check-ins. The data cleanup. The document formatting. The file organization.

You know which one yours is. You thought of it while reading this.

It takes about an afternoon to set up an agent. It takes about one sentence to hand it your worst task. And it takes about 3 minutes to realize you should have done this months ago.

Ready to get your agent running?

One afternoon. Plain English. No technical knowledge required.

Start with Virgil