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.
- 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
Brief · Nov 20, 2026
Canva adds a generative AI off switch for free and paid users; some AI tools stay on
If your office uses Canva for flyers, quotes or social posts, you can now block AI image and text…
Brief · Nov 20, 2026
Gemini file labelling in Drive goes GA Nov. 17, only on Enterprise Plus and Frontline Plus
Workspace admins can now have Gemini auto label Drive files from plain English rules, but most 10 to 50…
Brief · Nov 19, 2026
Gemini Notebook can now publish shareable sites from your files, on all Workspace plans by Dec. 1
Every Google Workspace plan gets it, there is no admin switch for the site feature itself, and the effect…
Brief · Nov 18, 2026
OpenAI launches ChatGPT for Sales with a Sales plugin and 30+ partner plugins
If you already pay for ChatGPT seats, check whether this covers prospect research and CRM updates before you…