Logistics Dispatch Automation
PDF label ingestion, data extraction, SKU resolution and daily operator handoff.
Role
System design and automation implementation
Problem
Dispatch operations relied on manual PDF reading, SKU lookup and daily spreadsheet preparation for the logistics operator.
What I developed
An intake pipeline from PDF upload through structured extraction, SKU resolution, shipment logging and automated daily handoff generation.
Architecture
Google Drive intake → PDF extraction (Gemini) → SKU resolution → shipment log (Google Sheets) → daily handoff spreadsheet → Gmail notification.
What it handled
Label PDF parsing, recipient and shipment data extraction, SKU mapping, dispatch logging and daily operator spreadsheets.
Key decisions
- Use document AI for PDF extraction instead of manual entry
- Separate extraction, resolution and handoff into clear stages
- Generate a daily operator spreadsheet as the operational contract
Evidence available
Architecture diagram · sanitized PDF sample · output spreadsheet example · result summary
Limitations
Historical production system. Public materials use sanitized PDF and spreadsheet samples only.