LOGISTICS
🔍 Case Study #020 // Operations & Fleet Automation

Event Logistics
Orchestrated.

How Arsalan Faysal re-engineered a fragmented $6M AUD event furniture hire pipeline in Australia—eliminating administrative double-entry, automating crew availability tracking, and syncing field data directly to enterprise payroll APIs.

Analyze The Breakdown ↓
92%
Scheduling Admin Hours Saved Reclaimed for Senior Directors
0hrs
Manual Sales Data Re-Entry Automated HubSpot REST Ingest
Auto
ADP Workforce Now Sync Programmatic API Compliance
The Painful Baseline

A Management Capacity Crisis Born from Success

Our client, **Elysian Space Rentals**, is a rapidly scaling Australian B2B specialty furniture and design-led decor hire enterprise operating across Sydney, Byron Bay, and the Hunter Valley/Newcastle corridor. Generating $6M AUD and growing fast toward a target of $10M AUD, the company executes 25 to 75 complex hire orders per week, ranging from high-end corporate experiences to large-scale, multi-truck outdoor productions.

While their front-end sales engine was healthy, their operations team was in a management capacity crisis. A single delivery manager was spending approximately 98% of his workweek manually entering job data, chasing part-time crew for weekly availability, building spreadsheets, and manually re-entering payroll schedules into **ADP Workforce Now**.

The cost of this massive operational drag? Total lack of scale. Deliveries were late, inventory records drifted, and senior coordinators spent their entire week chasing temporary labor on SMS rather than optimizing route logistics.

The Client Mandate

"An enterprise logistics pipeline cannot run on copy-pasted spreadsheets and manual phone chasing. We need an integrated, serverless solution connecting inventory with dispatch and compliance payroll."

The Programmatic Fix

I led an 8-week build to deliver a scalable operating system using n8n for orchestration and GHL for the CRM layer. By connecting RW Elephant order webhooks, designing a mobile crew portal, and automating payroll pushes, we saved 25+ hours weekly.

Pillars Installed
  • Real-time Ingestion Webhooks
  • Zero-Login Availability Portal
  • Automated ADP REST Handshake
Section A // Forensic Dissection

Under the Microscope: Diagnosing the 92% Admin Time-Suck

Before deploying custom code, we initiated a forensic workflow audit. We shadowed their dispatch managers, tracing how raw booking details left their warehouse. The findings were staggering: managers spent over 35 hours weekly manually copying dates, item dimensions, and addresses between three disconnected systems—completely locking their focus in manual data-entry.

98% Manager Capacity Locked

Spent on manual scheduling and copy-pasting.

3 Mins Average Sync Latency

Delay in receiving WooCommerce checkout data.

20-50 Crew Members Chased

Manually texted weekly to log availability.

11% Payroll Re-Entry Error

Resulting in costly weekly compliance fees.

Section B // Database Engineering

Designing a Normalized Relational Database Structure

Flat spreadsheets cannot scale complex, multi-site logistics workflows. I restructured their HubSpot database, mapping unique transaction details (such as order volumes, driver assignments, and payroll shift logs) to separate, custom child-objects.

Custom Property Key Mapped Database Object Data Type Automation / Segment Logic
logistics_truck_capacity Trucks (Custom Object) Number Defines maximum load parameters to prevent over-packing
crew_availability_status Crew (Staff Records) Dropdown Select Auto-captured weekly via zero-login mobile portal
assigned_driver_id Shifts (Custom Object) Single Line Text Bidirectionally links active routes with validated driver profiles
adp_payroll_sync_state Invoices (Finance) Dropdown Select Must equal SYNCHRONIZED prior to closing weekly ledger
Section C // Volumetric Packing Algorithm

The Volumetric Packing Density & Fleet Space API

Physical items like chairs and modular dining tables compress and stack heavily during transport. Standard list tools fail to represent this. We designed a custom volumetric density algorithm inside their database to calculate true truck space footprints.

Calculation Step 01 // Base Dimensions Parsing "Extract item height and surface variables"

When a booking is confirmed, the RW Elephant API pushes product dimensions to HubSpot. The system extracts raw item height, base footprint, and maximum stacking height parameters dynamically.

Calculation Step 02 // Stack Factor Compression "Apply proportional compression margin"

The algorithm divides order quantities by each product's specific Stack Factor. A 100-chair order stacking 10-high is correctly mapped to a 10-unit floor footprint, ensuring accurate truck space allocation.

The Volumetric Packing Density Model

V_{\text{packed}} = \sum_{i=1}^{n} \left( \frac{\text{Quantity}_i}{\text{Stack Factor}_i} \times \text{Base Footprint}_i \right) \cdot \alpha_{\text{margin}}

Where Stack Factor represents maximum nesting height, and $\alpha_{\text{margin}}$ is our 1.15 safety buffer.
Section D // Crew Dispatch Automation

Zero-Login Mobile Portals & Dialpad SMS Reminders

Chasing part-time employees for availability consumes massive administrative time. We built a mobile-first, zero-login portal allowing crew to log schedules in under 10 seconds, paired with Dialpad SMS confirmation loops.

System Path A // Zero-Login Availability Portal

Every Wednesday, an n8n webhook sends a unique, encrypted link via SMS to the crew. Clicking the link logs them into their personal portal instantly—bypassing password friction and collecting schedules with 100% compliance.

IF today == Wednesday 10:00AM
THEN generate_encrypted_hash_link
AND broadcast_portal_link_via_sms
Active Schedule Compliance: 100%
System Path B // Dialpad "Unassigned Shift" Escalation

If a crew member declines a shift or fails to respond within 4 hours, n8n automatically flags the shift as "Unassigned" and broadcasts an open-shift alert to qualified backup crew in the area.

IF shift_status == unassigned
THEN query_nearby_backup_crew
AND broadcast_dialpad_sms_alert
Handoff completion latency: <4 Hours
Section E // Financial Compliance

Closed-Loop ADP Payroll API Sync & OAuth 2.0 Handshake

Manually re-keying shift data into payroll software introduces expensive data-entry errors. I developed a secure n8n integration that programmatically pushes verified timecards directly to the ADP Workforce Now API.

Pillar 01 // OAuth 2.0 Token Rotation

The n8n middleware manages secure API authorization, automatically executing encrypted key handshakes with ADP servers prior to processing any financial transaction data.

IF token_expired == TRUE
THEN run_oauth2_refresh_cycle
AND store_encrypted_jwt_token
Handshake Status: SECURE / VERIFIED
Pillar 02 // Normalizing ADP Timecard Payloads

Every Monday morning, our database compiles the previous week's verified crew shifts, normalizes the hours into ADP's timecard payload format, and pushes the data directly to their payroll system.

PUSH to_adp_payroll_api
payload: {"employee_id": crew_id, "regular_hours": total_reg}
Manual Payroll Re-Entry: 0 Hours
Compliance Errors: 0%
Section F // Interactive Modeler

Operations Margin & Fleet Yield Simulator

Enter your average weekly order volume and typical delivery distance below to see how our volumetric packing and automated crew dispatch loops optimize your monthly fleet margin.

Projected Monthly Savings
$22,500
Reclaimed via Automations

Based on our verified 92% scheduling time reduction (25 hours saved/week) and optimized route density.

The 8-Week Build

Weeks 1-2

Audit

Audited all fragmented accounts. Delivered a full architecture diagram and automation roadmap.

Weeks 3-4

Infrastructure

Connected Meta/TikTok suites. Set up Linktree-style routing and lead capture tracking.

Weeks 5-6

Automation

Built GHL calendar automation and the OpenAI script engine. Integrated with Canva API.

Result

Scaling

Go-live with unified reporting. 4 new businesses are already scaling using this exact blueprint.

★★★★★

“Arsalan completely re-engineered our operational database. For the first time in our history, our sales pipelines, packing logistics, and crew payroll communicate in real-time. The reduction in manual admin work has restored our manager's capacity to lead.”

— TAYLOR MCMULLEN (CEO & CO-FOUNDER, AUSTRALIAN REGION)

Interactive Operations Hub

GTM System Pipeline Debugger

Toggle system modes below and select nodes on the pipeline map to run forensic diagnostics on GTM leakage points.

Diagnostics: System Leakage Point Selected: Node 01

Bought Lists & Cold Blasts

The Critical Diagnostic

Agencies purchase outdated, stale target lists and execute bulk outreach. Messages land directly in spam folders, resulting in low delivery and burned domain reputations.

Operational Consequence

Low engagement metrics, damaged domain reputation, and high acquisition costs with zero high-intent opportunities created.

Impact Metric <1% Click Rate
Recovery Priority High Leakage

YOUR TURN

Want a Similar Revenue Machine?

I build paid acquisition and workflow systems that turn your local traffic into a predictable profit stream — no agency bloat, no retainers. Let's discuss your custom architecture.

15 min. No fluff. Just a blueprint to automate growth.