LOGISTICS

Freight quote logic turned into a repeatable workflow.

A logistics quote process needed to combine form intake, route data, pricing rules, loading meters, tolls, ferry logic, and special surcharges without burying assumptions in spreadsheets.

Quote intakeRoute calculationPricing rulesSurcharge logicOwnership transfer
01 TriggerQuote form

Customer route and shipment details enter n8n.

02 LookupRoute data

Distance, route, and country context are enriched.

03 RulesPricing table

Loading meters, tolls, ferry, and service rules apply.

04 CheckSurcharges

Special cases and judgement-heavy costs are flagged.

05 OutputQuote ready

The total is prepared with visible assumptions.

THE WORKFLOW

From form submission to priced freight quote.

The workflow used structured form inputs, spreadsheet pricing rules, route enrichment, loading-meter multipliers, ferry lookups, tail-lift logic, selected AI judgement steps, and delayed-result handling to prepare a quote output with visible assumptions.

SYSTEMS

Connected stack

  • FormDesigner Pro intake
  • n8n workflow orchestration
  • Google Sheets and Apps Script pricing tables
  • Loading-meter multiplier and ferry price lookups
  • HERE route data and route alternatives
  • OpenAI for selected city-center judgement calls
  • Thank-you page result display and email fallback
BUSINESS PROBLEM

Quote logic was too complex for manual coordination.

Pricing depended on origin, destination, country pair, loading meters, ferry crossings, tolls, tail-lift options, route duration, shortest versus fastest route choices, and spreadsheet-based assumptions.

DELIVERY

An automated calculation path with visible components.

The workflow connected the intake form, data cleanup, country-pair pricing, loading-meter multiplier, ferry pricing, route lookup, surcharge rules, and final quote preparation so the total could be explained by its components.

GOVERNANCE

Special cases stay reviewable.

Invalid numbers, missing route data, failed spreadsheet lookups, delayed API responses, and judgement-heavy surcharge cases can be logged or reviewed instead of treated as simple automation output.

OUTCOME

A clearer quote machine.

The value is a repeatable pricing workflow with less manual coordination, more visible assumptions, customer-facing result delivery, and a cleaner path to ownership transfer.

NEXT STEP

Have quote logic trapped in spreadsheets?

Start with one quote path, then automate the rules, exceptions, and review steps around it.

Scope an implementation sprint