Automate BOL/CI Data Extraction

I have roughly 5 000 PDFs that are a mix of Bills of Lading and Commercial Invoices. I need a reliable script—Python preferred, but any language is fine—that can open each file, read the key parties on the document, and aggregate everything into a single Excel workbook.

The script must capture:
• Shipper details
• Receiver details
• Broker details

Accuracy matters more than speed; some files are machine-readable, others are scanned, so you may have to blend text parsing with OCR (think pdfminer.six, PyPDF2, Camelot, Tesseract, or any stack you trust). The output should be a clean .xlsx file with one row per shipment and clearly labeled columns for each data point.

Please send a brief but detailed proposal that explains:
– The libraries or tools you will use
– How you will handle both text and scanned PDFs
– A plan for testing accuracy on a sample set before running the full batch
– An estimated timeline for completion

Deliver a runnable script, clear setup instructions, and the final Excel file. Let me know any questions you have so we can get started quickly.