Multi-system operations pipeline
The problem
A team receives work through email and forms, re-keys it into two internal systems, and tracks status in a shared spreadsheet. The process is slow, the spreadsheet drifts out of date, and nobody can answer where a given request is without asking someone.
The approach
Put a single intake in front of every channel and make the pipeline the source of truth. Incoming requests are normalised into one schema, validated, enriched where a model can reliably extract structure from unstructured text, then written to the downstream systems through their APIs. Anything ambiguous is queued for a person rather than guessed.
What gets delivered
- Unified intake across email, web forms and API
- Validation and structured extraction before anything is written
- Exception queue for cases needing human judgement
- Full execution log — every run, its inputs and its result
Outcome
Re-keying disappears, status is answerable from one place, and failures surface as alerts instead of being discovered weeks later.
Stack
- Python
- FastAPI
- n8n
- PostgreSQL
- Docker