The News, Explained
On November 16, Google announced general availability of the Gemini side panel in the Apps Script editor. Apps Script is Google’s scripting environment for connecting Workspace tools such as Sheets and Docs to handle recurring work. After a public beta, the panel can draft code from a description, propose edits to existing code, and suggest fixes based on errors in the execution log. Source Source
Suppose you move weekly totals from a sheet to a document. Describe which table to read and how to lay out the figures, then inspect the changes in the editor before applying and saving them. Saving code by itself gives it no immediate access to the sheet or document. When a script that needs approval runs for the first time, Google may ask for access through its usual permission prompt. The script remains subject to the applicable user permissions and organisation policies. Source Source
Google says it began rolling out the feature on November 12 to both Rapid and Scheduled Release domains, with up to 15 days for it to appear. Eligible options include Business and Enterprise Standard or Plus, Google AI Pro and Ultra for individuals, and specified Workspace and education add-ons. For organisations, existing administrator settings for Apps Script and generative AI still apply. Source
OYOPICK’s Take
A faster first draft is useful if it leaves more time for review. For a weekly report, try putting the result in a copy before allowing the script to overwrite the working document. Compare the totals and column order, then see whether the permissions requested make sense for that job. Code that looks plausible is a different test from being able to explain what it will do to the team’s data.