ops-reportlisted

# Daily Executive Operations Report Generate the daily executive operations report for the parcel fulfillment network. This report covers three sections. ## Data sources to auto-pull: **1. Shipment Containers (Google Drive MCP — read_file_content)** File ID: 1ExampleShipmentContainersFileId00000000000 Parse the facility summary table with COMPLETION % column. Report active, loaded, staged, shipped counts and completion % by site. Flag any site below 75% completion. Show week-over-week trend if available. **2. Dock Pending Log (Google Drive MCP — read_file_content)** File ID: 1ExampleDockPendingLogFileId0000000000000000 Count all rows where Resolved = FALSE. Break down by site (EAST1, WEST2, etc.) and issue type (PO Number, Pallet/Piece Count Discrepancy). Report total open count. **3. Dock Activity Emails (Gmail MCP — search_threads)** Search query: label:dock-activity newer_than:1d Count Approved vs. Requested appointments. Flag any outstanding requests not yet approved. **4. Open Dwell Tickets (Google Drive MCP — read_file_content)** File ID: 1ExampleDwellTicketLogFileId0000000000000000 Tab: Dwell Log - Form Responses. Filter rows where Open/Closed column = "Open". Report each open ticket with: date, facility, # packages, client impact, carrier impact, issue description. Flag packages >= 25 (Missort Warning), >= 41 (Missort Alert), carrier >= 80 (Possible Misload Alert). ## Manual data to request from user: After pulling the above, ask the duty manager to provide: 1