Smart Life USGoogle Sheets Dock Appointment System · Setup
5 posts
Google Sheets inbound appointment sheet structure — basics 1
If you found this by searching for how to build an inbound appointment system in Google Sheets, you’re probably a practitioner directly handling warehouse or logistics work. You may already have inventory management or outbound automation in decent shape, but the system for managing inbound time slots is still scattered across Excel, phone calls, and messengers. This post walks through, from scratch, a Google Sheets–based inbound appointment sheet structure you can copy, paste, and start using right away.
Google Sheets dock doors auto-create: 30 doors, 50 yard slots
If you’re looking for a way to auto-create dock doors in Google Sheets, this post walks through it. When you build an inbound appointment system in Google Sheets, you always need a dock door and yard slot list. But in the field, this simple list is still often typed by hand. Once you have 30 doors and 50 yard slots, it’s easy to miss or mistype numbers. This post shows how to remove that repetition…
Google Sheets settings in one place: manage with a SETTINGS sheet
If you’re looking for a way to keep Google Sheets settings in one place, this post lays it out. When you use a Google Sheets receiving appointment system, you’ll often get requests like “For this week only, start at 8 a.m. instead of 9,” or “Turn off yard slots for now.” If you open the Apps Script code and edit constants every time, it’s easy to make mistakes, and the operator has to keep asking the developer for help…
Google Sheets web app multiple screens: Apps Script doGet page routing — Receiving appointment system 4
When you look up how to create multiple screens in a Google Sheets web app, you’ll often see examples that create a separate Apps Script project for each screen. But if you run separate check-in, admin dashboard, and on-site lookup screens for something like a receiving appointment system, the number of projects explodes and URLs, permissions, and shared functions all drift apart, making real-world maintenance painful…
Google Sheets date format unification: Inbound booking basics 5
If you’re looking for a way to unify date formats in Google Sheets, this post walks through it step by step. Once you start building an inbound booking system in Google Sheets, at some point the dates begin to look strange. Someone types 8/3 by hand, someone else pastes 2026-08-03, and the web app or Apps…