Back Office BeatSubscribe

Published by J9 Systems. What's new in business tech, and what it means for yours.

From the brief of Tuesday, November 17, 2026 · No. 29

From the daily brief · AI

Gemini in Google Apps Script goes GA Nov. 16 for Business Standard and Plus

Office staff can now describe a Sheets or Gmail automation in plain words and get working code, which may cover small jobs you pay Zapier for.

By Carter Josephson · · 2 min read

What happened

Google announced on Nov. 16, 2026 that the Gemini side panel in Apps Script is generally available, letting users describe an automation in plain language, review Gemini's proposed code block by block, and click "Fix errors" for a plain-language diagnosis and suggested fix. The gradual rollout started Nov. 12 for Rapid and Scheduled Release domains, with up to 15 days for the feature to appear, and covers Workspace Business Standard and Plus, Enterprise Standard and Plus, and certain AI add-ons and consumer AI plans.

What it means for a 10-to-50-person business

The effect is small. Apps Script was already included in Workspace. What changes is that someone who can't code can now describe a task and get a working script. Example: a 22-person HVAC shop keeps its maintenance-visit log in Sheets and pays for a Zapier tier (assume $30/mo) to send customers a Gmail reminder three days before each visit. The office manager can now ask Gemini to write a script that checks the sheet each morning on a time-based trigger and sends those emails. Assume two hours to build and test. If that is the only Zap, the shop saves about $360 a year. If Zapier also moves data between ServiceTitan or QuickBooks and Sheets, keep it. This does not replace those connections. The risk: the script runs with the office manager's own Gmail and Drive permissions, so one bad filter could email every customer on the list. Have the owner or admin read it before the trigger goes live. Shops on Business Starter or Microsoft 365 can ignore this.

What to do
Try it

If you are on Business Standard or Plus, have your office manager spend one hour rebuilding your simplest Sheets-to-Gmail Zap in Apps Script once the Gemini panel appears (by about Nov. 27), and have the owner read the script before its trigger is switched on.

What it costs
What it costs
Gemini in Apps Script on Business Standard or Plus
$0 extra
Zapier tier replaced, assume $30/mo
saves ≈ $360/yr
Office manager build and test, 2 hrs at $35/hr
≈ $70
Owner or admin review before trigger goes live, 30 min at $100/hr
≈ $50
Upgrade from Business Starter to get it
per-user price difference × every seat; check Google's pricing page first
Doing nothing
$0 now; the Zapier tier keeps billing, assume $360/yr
Sources
workspaceupdates.googleblog.com (primary) · Gemini in Apps Script — Google developer guide · OAuth audit logs — Google Workspace Admin Help · Rapid Release and Scheduled Release — Google Workspace Admin Help

Questions owners ask

Does this cost extra on top of Workspace?

Not on Business Standard, Business Plus, Enterprise Standard or Enterprise Plus, per Google's post. It is not listed for Business Starter.

Can it replace all of our Zapier automations?

No. It works best for jobs that stay inside Sheets, Gmail, Calendar, Docs and Forms. Connections to field-service or accounting software are a separate job and usually stay in Zapier or similar tools.

How does an owner keep control of scripts staff write?

Admins can turn Apps Script and Gemini on or off by organizational unit or group in the Admin console, restrict data access through OAuth app controls and URL allowlists, and check Drive and OAuth audit logs. At minimum, read any script that sends email before its trigger is enabled.

Three to five of these, every weekday morning.

Related