PipeDuck · ArticlesFrançais

AI at the center or AI as the glue: two ways to build a harness

Two architectures dominate AI projects. In the first, an agent receives a goal and access, and decides everything; in the second, the process is drawn and AI works only at the steps that need it. We measured the gap on a common case, a daily Excel report, and placed PipeDuck against Claude Code, n8n and Zapier.

For most tasks, the model no longer makes the difference

For most tasks, what a company expects from AI comes down to precise, repeated operations: linking two pieces of information, summarizing an exchange, correcting a text, sorting signal from noise in an inbox. Almost every recent model does these well; picking one over another changes almost nothing.

The real choice lies elsewhere. You can aim wide: real, reliable time savings for most teams, on tasks that come back every day. Or you can aim high: hand the work of your sharpest experts to more autonomous agents, and accept that security goes from near-certain to uncertain. The first choice pays more across a whole company, without giving anything up on security. It is the one PipeDuck serves.

Figure 1
A reliable gain for most teams beats a feat for a few experts
Reliability and security Share of the company that benefits Most tasks Link, summarize, correct, sort signal from noise A real gain for most teams, with nothing given up on security Automating the experts More autonomous agents on the most specialized work A spectacular gain for a few, and security that slips
Reliability and security Share of the company that benefits Most tasks Link, summarize, correct, sort signal from noise A real gain for most teams, with nothing given up on security Automating the experts More autonomous agents on the most specialized work A spectacular gain for a few, and security that slips
Conceptual diagram, no data or scale.

It still takes an architecture that makes these tasks reliable everywhere. That is where harnesses, everything around the model, split into two families.

Two ways to build a harness

In the first family, AI sits at the center. You give it a goal and access; it explores, decides on its calls, reads what comes back and starts again until it reaches its goal. Coding agents work this way. It is the right architecture when the task is open-ended and a specialist reviews the result, provided the specialist runs the agent on a machine with tightly restricted access. In many companies, developers no longer have write access to production databases, and sometimes not even read access, to prevent leaks; the agent, working with their rights, inherits those limits.

The second family, PipeDuck’s, reverses the relationship. The process is drawn, and each step takes the form that suits it: a script, cheap and deterministic, so reproducible and reliable; an AI step for the complex cases a script handles badly, or for low-stakes decisions; a person for the big decisions, and to carry the responsibility for them. At design time, AI helps turn your ideas into steps and connect them: that work is paid for once, and a person reviews it. At run time, it only works in the steps that belong to it, with the model and tools chosen for each. Code calls AI more than AI calls code.

Figure 2
Two ways to build a harness: AI at the center, or AI as the glue
AI at the center One agent, broad access AI as the glue A drawn process Customer DB Mailbox Files ERP Web AI The model TriggerEmail received ScriptFind the order AIDraft the reply ApprovalA manager reviews ActionSend the reply Design AI turns your ideas into steps and connects them AI decides every call. Code calls AI, at a single step.
AI at the center One agent, broad access Customer DB Mailbox Files ERP Web AI The model AI decides every call. AI as the glue A drawn process TriggerEmail received ScriptFind the order AIDraft the reply ApprovalA manager reviews ActionSend the reply Design AI turns your ideas into steps and connects them Code calls AI, at a single step.
On the left, AI calls the code. On the right, code calls AI, in the step that belongs to it; the design AI only works upstream, turning your ideas into steps and connecting them.

The daily Excel report, in both architectures

Every morning, an export of orders lands in an Excel file, and someone has to pull out revenue by region, the best-selling products and the anomalies to deal with.

In the first architecture, an AI receives the file every day, reads all of it and calculates. We ran the test on an export of 1,000 orders containing eight randomly placed anomalies, with Claude Opus 5 set to its maximum reasoning effort and no calculation tool. The expected report contains 23 results: total revenue and revenue for each of the six regions, the five best-selling products with their amounts, the number of orders for each of the four statuses, the average basket, and the list of anomalies, which must find all eight without inventing any. All 23 are correct. The work took 16 and a half minutes and nearly 116,000 tokens, or about $3.24 at the public API price1. The model got it right because it redid every calculation along two independent paths, which is also what made it expensive.

In the second architecture, AI is used once. PipeDuck’s build assistant helps write the report’s rules, a script applies them, and a person reviews that script before it runs. After that, every morning, the same report comes out in 6.5 milliseconds, with no tokens, and without any model reading customer data.

Figure 3
The same report, correct on both sides: 16 minutes and about $3 on one, 6 milliseconds on the other
AI aloneClaude Opus 5, maximum effort, no code
ScriptPython, rules written once
Accuracy
23 / 23
23 / 23
Duration
16 min 30 s
6.5 ms
Tokens produced
115,871
0
Cost per run
≈ $3.24
$0
Over 250 working days
≈ $810
$0
Orders read by a model
1,000
0
Measured on September 14, 2026, over one run. Accuracy: the report’s 23 results compared one by one with the exact calculation (7 revenue figures, 10 for the five best-selling products and their amounts, 4 counts by status, the average basket, the list of anomalies). Cost per run estimated for a standalone call from the measured tokens, at Opus 5’s public price ($5 per million input tokens, $25 per million output tokens)1. Method at the end of the article.

Over 250 working days, the first architecture costs about $810 for a single report, and every morning keeps a chance of error. Our test was right once; it says nothing about the other 249 days. And an AI that succeeds on 99% of its runs gets through a whole year without an error only about one time in twelve. Verified rules return the same result every day.

Figure 4
At 99% success per run, an error-free year happens only one time in twelve
Verified rules (script) AI, 99.9% per run AI, 99% per run AI, 95% per run
0%25%50%75%100% 050100150200250 Working days of runs (250, about one year) one month 100%78%8%0%
0%25%50%75%100% 0125250 Working days (250, about one year) one month 100%78%8%0%
Show the values
Days of runsVerified rulesAI 99.9%AI 99%AI 95%
1100%99.9%99.0%95.0%
21 (one month)100%97.9%81.0%34.1%
63 (one quarter)100%93.9%53.1%3.9%
125 (half a year)100%88.2%28.5%0.2%
250 (one year)100%77.9%8.1%0.0%
Calculation: the probability that none of k runs goes wrong, if each one succeeds with probability p, independently of the others (p to the power k). The values of p are assumptions, not measurements. For reference: on τ-bench (2024), the best agents of the time succeeded on fewer than half of the tasks, and on fewer than a quarter eight times in a row in retail2.

Compared with Claude Code, n8n and Zapier

Claude Code, which we use ourselves and with which we ran this test, is an excellent harness, for code: an agentic tool that reads a codebase, edits files and runs commands, within limits set by permissions and by an operating-system sandbox3. AI is at the center there, which suits an open-ended task reviewed by a developer. A business process that comes back every day, run by people who do not program, calls for the opposite architecture.

n8n and Zapier are the closest competitors, and they do a lot well: AI steps where you choose the model, human approvals, and credential sharing that does not reveal the secret4, 5. Our differences lie elsewhere. In PipeDuck, every version of a script is reviewed before it can run: an AI-written summary of the changes and security notes, then a person’s approval; in n8n, that review goes through a pull request at the Git provider, outside the tool, on the Business and Enterprise plans4. And PipeDuck is hosted in France or installed on your premises, with your own model if you want, whereas Zapier only exists as a cloud service5. Above all, the paths differ: n8n and Zapier were born to connect applications and added AI to that; we started from a company’s rules and from reviewed code, and placed AI between the two.

To see how PipeDuck applies these principles:

The 3-minute presentation Create a demo workspace

How the test was run

A synthetic export of one day: 1,000 orders, 11 columns, a CSV in French format, eight anomalies drawn at random (missing customers, duplicates, a negative quantity). Six written rules, identical for the AI and for the script. Each answer is compared with the exact calculation in 23 checks. AI: Claude Opus 5, maximum reasoning effort, in a Claude Code session, with no code execution; tokens read from the session log and priced at the public API rate1. Cost measured in the session: $6.30, of which $1.52 came from re-reading the conversation’s context; the cost of a standalone call is estimated at $3.24. A single run: the test does not measure consistency from one day to the next. Script: Python, standard library.

Sources

  1. Anthropic, Claude API pricing, checked on September 15, 2026.
  2. S. Yao et al., “τ-bench: A Benchmark for Tool-Agent-User Interaction in Real-World Domains”, arXiv 2406.12045, June 2024.
  3. Claude Code documentation: overview and sandboxing, checked on September 14, 2026.
  4. n8n documentation: agents, human approval of tool calls, credential sharing, environments and source control, n8n Assistant, checked on September 15, 2026.
  5. Zapier: AI models, Human in the Loop, sharing app connections, hosting (answer from the Zapier team), checked on September 14 and 15, 2026.