Loading
Skip to content
Make

FreightFlow Control Tower

Built an automated logistics control system for managing shipment booking, carrier selection, pickup coordination, live tracking, delivery exceptions, proof of delivery, and carrier performance.

What this project does

The workflow takes a new shipment request and turns it into a complete logistics lifecycle, from carrier sourcing and dispatch to delivery confirmation and operational reporting.

How it was put together

Workflow

The system:

  • Receives new shipment requests through webhooks or forms
  • Validates shipment, customer, route, cargo, and delivery information
  • Creates shipment records and dedicated Google Drive folders
  • Calculates routes, travel distance, and estimated transit time
  • Searches approved carriers based on service region, capacity, equipment, and compliance
  • Sends quotation requests to suitable carriers
  • Receives, normalizes, and compares carrier quotations
  • Calculates carrier scores using price, availability, reliability, damage rate, and on-time performance
  • Generates recommended carrier summaries using AI
  • Routes shipments for manager approval when required
  • Creates confirmed carrier bookings automatically
  • Generates shipping documents and sends required documents through DocuSign
  • Sends booking confirmations to carriers and customers
  • Monitors upcoming pickups and sends driver reminders
  • Processes pickup confirmations, delays, failed pickups, and shipment-not-ready conditions
  • Retrieves carrier tracking data and recalculates delivery ETA
  • Detects at-risk and critically delayed shipments
  • Sends customer ETA updates and operations alerts automatically
  • Creates structured exception records for delivery problems
  • Receives delivery confirmation, signatures, photos, and proof of delivery
  • Reconciles expected and delivered shipment quantities
  • Routes partial, damaged, or rejected deliveries to claims handling
  • Closes successfully delivered shipments
  • Generates final shipment summaries and sends POD documents to customers
  • Calculates carrier performance after each completed shipment
  • Performs weekly audits for late shipments, missing PODs, open exceptions, and claims
  • Updates logistics analytics in Google Sheets

Branding & Templates

The workflow uses predefined shipment, carrier, approval, delivery, and exception templates.

Each template controls:

  • Carrier quote requests
  • Booking confirmations
  • Shipment documents
  • Customer status updates
  • Delivery exception alerts

This keeps logistics communication consistent across customers, carriers, shipments, and delivery stages.

Content Management

Airtable or SmartSuite acts as the central shipment, carrier, exception, and delivery tracking system.

Each shipment is updated with:

  • Shipment status
  • Selected carrier
  • Carrier score
  • Pickup status
  • Current ETA
  • Delivery risk
  • Exception status
  • POD status
  • Delivery result
  • Carrier performance

Result

A complete automated logistics pipeline that turns a shipment request into an approved, booked, tracked, delivered, reconciled, and documented shipment without requiring operations teams to manually coordinate every step.

The system also keeps carrier quotations, pickup activity, live ETA, shipment exceptions, proof of delivery, claims, carrier performance, and logistics analytics organized in one workflow.

Screenshots

Select an image to view it full size.

Abdullah Bukhari
Full-Stack .NET Engineer & AI Automation Architect

Want a system like this?

Share what you're working with and what should happen. I'll come back with questions and a suggested approach.

bukhariabdullah034@gmail.com

Work you can inspect

  • Lead Handling & Appointment Booking Chatbot: Chatbot
    n8n

    Lead Handling & Appointment Booking Chatbot

    Built a chatbot for a skin treatment clinic to handle leads coming from Facebook Ads and GoHighLevel.

    Read case study
  • Automated Xero POs, Invoices & Bill Attachments from Monday.com: Automated Xero POs, Invoices & Bill Attachments from Monday.com(1)
    Make

    Automated Xero POs, Invoices & Bill Attachments from Monday.com

    Built an automated finance workflow that connects Monday.com with Xero to automate purchase orders, client invoices, supplier invoices, and bill attachments.

    Read case study
  • AI Lead Qualification & Sales Automation: 1 (1)
    Zapier

    AI Lead Qualification & Sales Automation

    Built an end to end lead management and sales automation system that captures leads, enriches their information, scores their potential, routes them to the right…

    Read case study

What happens after you book: 1. We talk for 30 minutes. 2. I map the process and recommend an approach. 3. You decide.