“Workplace automation” often brings to mind an invisible script. But what actually gets used on the ground is a screen a person opens. Apps Script lets you build exactly that, a web app, right on your Google account, with no separate server.
This is a demonstration draft.
A web app has no install
Deploy an Apps Script web app and you get a single link. A staff member just opens it in a phone or desktop browser. No app store, no install.
function doGet() {
return HtmlService.createTemplateFromFile("index")
.evaluate()
.setTitle("Inventory entry")
.addMetaTag("viewport", "width=device-width, initial-scale=1");
}One viewport meta tag and the same screen renders properly on mobile. That’s
the moment it becomes a tool for entering things on the spot.
From screen to sheet
A web app’s input is passed to a server function via google.script.run. That
function writes to a spreadsheet, and the data lands straight in the sheet your
team already uses.
// client (browser)
function submit(form) {
google.script.run
.withSuccessHandler(onSaved)
.saveEntry(form);
}
// server (Apps Script)
function saveEntry(form) {
SpreadsheetApp.getActive()
.getSheetByName("Inventory")
.appendRow([new Date(), form.item, form.qty]);
return { ok: true };
}No separate database needed; the sheet is the store.
The breadth you can build
The same structure yields a range of tools.
- Input screens: inventory, visit logs, inspection checklists
- Dashboards: a status board that reads numbers from a sheet
- Admin tools: internal steps like approvals or status changes
- Reply automation: intake and drafted replies, and auto-handling freelance inquiries is just one case of this
Keep permissions narrow
A web app can run “as me” or “as the user accessing it.” For an internal tool, keep the access scope narrow and grant only the sheets it truly needs.
Wrapping up
Workplace automation isn’t invisible magic; it’s a small tool a person opens and uses. Apps Script lets you build that tool with no install, on your Google account. The next post covers why these tools run almost for free.