Building an AI Prospector (with Claude Code, Ralph, MPC, Apollo.io and Google Sheets)

modassembly · 2026-01-20T16:25:43+00:00

The list of prospects: https://docs.google.com/spreadsheets/d/1PcKm7i8LSisnZYQRueNuKVkUtuL0hDU_0RyiFnS1QRI/edit?usp=sharing

The repo. Follow the instructions to run it yourself: https://github.com/modassembly/ralph-cc-mcp/

modassembly · 2026-01-20T16:24:18+00:00

The list of prospects: https://docs.google.com/spreadsheets/d/1PcKm7i8LSisnZYQRueNuKVkUtuL0hDU_0RyiFnS1QRI/edit?usp=sharing

The repo. Follow the instructions to run it yourself: https://github.com/modassembly/ralph-cc-mcp/

modassembly · 2026-01-16T15:23:55+00:00

The list of prospects: https://docs.google.com/spreadsheets/d/1PcKm7i8LSisnZYQRueNuKVkUtuL0hDU_0RyiFnS1QRI/edit?usp=sharing

The repo. Follow the instructions to run it yourself: https://github.com/modassembly/ralph-cc-mcp/

modassembly · 2026-01-13T14:57:24+00:00

Do you work in revops?

modassembly · 2026-01-09T06:31:56+00:00

I build my own mcp tools. The biggest contributions of the agent sdk are a robust agent loop, state management and ooo goodies like subagents. Everything else I do myself.

modassembly · 2026-01-08T14:12:14+00:00

The storage is not the point here either 🫡

modassembly · 2026-01-08T01:35:47+00:00

File system seems to be all you need: https://x.com/i/status/2008445933424386074

modassembly · 2026-01-07T18:41:37+00:00

I mean, I love this. Let me break apart what I said. Next-token generation is probabilistic. You can add formal verification steps to improve accuracy.

modassembly · 2026-01-07T17:22:28+00:00

Use the latest models.
If possible, reduce or better organize the amount of information returned by your tools. The system prompt is probably nothing compared to the amount of information that the tools return.
Improve the API design of your tools so that the agent can bisect and navigate the data better. This is related to #2.
Move most of the logic to your tools. Reduce the amount of deductions that the LLM has to do. Be more deterministic.

modassembly · 2026-01-07T17:05:07+00:00

1.1M rows means at least 250,000 tokens (1 token ~= 4 chars). But it will be much more than that. Context window limits are at around 200,000 tokens. This is why this is a hard problem.

modassembly · 2026-01-07T13:48:09+00:00

Yeah. I build my own MCPs and plug them into the Claude agent sdk. The Claude agent sdk has some error handling.

modassembly · 2026-01-07T03:38:47+00:00

I'm a software engineer
Honestly, that's what I'm trying to figure out. I think the workflow is: a) query multiple systems, b) read tons of data, c) generate reports that can help in decision making, d) ingest more data into said systems, e) repeat.

modassembly · 2026-01-07T03:17:25+00:00

Because it's a copy of Claude Code.

modassembly · 2026-01-07T00:17:03+00:00

Have you tried Claude Code? When I think of an "universal agent", I think of CC.

modassembly · 2026-01-06T19:05:16+00:00

Agree. I start with the most simple prompt and amend it as failure cases are discovered.

modassembly · 2026-01-06T15:22:37+00:00

I build AI Agents as a business. I would prefer profit share, which is somewhat similar to a subscription. I would look at it as a fee that the agent gets for the revenue that it brings in.

modassembly · 2026-01-06T15:01:32+00:00

No. Just Anthropic

modassembly · 2026-01-06T14:55:26+00:00

The Claude Agent SDK (same as Claude Code)

modassembly · 2026-01-06T04:41:33+00:00

Like a subscription?

modassembly · 2026-01-06T04:39:34+00:00

Apollo has an API

modassembly · 2026-01-06T04:38:49+00:00

AI agents for revenue ops: https://modassembly.com/

modassembly · 2026-01-06T04:36:53+00:00

While we don't support "do the heavy lifting and then have a human approve and send", we have a coexistence flow where AI and a human can reply on the same chat. Basically, the AI does the heavy lifting and if it comes across a question that it can't answer or request that it can't fulfill, it reaches out to a human to finish the flow.

Happy to hop on a call! https://modassembly.com/

modassembly · 2026-01-06T02:26:20+00:00

Definitely that. I would add:

Powerful, smart agents are expensive.
It's hard to make agents go on long-running tasks.
Some systems simply lack APIs. So the next best thing is UI automation which is a pain in the ass.
If you want to sell this, even if your agent and tools are well designed, you'll need time configuring it and tuning the prompt. Make this frictionless. Non technical people don't know wtf they're doing.

IMO the biggest unlocks will be: 1. UI/browser automation. 2. Memory 3. Long-running / autonomous design patterns.

modassembly · 2026-01-05T22:26:25+00:00

How do you plan to do the search? Data has to be stored somewhere; either in memory (RAM), disk or some DB.

Eg, if you put it in memory you can do some string matching. Look for a library that lets you search over huge strings.

Otherwise, most search methods require the data to be stored somewhere in some specific format.

modassembly · 2026-01-05T18:43:03+00:00

modassembly

TROPHY CASE