Operating System for a Logistics Company in Prague
About the Company
A local logistics company specializing in urgent delivery of documents and parcels within Prague.
Timeline
✅ Delivered in 3 months
🔄 Ongoing support: 3–4 months
How We Solved It
1
Airtable as the Core
We used Airtable for the database, business logic, and interface.
2
Telegram Bot for Task Management
Built a Telegram bot to create and receive tasks instantly.
3
Centralized Transport Management
Implemented processes for vehicle handover and mileage tracking before each shift.
4
Coordinator Dashboard with Map
Built a real-time map showing tasks, drivers, and statuses for efficient coordination.
5
Automated Alerts and Dashboards
Set up Telegram notifications and dashboards with key performance metrics.
Before
After
Before
Before
After
After
To find out who was using which vehicle and handling which orders, people had to message in chats or call. Vehicle handovers were done verbally, without records.
All information is in one system. Before each shift, the driver logs mileage and vehicle condition, attaching a photo. Everything is recorded.
Before
To find out who was using which vehicle and handling which orders, people had to message in chats or call. Vehicle handovers were done verbally, without records.
After
All information is in one system. Before each shift, the driver logs mileage and vehicle condition, attaching a photo. Everything is recorded.
Tasks were assigned manually — through messages or calls. It took time and often caused mistakes.
Tasks are created automatically via the website or Telegram. It’s instantly clear what, where, and who is delivering.
Before
Tasks were assigned manually — through messages or calls. It took time and often caused mistakes.
After
Tasks are created automatically via the website or Telegram. It’s instantly clear what, where, and who is delivering.
To understand where the drivers were and the status of orders, the coordinator had to collect everything manually.
An admin panel was developed. The map shows real-time driver locations and statuses of all tasks — everything is visible at once.
Before
To understand where the drivers were and the status of orders, the coordinator had to collect everything manually.
After
An admin panel was developed. The map shows real-time driver locations and statuses of all tasks — everything is visible at once.
Drivers and coordinators often didn’t know about new tasks or updates.
Everyone receives automatic notifications in Telegram — nothing gets lost.
Before
Drivers and coordinators often didn’t know about new tasks or updates.
After
Everyone receives automatic notifications in Telegram — nothing gets lost.
Management couldn’t see who was overloaded and who was idle.
Dashboards provide a complete overview — tasks can be redistributed for more efficient work.
Before
Management couldn’t see who was overloaded and who was idle.
After
Dashboards provide a complete overview — tasks can be redistributed for more efficient work.
TAKE THE FIRST STEP
Book a short call, and we'll:
• show how automation can save you time and money
• talk through what we can simplify in the next 2–3 weeks
Created by Duck Agecny
All rights Reserved
Created by Duck Agecny
All rights Reserved