Gemini now writes Google Apps Script for you, so the spreadsheet chore you'd automate 'if you could code' is out of excuses
By Brett Gavaghan, Founder of Adaptd ·
Gemini in Google Apps Script is now generally available. Describe a repetitive task in plain English, and it writes the script and helps fix it when it breaks.
The short version
- Gemini in Google Apps Script is now generally available and writes scripts from a plain English description of the task.
- It is rolling out from 12 November 2026 on Workspace Business Standard and Plus, Enterprise Standard and Plus, and Google AI Pro and Ultra.
- Pick one repetitive spreadsheet or email task, describe it to Gemini and test the script on a copy of your data first.
Most businesses have a spreadsheet job someone does by hand every week, mostly copying things from one place to another. Google has just made it a lot easier to hand that job to a script.
What is Gemini in Apps Script?
Gemini in Apps Script is a side panel in Google's built-in scripting tool that writes the code for you from a plain English description. You'll find Apps Script under Extensions > Apps Script in Google Sheets and Docs.
You describe the task, for example turning a Sheets table into a formatted Docs report, and Gemini proposes the script. You accept or reject each block of code before saving. If the script throws an error, a Fix errors button in the execution log explains the problem in plain language and suggests a fix.
Who can use it, and when?
Gemini in Apps Script is rolling out from 12 November 2026 and can take up to 15 days to appear. It's included in Workspace Business Standard and Plus, Enterprise Standard and Plus, and Google AI Pro and Ultra, so Business Starter misses out.
Scripts run with each user's existing permissions, and admins can control access and see script activity in the Admin console.
Should your business use it?
Your business should try Gemini in Apps Script on one small, boring task you already understand well. You don't need to code, but you do need to describe the job clearly, the way you'd explain it to a new starter.
My advice: test every script on a copy of the spreadsheet, not the real one, and keep a note of what each script does and who made it. A script that emails clients on a timer is great until nobody remembers it exists. Worried this needs a developer? Google pitches it at people with no coding experience.
The best automation is the one that quietly does the copying and pasting while you get on with the job you're actually paid for.
Sources
Wondering what this means for your business?
That's exactly what the discovery call is for.