Team automating work in Google Workspace
Google Partner · Authorized Reseller

Google Workspace Automation

Four layers, cheapest first. Most of what businesses ask us to automate is solved in the first two, without a line of code and without anything that can break in a way nobody can fix.

The interesting question is not what Google Workspace can automate — the answer is nearly anything. It is what you should automate, at which layer, and who is going to own it in three years when the person who built it has moved on.

The ladder

Four layers, and the rule for choosing between them

Go down this list only when the layer above genuinely cannot do the job. Each step down buys capability and costs maintenance, and the maintenance is the part that does not appear in anybody's quote.

1

Rules you configure

Gmail filters and labels, groups standing in for role addresses, calendar appointment schedules, a Shared Drive structure that puts things where they belong, document templates. No code, nothing to break, and nothing to inherit. A surprising share of what gets described to us as an automation problem is solved entirely at this layer.

Typical cost

An afternoon

Anyone can maintain it

2

Forms into Sheets

A Google Form writes structured rows into a Sheet instead of arriving as prose in somebody's inbox. Add a few formulas and you have a register you can filter, count and report on. This is the step that converts email into data, and it is usually the highest-value thing on this page.

Typical cost

A day or two

A competent spreadsheet user

3

AppSheet

A no-code application over data you already hold in Sheets or Drive — mobile data capture, checklists, approvals, a register somebody updates from a site rather than from a desk. AppSheet Core is included by default with the business editions, so for many businesses this layer is already paid for and simply unused.

Typical cost

Days to a few weeks

A trained non-developer

4

Apps Script

JavaScript running against the Workspace APIs, on a schedule or on an event. There is very little it cannot do, which is exactly why it is last on this list rather than first. Everything above is configuration; this is software, and software has an owner, a maintainer and a lifespan.

Typical cost

Developer time, ongoing

Someone who can read code

The bottom two layers have pages of their own: AppSheet covers which editions already include it and what the included tier can reach, and Apps Script covers Google's published limits and the three jobs it is wrong for.

Layer one

Start with what you already pay for

These are in every edition, need no code, and are the things almost nobody has configured — precisely because they are too dull to put on a requirements list. They are also the only automation that cannot strand you, because there is nothing to inherit and nothing to maintain.

Filters and labels that route on arrival

Mail from a supplier domain labelled and skipped past the inbox. Statements filed automatically. It takes ten minutes per rule and it is the automation people are least likely to have set up, because it is not exciting enough to ask for.

Groups instead of forwarding chains

orders@ or accounts@ backed by a group means adding or removing a person is a membership change rather than an edit to four people's forwarding rules that nobody remembers exists.

Templates rather than last month's file

A quotation or report built from a template in a Shared Drive, rather than from whichever copy somebody found and edited. This removes an entire category of error at zero cost.

Appointment schedules instead of the booking email

Calendar publishes availability and people book against it. It removes a negotiation that costs four messages every time, and it is already in the licence.

Configuring Google Workspace automation
The part nobody quotes

Automation has an owner, or it has a lifespan

Building it is the cheap part and the part everybody quotes for. What decides whether it was worth building is what happens in the two years afterwards, and four things account for nearly every automation we are called in to resurrect.

A script runs as whoever authorised it

An Apps Script trigger executes under the account that installed it. When that person is suspended or their account is deleted — on the day they leave, by a process that is otherwise correct — the automation stops. Often quietly. This is the single most common way business automation dies in a Workspace tenant, and it is entirely predictable.

Nobody knows what it does until it stops

Working automation is invisible. That is the point of it, and it is also why the knowledge of what it does, why it exists and what depends on it evaporates within about a year unless somebody wrote it down at the time.

The author leaves before the script does

We are regularly asked to look at a script nobody in the business can read, which does something nobody can fully describe, written by somebody who left in 2023. Rewriting it costs more than writing it did. Deciding not to have written it would have cost nothing.

Silent failure is the default

A script that stops does not send anybody a message saying so. Whatever it was doing simply stops being done, and you find out when a customer asks. Anything worth automating is worth a failure notification, which is ten minutes of work at the time and impossible to add retrospectively to something nobody understands.

The first of those is worth checking today if you have automation you did not build: find out which account authorised it, and make sure that account is not one you are planning to close. Google states it plainly — installable triggers always run under the account of the person who created them, which is set out with the rest of the published limits on the Apps Script page. Who holds what, and what leaving does to it, is on the administration page.

In practice

What we are actually asked to automate

Five requests cover most of it. The useful exercise is not asking whether each can be automated — they all can — but which layer it belongs at, and whether the process underneath is settled enough to automate at all.

Approvals that currently happen by reply

Purchase requests, leave, discounts. Usually layer 2 or 3 — a form, a register, and a notification. Rarely needs code.

Onboarding a new joiner

Account, groups, drive access, equipment checklist. Partly configuration, partly a checklist that a human follows. Automating the account creation is easy; automating the judgement is not.

Offboarding someone properly

The one most worth getting right, because it is the one that gets half-done. Usually a documented sequence rather than a script — and it should include checking what automation ran as that person.

A recurring report somebody assembles by hand

The classic case for automation and usually genuinely worth it — but check first whether the report is still read. A surprising number are not.

Re-typing between two systems

The strongest case on this list. Any step where a human reads from one screen and types into another is both the most expensive and the most error-prone thing in the process.

Automation is not integration

Automation is work happening inside Google Workspace without a person doing it. Integration is Workspace exchanging data with something outside it — your accounting system, your CRM, your website. We keep them separate because they fail differently: automation breaks when somebody leaves, and integration breaks when somebody else changes their system without telling you.

Google Workspace automation — common questions

What can Google Workspace automate without any code?

More than most businesses use. Gmail filters and labels route mail on arrival. Groups turn role addresses into a membership list rather than a set of forwarding rules. Calendar appointment schedules replace the back-and-forth of booking a meeting. Google Forms writes structured rows into a Sheet instead of prose into an inbox. Templates stop people building this month's quotation from last month's file. None of that requires a developer, none of it can break in a way nobody can fix, and between them they cover a large share of what gets described to us as needing automation.

Is AppSheet included in our Google Workspace licence?

For most business editions, yes. Google's own announcement lists AppSheet Core as included by default for Business Starter, Standard and Plus, Enterprise Starter and Standard, Frontline Starter and Standard, Nonprofits and Education Standard, and it was already included for Enterprise Plus, Enterprise Essentials Plus and Education Plus. Your domain has to be verified for it to apply. One caveat we would rather state than gloss over: the India-only Base tier is newer than that announcement and we do not assume it is covered, so if you are on Base we confirm it against your own admin console rather than telling you what it should be. Checked September 2026.

Do we need a developer to automate anything useful?

Usually not, and we will tell you when the answer is no even though writing the code is the better-paid work. Layers one and two of the ladder on this page — configuration, and forms into sheets — cover most requests, cost very little and can be maintained by whoever is already there. A developer becomes justified when something genuinely cannot be expressed as configuration, when it has to run unattended on a schedule, or when it has to talk to a system outside Workspace.

What happens to a script when the person who wrote it leaves?

That depends entirely on whether anyone thought about it in advance, and usually nobody has. An Apps Script trigger runs under the account that authorised it, so suspending or deleting that account stops the automation — typically without telling anybody. If the script also lives in that person's personal Drive rather than a Shared Drive, the code goes with them. Both are avoidable: put the script in a Shared Drive the company owns, have it authorised by an account that is not tied to an individual's employment, and write down what it does. Ten minutes at the time, against a rebuild later.

Should we automate our approvals?

Often yes, but not by building software first. Start by writing the approval down as it actually happens rather than as the org chart says it happens — who asks, who decides, what they need to see, and what happens when they are on leave. A good proportion of approval problems turn out to be that nobody had agreed the rule, and no amount of automation fixes an undecided rule. Once it is written down, a form and a register usually cover it, and an AppSheet application covers the rest.

What is the difference between automation and integration?

Automation is work happening inside Google Workspace without a person doing it — a filter, a form, a scheduled script, an AppSheet application. Integration is Workspace exchanging data with something outside it, such as your accounting system, your CRM or a website. The distinction matters commercially because they fail differently: automation breaks when a person leaves, and integration breaks when somebody else changes their system without telling you. They are scoped and quoted separately for that reason.

How do you price this?

Configuration work — layers one and two — is usually a short fixed-price piece, because the scope is knowable in advance. AppSheet and Apps Script work is quoted against a written specification, and we would rather spend an unpaid hour agreeing that specification than quote against a conversation. We also quote maintenance separately and explicitly, because automation that nobody owns is a liability rather than an asset, and pretending otherwise would be the easier sale.

Describe the process, not the software

Tell us what happens today, step by step, including the parts that are somebody remembering. We will tell you which layer it belongs at — and when the honest answer is a filter and a form rather than anything we would bill much for.

  • The cheapest layer that actually solves it, not the most impressive

  • A written specification before any code is quoted

  • Scripts owned by the company, not by whoever authorised them

  • Failure notifications on anything that runs unattended

We are a Google Workspace partner in Kerala working across India. Or call +91 99467 89916 and email admin@techgeum.com.

call