The Agent Deployment Co.
agentsslackclaude-tag

I Want a Spreadsheet Guy

Trying to build a spreadsheet guy out of AI budget instead of headcount, and taking a big L

Mando Escamilla·

I’ve always wanted a spreadsheet guy (gender-neutral).

Like, a guy that I could say “hey, make me a spreadsheet that tracks all my EBITDAs” or “hey pivot me tables, YARRRRR” — you know, cool business guy kind of stuff. I’ve long felt what was holding me back from being a cool business guy (besides the fact that vests make my tummy hot and my arms cold) was not having a spreadsheet guy.

After googling “how much does a spreadsheet guy cost” I remembered that I don’t have any spreadsheet guy budget. But like every hopeful cool business guy nowadays, I’ve got some ✨ AI budget ✨ soooo to the Claude-mobile!

LinkedIn leads me to believe that I’m the last person on the planet without an army of AI agents running every part of their company so how hard could it be to make a spreadsheet guy?

Before jumping in, here’s my goals:

  1. I wanna talk to spreadsheet guy in Slack — if I had a real spreadsheet guy I’d just shoot them a quick message in Slack to get me a spreadsheet on my desk by the end of the day or whatever, so that’s how I want to interact with AI spreadsheet guy
  2. other folks at ADC can talk to spreadsheet guy — I’m not greedy, sharing is important
  3. spreadsheet guy is available 24/7 or at least close to it — it shouldn’t run on my laptop
  4. making spreadsheet guy should NOT be an engineering project — I’m an engineer but I don’t have engineering resources to build this guy

Enter Dan

So I asked Claude to whip me up an agent called Dan and after some fits and starts, I had a nice little agent directory in Github:

The README for Dan The Spreadsheet Guy: an agent definition plus three markdown skills — spreadsheet-qa, spreadsheet-create, and spreadsheet-update — and a Setup section noting Dan needs the Google Drive connector connected and enabled, with no other configuration or code.
An agent, three skills, zero code.

Uh oh, Google Drive connector? Eh, it’s probably fine1.

Dan’s alive!!! Let’s test him.

Claude answering 'how many posts are we tracking in the spreadsheet' by routing to Dan, who reports 202 posts and comments in a sheet called ATTENTION (for Science), broken out by tab: Hayes Posts 23, Jerry Posts 176, Mando Posts 3.
Three whole posts. Don’t look at my Posts please.

Dan seems very alive and well. Let’s now focus on goal 1: talk to spreadsheet guy in Slack.

Claude answering 'how can i access this agent in slack?' with: You'd get to Dan in Slack through Claude Tag, Anthropic's Slack integration (Team and Enterprise plans). There are two routes, and which one you want depends on who should be able to talk to Dan.
Claude Tag or bust.

Aw beans, I wasn’t trying to use some Claude-specific stuff in here. Isn’t there any other way???

Claude answering 'is there any other way to access dan in slack besides using Claude tag?' with: Officially, no. The unofficial route is a self-hosted Slack bot on the Agent SDK — a small Bolt/Events API app that catches mentions and pipes them through the SDK's agent loop, which is a service you build, host, and maintain.
“A service you build, host, and maintain” is a lot of words for “no.”

Well, I guess that’s something but it violates goal 4: spreadsheet guy is not an engineering project. Claude Tag it is!

Beta ain’t just a coefficient

I installed Claude Tag in Slack and paired it2. This step was harder than I thought and if I wasn’t a Slack and Claude admin, I would’ve been stuck — I woulda had to call IT or engineering and that’s exactly what I’m trying to avoid here. I wish I would’ve read the Before you start docs before I started because if I had I probably wouldn’t have started. A couple of highlights about Claude Tag:

  • isn’t available if you have ZDR (zero data retention) enabled
  • Claude Owner access required for setup
  • Slack admin access required for setup
  • Usage Credits enabled and used for all access

That’s a lot of requirements to get Dan chatting in Slack, but we’re gonna just wave our hands here because this is already harder and taking longer than I thought it would and I only have one life to live.

Once paired, I needed to connect Google Drive. Thankfully, there’s a little connect button in the Claude desktop admin UI that I could click.

The Connect Google Drive dialog in the Claude admin UI, on the Advanced tab, with an MCP Connector credential pointing at drivemcp.googleapis.com. A yellow warning reads: Please ensure you are not using your personal Google Drive account. We recommend creating a dedicated Google Drive account for Claude to use.
Told twice, in two different places, not to use my personal account.

At least it tells me TWICE that I shouldn’t use my personal Google Drive account. So I went into to Google console and made a new robot service account, saved the credentials so others could access it securely, locked it down so it could only access to the spreadsheets I wanted it to access, all that.

Then, of course, clicking the Sign in button didn’t quite work.

A yellow warning toast in the Claude desktop app reading: Popup was blocked. Allow popups for this site and try again.
Allow popups for this site, in the desktop app, which is not a site.

Again, how do regular folks deal with stuff like this? I mean, I knew that the admin UI was also available via the browser, so I logged in with Safari and was able to get around that error but I don’t know how clear and obvious that would be to most folk.

At long last, my Guy

Finally, I had my Guy. It was supposed to be @Dan, but that’s not how Claude Tag works so I asked @Claude instead about my serious business spreadsheets.

A Slack thread. mando asks @Claude 'what spreadsheets can you see' and Claude, tagged AGENT, replies that it listed the spreadsheets in the connected Google Drive — 4 found — and explains it routed the request to the Dan the Spreadsheet Guy agent.
My Guy, in Slack, seeing my spreadsheets.

Not bad! Let’s see if it can read a spreadsheet (not just list them).

A Slack thread. mando asks to list all the ideas in the ideas tab, and Claude replies that it found the Ideas tab in ATTENTION (for Science) and read all 8 rows.
Found the right sheet, found the right tab, read the rows.

I mean, come on! Good job, guy! Granted, that probably woulda taken forever if there were a bunch of sheets in this workspace but maybe it would’ve done something different in that case. Regardless, Dan/Claude found my super secret post tracking spreadsheet and read it no problem. Bring it home, Dan/Claude — update that beautiful spreadsheet!

A Slack thread. mando asks @Claude to add a 'create a spreadsheet guy' idea to the Ideas tab and assign it to him. Claude replies that it verified the tab — 8 rows, next free row is 10 — but couldn't write it, nothing was changed in the sheet, because the Google Drive connector can only rename or move a file.
“Nothing was changed in the sheet.”

Dan/Claude nooooo! Betrayed at the finish line! It turns out what it can do is download the file as a csv, add the row, and upload it back as a new file which I suppose technically works but that’s not what I want. I don’t want a row-adder — I want a spreadsheet guy.

Win, lose, or draw?

Your boy took a big L on this one. Let’s review our goals:

  1. talk to spreadsheet guy in Slack — ✅
  2. other folks at ADC can talk to spreadsheet guy — ✅ (didn’t test but should be fine)
  3. spreadsheet guy is available 24/7 or at least close to it — ✅ it’s running somewhere not on my machine (where? who knows!)
  4. making spreadsheet guy should NOT be an engineering project — ❌ lotta IT work had to occur to make Dan happen

The astute reader will notice that there was a very important missing goal: able to do cool spreadsheet work beyond reading and copying + slight appending. The built-in Google Drive connector in Claude just isn’t up to task for the stuff I want Dan to be able to do.

So, if I want a real Dan, it looks like it’s going to need real engineering work with real engineering cost, which is also budget I don’t have. Guess I’m back to editing spreadsheets myself like some kind of spreadsheet farmer.

Footnotes

  1. It was not fine. ↩

  2. This requires both a Claude Admin AND a Slack Admin. ↩

Ready to deploy your own agents?

Book a discovery call and let's talk through your use case.

Book a Discovery Call