About the client
Investra is a real estate platform that lists projects from developers across multiple markets. Each project in the Investra admin holds its properties and units, and every unit has a price and an availability status.
The challenge
One file, updated in place.
Developers keep each price list in a single file and update it in place. The file can be a PDF, an Excel sheet, a Google Sheet or an image, laid out differently from one developer to the next and sometimes written in local languages. Every time a unit sold or a price changed, the team had to notice that the file was updated, compare it with the previous version and fix the affected units by hand. A change nobody noticed stayed wrong in the admin until the next check, and a file can change at any time without anyone being told.
The solution
A loop that runs itself.
We built a web app and an API that take over the whole loop. A user adds a document by pasting the link to the price list and picking the Investra project it belongs to. From then on the system checks the file every two hours. When the file changes, AI reads the type, price and availability of every unit, and the system updates the project to match: it creates new units, updates changed ones and removes units that dropped off the list. Units added by hand in the admin, or by another price list, are left alone. If a document fails three runs in a row, the system pauses it and emails the team.

What we did
01
Download and compare
From a public link or Google Drive. An unchanged file never reaches the AI step.
02
Prepare the pages
PDFs are split into pages and images resized for the model.
03
Extract with AI
OpenAI reads every unit against a fixed schema: type, price and availability.
04
Validate and sync
Units are validated, grouped by unit type and synced through Investra’s import API.

Ownership
Only its own units.
The system records which units each price list created, so it only ever changes or deletes its own units. Units added by hand in the admin, or by another price list, stay exactly as they are. Removing a document removes exactly the units it created, and nothing else.

The results
Nobody tracks price list files anymore. A change in a developer’s file reaches the Investra admin within about two hours, and the team only steps in when the system emails them about a document it had to pause.
~2 h
From a change in the price list to the Investra admin
4
File formats read: PDF, Excel, Google Sheets and images
0
Price list files the team has to track by hand

