AI Automation Expert for Logistics Dispatch & Shipment Update Workflow

We run a logistics and dispatch workflow where our team manually checks shipment emails, PDF documents, tracking updates, and spreadsheet records. We need an AI automation expert to create a simple workflow that can pull shipment details from emails/documents, update our Google Sheet or CRM, flag delayed or incomplete shipments, and prepare draft customer update messages. The main issue is that shipment information comes from multiple places, so our team spends too much time reviewing updates manually. This leads to delays, missed details, and repetitive admin work. We need help with: Email and PDF data extraction Tracking number, carrier, pickup, delivery, and status extraction Google Sheets / CRM record updates Missing-detail or delay alerts Draft customer update messages Workflow automation using AI, APIs, Python, n8n, Make, or Zapier Preferred skills: AI Automation, OpenAI API, Python, API Integration, Workflow Automation, Email Automation, PDF Extraction, Data Extraction, Google Sheets, CRM Automation, n8n, Make.com, Zapier. Please apply with a short explanation of how you would build the first version and which tools you would use.