WorkGPT
Lines of Python code on a dark computer screen
Photo: Photo by Nemuel Sereti on Pexels

Gemini in Apps Script is out of beta and writes scripts from plain words

The Gemini side panel in Google Apps Script is now generally available, Google said on November 16, after a public beta earlier this year. You describe a repetitive task in plain words, and Gemini writes the script.

Gemini reads the files in your open Apps Script project. You can start a new automation from nothing or keep chatting to add to one, for example a trigger that runs it at a set time. Google's own examples include making Calendar events from urgent Gmail messages and turning Sheets tables into formatted Docs reports.

You stay in control of the code. Gemini shows its changes block by block, and you accept or reject each one, or all of them, before you save. When a script fails, a Fix errors button in the Execution log explains the problem in plain words and offers a fix.

Scripts run with your existing permissions and the usual consent screen, and admins keep their Apps Script and generative AI controls. Open it from Extensions > Apps Script in Sheets, Docs, Slides or Forms, or at script.new. It is on Business Standard and Plus, Enterprise Standard and Plus, and Google AI Pro and Ultra, with the rollout that began on November 12 taking up to 15 days.

What it means for your work

Many office chores sit one small script away from done: copying rows between sheets, sending a weekly report, filing form answers. Until now that script needed someone who could code. Try one task you repeat every week, and keep the first version small.

Read each block before you accept it, and test on a copy of your file, since a script acts on real data with your access. If you prefer no code at all, compare it with flows in Workspace Studio flows can now wait days before the next step.

Sources