Google Puts Gemini in Apps Script, and Spreadsheet Automation Starts Speaking Plain English
Describe repetitive work in everyday language; Gemini first generates a script, then you confirm it piece by piece. The barrier to entry is lower, but the need for review is not. Rolling out in batches; start by testing the waters with small scripts.
Google has connected Gemini to Apps Script and begun rolling it out in batches. Apps Script is an automation scripting platform inside Google Sheets, Docs, Gmail, and other apps; normally you have to write JavaScript. Now you can describe repetitive work in everyday language, and it first produces a script, then asks you to confirm it piece by piece. The news comes from the original post.
What can it do? Replies mention reports, scheduling, and reminders; even newcomers can gradually smooth out workflows. The scenarios are not complicated: each week, roll up multiple sheets into a report and change formatting by date; fill a shift schedule according to each person's shifts; send emails for due-date reminders. In the past, these required recording macros, looking up APIs, and repeated trial and error. Now, if you describe it clearly—'summarize Sheet A into Sheet C by column B, skipping blanks'—Gemini first gives you a draft. What you save is time on syntax and documentation lookups.
But don't rush to hand everything over. Some commenters remind us that having a script written first doesn't mean it's worry-free; automation needs human oversight and step-by-step confirmation, otherwise a spreadsheet going off track may not be noticed immediately. This judgment matters. Generating scripts lowers the difficulty of getting started, but the responsibility for acceptance is still with people. For non-technical users, the hard part shifts from whether they can write it to knowing why it is written this way. For developers, it is more like a draft generator; version control, edge cases, and exception handling are still up to them.
It is currently rolling out in batches, and it may be a few days before everyone sees it. When it arrives, start by testing the waters with a small script: one sheet, one clear input and output, run it once, and check the result. Whether the efficiency works is clearer from running it than from guessing.
发布时间: 2026-11-17 14:25