Case StudyTravel Agency · Panama

From Spreadsheet to Digital Brain

How a travel agency transformed its entire operation — from a fragmented system of Excel and WhatsApp to a centralized platform with augmented intelligence.

−85%
Quote generation time
+20h
Hours/week recovered by the team
+200%
Request management capacity
100%
Pipeline visibility in real time

The Starting Point

A business that worked despite its system, not because of it

The agency had a committed team and a quality product. What it did not have was a system: every quote was built from scratch in a fresh spreadsheet, four hours of work nobody could reuse. With that ceiling, the number of proposals per month was not set by demand, but by how many hours were left over.

Artisanal quotes

Each one was a unique Excel file built from scratch. No reuse of suppliers or itineraries.

Duplicated data

The same client could exist in 5 different files with contradictory information.

Financial blindness

Impossible to calculate the real profitability of a trip. Costs were not linked to revenue.

No pipeline visibility

The status of each request lived in the team's memory, not in a system.

The Solution

Hub-and-Spoke Architecture: a single source of truth

The first design principle was clear from the start: we don't digitize disorder, we redesign the architecture. We built a system with one central rule: one person, one record.

I — Data Architecture

Centralized database with a People Hub as the central node. Deduplication and linking of clients to quotes, reservations, and payments in a single view.

II — Automated Pipeline

Smart conditional form logic. Automatic generation of quotes, contracts, and travel guides in PDF with a single click.

III — AI Engine

5 specialized agents covering the full cycle: psychographic analysis, experience architecture, cost estimation, transaction analysis, and personalized communication.

IV — Smart CRM

Each client has a live profile: Lifetime Value, dynamic marketing segment, traveler archetype history, and AI-suggested destinations.

The AI Team

5 specialized agents, one goal

Each agent has a specific mission and structured output. The human reviews, decides, and executes. The AI does the heavy analytical work.

AthenaClient Analyst

Converts unstructured requests into a psychographic dossier: traveler archetype, confirmed interests, and lead quality score.

HeliosExperience Architect

Translates the dossier into a strategic trip vision. Adapts the approach based on whether the client is new, returning, or a cold lead.

VulcanBudget Engine

Converts the trip concept into a complete financial breakdown — costs, margins, and prices — in minutes instead of hours.

VectorBusiness Analyst

Analyzes each transaction: budget alignment, predicted conversion rate, and potential friction point.

CicerónStrategic Communicator

Generates hyper-personalized HTML email drafts for reactivation, onboarding, and upsell — based on each person's real profile.

The Results

Real numbers, no estimates

Efficiency

Quote generation time (from ~4h to <30min)

−85%

Efficiency

Manual work hours saved per week

+20h

Capacity

Request management with the same team

+200%

Capacity

Inactive leads reactivated as active

+100%

Visibility

Commercial pipeline in real time

100%

Visibility

Profitability visible per trip and client type

100%
"We didn't have a tools problem. We had an architecture problem. Now the system works — and we make decisions."

Transformation completed by Metacube Studio · 2025

Tech Stack

Tools are the means, not the end

The value of this system is not in the tools — it's in the architectural design that connects them and the business logic that makes them work together.

  • AirtableThe relational base where one person is one record. It is what removes the same client repeated across five files with contradictory data.
  • Make.comThe orchestrator that turns one click into a quote, a contract and a travel guide without anyone opening a template.
  • OpenAI APIThe five copilots doing the heavy analysis: profile, concept, costing, post-mortem and outreach. The decision still belongs to the team.
  • Fillout FormsThe single structured intake with conditional logic that replaced the free-text form, and with it the dirty data at source.
  • Google WorkspaceWhere generated documents land: every PDF filed and linked back to its record, with no folders created by hand.
  • Telegram Bot APIThe team pulse: new request, quote sent, payment received, contract signed, without anyone having to ask.

Does your business operate like this today?

If your team spends hours on tasks that a well-designed system should handle automatically, we can change that.

Book a Clarity Session

30 minutes. We look at how your business runs today and you leave with a concrete proposal: what to build, in what order, and what it costs.


Learn more about our work at metacubestudio.com →