Automations

Freight rates without the spreadsheets.

An AI agent requests the rates from the shipping lines, reads their Excel files and updates your database, every quarter.

Part of the Apollo Negoce CTRM. A person approves every action.

01 · How it works

How to collect ocean freight rates from shipping lines automatically

  1. 1

    Rates requested

    Directly from the shipping lines you work with.

  2. 2

    Spreadsheets read

    Whatever the layout of their Excel files.

  3. 3

    Database updated

    And renewed every quarter, without anyone asking.

Current freight rates in your costing, without anyone retyping a spreadsheet.

02 · Example

What it looks like

Read the example as text

Email · Rates_Q1_2027.xlsx

Reply from the shipping line

ABJ / ANR
20' 1,450 · 40' 2,300
ABJ / AMS
20' 1,500 · 40' 2,380
SPY / HAM
20' 1,620 · 40' 2,540
TKD / ANR
20' 1,390 · 40' 2,210
DLA / VLC
20' 1,710 · 40' 2,690

Request sent automatically · 02 Jan

Your CTRM · Freight rates

Abidjan to Antwerp

Ocean freight · Q1 2027

Updated
  • 20' container USD 1,450 Rates_Q1_2027 · row 4
  • 40' container USD 2,300 Rates_Q1_2027 · row 4
  • Valid until 31 Mar 2027 Rates_Q1_2027 · header
  • Next request 01 Apr 2027 Every quarter, automatically

All routes of the file updated · costing uses the new rates from today

Example: Freight rates without the spreadsheets
03 · FAQ

Frequently asked questions

Can AI read freight rate spreadsheets from shipping lines?

Yes. The freight agent in Apollo Negoce reads the Excel files sent back by shipping lines, whatever their layout, and writes each route and container rate into the freight rates of the CTRM.

How often are freight rates updated?

Every quarter. The request to the shipping lines goes out automatically, and costing uses the new rates as soon as they are in.

See it on your own trades.

A 30-minute live demo, tailored to your commodities and operations.

Book a demo