One Place to See What Needs Your Attention
BUILD · CLIENT CONTROL CENTER
BUILD · CLIENT CONTROL CENTER
This page shows the Client Control Center (CCC), the central dashboard I designed for every NNS installation, shown here with sample data. You’ll see one test request followed from the Google Sheet into the dashboard and back to closed.
Without it, starting the day meant checking email, the calendar, Google Sheets, and Google Drive one by one. The CCC is built in Google Sites and brings new requests, pending work, calendar activity, and business resources into one view. It reads request information from a Google Sheet, and Apps Script surfaces what needs attention, so when something changes in the sheet, the dashboard changes too. Each request moves through defined stages, from received to awaiting decision, awaiting payment, active work, and owner action.
I wanted to open my workday and know what needed my attention without searching for it, so I could see where things stand and decide what happens next.
Day-to-day operations involved several separate steps: checking email for new requests, opening the calendar for meetings and deadlines, reviewing a spreadsheet for active work, searching Drive for contracts and SOPs, and deciding what needed attention first.
When each of those checks happens in a different tool, the same searching is repeated every day, and there is greater opportunity for missed decisions, slipped follow-up, or inconsistent information.
The CCC runs on Google Sheets, which holds the data, while Apps Script powers selected automations that surface current activity, flag items requiring attention, and connect information back to the CCC.
I also defined the request life cycle: the stages a request moves through, from the moment it arrives to the decisions and actions that follow. The Business Today view brings those stages into focus, showing what's new, what's waiting, and where someone needs to act.
The CCC is built around three connected layers:
1. Business activity enters from multiple sources.
Requests, calendar activity, documents, and resources are linked or surfaced in one place instead of staying in separate tools.
2. Work is grouped by request status.
Incoming activity moves through defined stages such as request received, awaiting decision, awaiting payment, active work, and owner action. This creates a visible path from entry through completion.
3. I work from one central view.
The Client Control Center shows what requires attention now: current activity, decisions, deadlines, open items, business resources, and quick capture. I can see what’s happening without reopening every underlying system.
I used ChatGPT and Claude to help write the Apps Script and plan the layout, then tested it with sample requests from received to closed.
One morning I opened the dashboard and saw an alert for a Tally request I’d missed in my email. The alert did its job. But once I handled the request, the alert had no clear way to close. I had defined how a request comes in, but I’d missed a requirement: how the system knows the work is finished. For now, an item closes when I update its state in the Sheet, and letting the CCC close it directly is the next improvement. Showing what needs attention is only half the job; the system also has to recognize when the work is done.
Google Sites · Google Apps Script · Google Sheets · Google Calendar · Google Drive · Tally · Stripe · Google Docs
My working session starts from one view instead of several tools. What’s active, what’s waiting, and what needs a decision are visible in one place.
Work moves through defined stages, making it easier to see where action is required.
The larger value is moving from rebuilding the picture of the business each day to acting on what needs attention.
One test request, followed from the Sheet to the Client Control Center and back to closed. Sample data.
What the other numbers mean
The “5 Parked” under Open Items are planned improvements I’ve set aside until the right time. The four standing rules under Operations Structure are decisions that apply across the business, such as using the same business-type names in every form and sheet. The seven indexed sources show where key files live, including the Master Build Manual and main Google Drive folders.