01
Read emails
Connects directly to Outlook via COM API. Filters by email, folder and date range.
02
AI extraction
GPT processes each email and extracts vessel name, deadweight, port, and open date.
03
Parse & clean
Regex normalises output. Inconsistent formats are standardised automatically.
04
Deduplicate
Fuzzy name matching removes duplicate vessel entries across sessions.
05
Write to Excel
Structured data is appended to your spreadsheet with port zone lookup.
→ Accessing folder: shipbroking
→ Processing email from: broker@shipping.com
→ Extracted: MV LUCKY LOONG · 76K · DALIAN · 28 JAN
→ Extracted: MV YANGTZE GRACE · 32K · CALLAO · 30 JUN
→ Written to extraction.xlsx