Booking & Operations Automation for Logistics Companies.

Phase 1: The Hygiene Layer

Before data ever hits the CRM, we run it through a custom Javascript node to strip formatting errors. This ensures 100% database integrity.

// 1. Sanitize Phone Number (Remove spaces, dashes, brackets)
// Input: "+1 (555) 123-4567" -> Output: "+15551234567"
const cleanPhone = input.phone.toString().replace(/[\s\(\)\-]/g, '');

// 2. Format Move Type (Standardize Capitalization)
// Input: "commercial" -> Output: "Commercial"
const cleanType = rawType.charAt(0).toUpperCase() + rawType.slice(1);

// 3. Return Clean Object
return {
    json: {
        name: input.name,
        email: input.email.trim().toLowerCase(),
        phone: cleanPhone,
        move_type: cleanType
    }
}

Phase 2: The Priority Router

The system instantly separates "Standard" moves from "VIP" moves. Commercial clients get a white-glove personal email from the owner; residential clients get an instant automated booking link.

Figure 1: The "Zero-Latency" Logic Map (n8n)

Phase 3: The Resulting Database

Because the data is pre-cleaned, the CRM stays organized automatically. No more duplicate contacts or missing fields.

Figure 2: The Cleaned CRM View (Airtable)