Smart Life USGoogle Sheets Dock Appointment System · KPI & Reports
4 posts
Google Sheets reservation KPI aggregation: on-time rate & dwell time auto-calculation
If you’re looking for a way to auto-calculate on-time rate and dwell time in Google Sheets, this post lays it out. Once you start managing inbound appointments in Google Sheets, you’ll eventually ask: “What’s the on-time arrival rate by carrier? What’s the average dwell time? Can I see it every day automatically?” This post is for operators who…
Google Sheets KPI Auto-Rollup: Nightly Trigger History (Full Code)
Most guides on automating KPIs in Google Sheets focus only on how to calculate “today’s numbers.” In real operations, however, what matters more than today is the trend versus yesterday, last week, and last month. Manually changing the date and recalculating is tedious, and on busy days…
Google Sheets weekly KPI email: KPI Pt.4 final code
People looking for automatic weekly KPI report emails from Google Sheets are usually in a similar situation: every Monday morning, they copy last week’s inbound appointment KPI into Excel, aggregate carrier scores, and email the report around. It’s something a person can do, but too much of a waste to repeat every week…
Google Sheets Late-Arrival Alert Auto Email: Inbound KPI 5
If an inbound truck is late and nobody notices, the on-site plan falls apart immediately. This post walks through how to set up Google Sheets late-arrival alert auto emails, plus an email automation that sends a summary of tomorrow’s inbound appointments in advance. With just Google Sheets and Apps Script, you can bundle late-arrival alert emails and a “tomorrow’s appointments” preview so the manager can see at a glance, from their inbox, which time slots need attention.