home / use cases / data, spreadsheets and reporting / cross-system-sync

Cross-system sync without the middleware

When one system fires a webhook — a new order, a signed contract, an updated customer — an Aivell catches it, looks up the matching record, and writes the data correctly into the other system's database or sheet. Exceptions are flagged to a human, and existing records are never overwritten.

Watch the demo

starts when: Your shop fires a webhook — a new order just landed

The problem

Two systems, no bridge, one human in a swivel chair. The order exists in the shop; someone retypes it into the ERP. The contract is signed in one tool; someone updates the customer file in another. It’s the same record, keyed twice, with all the drift that implies — a mistyped account code here, a skipped order there, discovered weeks later when the numbers won’t reconcile.

The integrations exist, in theory. In practice they mean a cloud connector with your customer data flowing through a third party, or a custom script nobody dares touch since the developer left. So the retyping stays.

How your Aivell does it

  1. The webhook lands on the box. Your shop, form tool or signing service calls a local address the moment something happens. A guardrail accepts only signed calls from that source — stray traffic is dropped and logged.
  2. The record is understood, not just copied. The Aivell reads the payload and looks up the customer in the target system — by email, then VAT number — the way a clerk would check before booking.
  3. The write is done properly. Known customer, straight insert under the right account code. Foreign currency converted at your booked rate with the original kept in the notes. The rules are your sentences, not a mapping diagram.
  4. Exceptions go to a person. A brand-new customer, a failed insert after one retry — Jonas gets the payload and the story, and nothing is silently lost.
  5. The day stays visible. Every synced order also lands on the operations sheet, so the running list needs no second system to check.

The guardrail worth underlining: the database tool can insert but can never update or delete. The sync physically cannot trample a record that already exists — a property no flowchart connector gives you, enforced on the tool itself.

The chore, as you'd write it.

No flowcharts, no code — a chore is just a message to your Aivell, in your own words. It shapes it into a solid, guarded procedure and follows it to the letter. This one:

Giulia Aivell · sync shop orders to erp ● active

when the shop sends a new-order webhook, read the payload

look the customer up in the ERP by email address, then by VAT number

known customer — insert the order under their existing account code

new customer — create the record, but flag it for Jonas to verify

currency other than euro? convert at the booked rate, keep the original amount in the notes

append a line to the operations sheet so the day's list stays complete

if the ERP insert fails, retry once, then email Jonas with the full payload

never update or delete existing orders — inserts only

You
Got it — I'll start right away, and check with you whenever something needs a human.
Giulia Aivell

The tools it uses.

Connected with single-click passkeys — no copied tokens, no OAuth hell.

Webhooks catches events from your other tools
Database writes the order into the ERP, inserts only
Spreadsheets keeps the day's operations list current
Email hands the exceptions to Jonas

Sensible guardrails.

Every tool can be limited to exactly what this chore needs. For this one, you might set:

Webhooks Accepts only signed calls from your shop's address. Anything else is dropped and logged.
Database May insert into the orders and customers tables. Updating or deleting existing rows is blocked at the tool.
Email Writes only to Jonas and the operations list; no mail ever leaves the domain.

Questions, answered.

Isn't this what cloud glue tools already do? +

They connect the same boxes, yes — through their cloud, with your data in transit through their servers, and rules built in a flowchart editor. Here the glue runs behind your firewall, writes to your database directly, and the rules are sentences you can read aloud.

What happens when the target system rejects a record? +

One retry, then a human. Jonas gets the full payload and the error, nothing is silently dropped, and the audit trail shows every attempt. The order is never half-booked.

Does our order data transit anyone else's servers? +

No. The webhook arrives at the box, the lookup and the insert happen over your own network, and the reasoning runs onboard. The path from shop to ERP never leaves the building.

Can it sync in both directions? +

Yes — as a second chore in the opposite direction, with its own trigger and its own guardrails. Keeping them separate keeps each side's rules simple and auditable.

Related.

What is an Aivell?

An Aivell is an on-premise AI colleague: a small box that plugs into your network, runs its own AI onboard and takes the repetitive work off your desk. Prompts, documents, data — nothing ever leaves your office. Unplug the internet: it keeps working.

You describe each task as a chore, in plain language. Your Aivell turns it into a solid, guarded procedure and runs it in the background — with guardrails on every tool, a complete audit trail, and approvals in your hand when you want them. One-time setup, fixed monthly fee. No tokens, no overages.

Watch the demo

onboard inference · air-gapped · fixed monthly fee