The challenge
- Scattered sources. Bookings in Amenitiz, Excel exports, website traffic, each in its own corner, no common format.
- 100 % manual consolidation. Fetch, open, retype the numbers into a spreadsheet, every week, for every property.
- No reliable real-time view. Actual revenue only showed up days late.
Our response
A system that triggers the reports on its own, downloads the exports without intervention, parses the Excel files, computes revenue, extras and nights, fetches website traffic, then injects everything in the right place in Google Sheets with status tracking. Géraldine opens her spreadsheet: everything is already consolidated.
Amenitiz
n8n
Excel parsing
Google Sheets
+400h
freed per year, i.e. 8 hrs every week reinvested in the portfolio
0
manual re-entry, data consolidated and reliable continuously
≈ 19 k€
of cost recovered per year, time saved valued at loaded hourly cost
The system runs autonomously. No more exports to open, no more copy-paste: one spreadsheet, always up to date, to base decisions on. Financial gain estimated at a €45/h loaded rate.