Smart Life USExcel & Automation
34 posts · Page 1 of 3
Google Sheets bulk appointment booking: finish with one LockService and setValues call
When you look for ways to bulk‑register appointments in Google Sheets, you often hit this: “validation is fast enough, but actually writing to the sheet is painfully slow.” In operations like inbound appointment booking, where dozens or hundreds of rows pile up daily, you really want to paste the carrier’s list once and process everything in one go. In the previous post…
Google Sheets bulk booking validation: check everything in one paste (final)
If you’re looking for a way to bulk‑validate bookings in Google Sheets, this post lays it out. When you paste multiple bookings into a sheet, you often burn time just figuring out which row is failing and why. Especially when you paste an inbound booking list copied from Excel: one row with a bad date format can block the whole batch…
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.
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 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 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…
How to Auto-Refresh a Google Sheets Dashboard: Refresh Multiple Views at Once and Automate with Triggers
When you look up how to auto-refresh a Google Sheets dashboard, most guides stop at “make one function per view and attach a button.” As soon as you have three or more views—daily appointments, status overview, yard trailers—you end up with three buttons and three time triggers. The result: multiple time triggers stack on the same function, three functions run in parallel, and they keep hitting the 6‑minute Google Apps Script limit and stopping…
Google Sheets Yard Trailer Status Dashboard — Part 3 (Final)
If you’re looking for how to build a Google Sheets yard trailer status dashboard, this post walks through the setup. The inbound appointment system in this series connects reservations, check-in, and yard moves into a single flow. In the previous post - Automate Google Sheets appointment views: build a Today sheet — Dashboard Part 1…
Create a Google Sheets status dashboard — Dashboard 2
If you’re looking for how to build a Google Sheets dashboard by reservation status, this post summarizes the whole setup. Building a status-based reservation dashboard in Google Sheets ultimately means seeing at a glance how many are Waiting, Arrived, In Progress, and Done right now. In this post, we’ll add an inbound reservation status dashboard in Google Sheets using Apps Script…
Google Sheets yard slot auto-assign & move log — Check-in 5
People looking for a Google Sheets yard slot auto-assignment method usually want to know in near real time which yard slots are empty and how full the yard is during peak truck hours. This post is the fifth in the Check-in series, following “Automatically change Google Sheets check-in booking status with Apps Script,” and builds on the save-and-status-change code from that article…
Google Sheets booking status automation: create TODAY view — Dashboard part 1
If you're looking for a way to automate your booking status in Google Sheets, this post lays out the approach. When you manage inbound dock appointments in Google Sheets, you constantly run into moments when you want to see only today's trucks in one place. Every time, you have to re-apply the date filter, change the sort by start time, and hide yesterday/tomorrow's bookings…
How to Save Google Sheets Check-in Photos to Drive: Organize by Date with Apps Script
If you’re looking for a way to save Google Sheets check-in photos to Drive, this post walks through a practical setup. Once you start running inbound appointments and arrival check-ins in Google Sheets, you eventually hit the same wall: BOL/POD photos from drivers are scattered across email, messengers, and personal Google Drives, and when there’s a claim later, you waste time hunting for which container’s photo is where. Everyone names files differently, so search doesn’t help much either.