Dev.to
7/12/2026

The original title is: "Turning WhatsApp Into a Mobile ERP for Field Logistics (Apps Script + Google Sheets)"
Original: Turning WhatsApp Into a Mobile ERP for Field Logistics (Apps Script + Google Sheets)
Short summary
This guide shows how to build a WhatsApp-based mobile ERP for field logistics using Apps Script and Google Sheets, replacing custom driver apps that suffer from low adoption. Messages are parsed first with regex (~70% of inputs) and then an LLM fallback (GPT-4o-mini or Gemini Flash) normalizes the rest with confidence scoring and multilingual support. The system achieves 90%+ driver adoption in a week, runs on free Google Workspace infrastructure, and supports outbound alerts and proof-of-delivery workflows.
- •WhatsApp + Apps Script + Google Sheets replaces custom field-service apps with 90%+ adoption
- •Regex handles ~70% of driver messages; LLM fallback normalizes the rest with confidence scoring
- •Architecture includes real-time Sheet updates, dashboards, outbound alerts, and POD photo workflows
Generated with AI, which can make mistakes.
Is this a good recommendation for you?



