News

ToolsNov 16, 20263 min read1 source

Gemini can now write Google Sheets/Docs automations from plain language

Act now

Google says Gemini can write and fix the scripts that automate Sheets, Docs, Slides and Forms, letting non-coders build simple automations.

Read it in

Drafted with AI· Nov 16, 2026

Tools · Nov 16, 2026

The distilled version

  • Google says Gemini in Apps Script is now generally available: describe a task in plain language and it writes the automation code for you.
  • It works inside Sheets, Docs, Slides and Forms, and Google says people with no coding experience can use it, including to fix errors in scripts that break.
  • Availability depends on your Workspace plan. Check what you’re on, then try it on one repetitive task this week.

What happened

Google announced on November 16, 2026 that the Gemini side panel in Google Apps Script is now generally available across Workspace. Apps Script is the built-in tool for customizing and automating Sheets, Docs, Slides and Forms, found under Extensions > Apps Script.

According to Google, anyone, including people with no coding experience, can describe a repetitive task in plain language and Gemini will write the script. Examples Google gives include creating calendar events from urgent Gmail messages, pulling and cleaning real-time data, and turning Sheets tables into formatted Docs reports. Users can review Gemini’s suggested code block by block, accepting or rejecting pieces before saving, and if a script breaks, a one-click “Fix errors” option gets Gemini to explain the problem in plain language and propose a fix.

Google says scripts run with the user’s existing permissions and standard OAuth consent, and admins keep visibility and control through the Admin console. The feature is rolling out gradually over up to 15 days, starting November 12, 2026, to Rapid Release and Scheduled Release domains. It’s available on Business Standard and Plus, Enterprise Standard and Plus, the AI Expanded Access add-on, Google AI Pro for Education, and Google AI Pro and Ultra for consumers.

Why it matters

Small businesses often have one or two people who know just enough Apps Script to patch together a spreadsheet automation, or nobody who knows any at all. This lowers that bar: you describe what you want in everyday language and get working code, plus help fixing it when it breaks, without hiring a developer.

What it means for your business

If you run the business: check which Workspace plan you’re on, since this only works on Business Standard and Plus, Enterprise Standard and Plus, or the other listed plans. If you’re eligible, pick one recurring manual task and see if Gemini can automate it.

What to do

Act now
  • Confirm your Workspace plan supports this (Business Standard/Plus, Enterprise Standard/Plus, or the other listed add-ons).
  • Open a spreadsheet or doc, go to Extensions > Apps Script, and try describing one repetitive task to Gemini.
  • Review the generated code block by block rather than accepting it all at once.
  • Test the script on a copy of real data for a few days before trusting it on live files.
  • Ask your IT admin to check Admin console settings and audit logs if several people start building their own scripts.

Act now: worth doing this month.

Hype check

The claim: Google says building automations now needs no coding experience at all.

The reality: You still need to describe the task clearly, review the code Gemini writes, and test it before trusting it with real data or sending anything automatically.

Jargon in this story

AutomationHuman in the loopPromptAPI

Sources

  1. 1Easily customize and extend Google Workspace with Gemini in Apps Script (opens in a new tab) · Google Workspace · Product update · Nov 16, 2026

Keep going: learn it, then do it.

03Automator14 min

Test an automation before you trust it

Run it on last month’s real cases and count what it got wrong.

Learn · 4 minTry it · 10 min
Start lesson
Agents & automation

Automations vs agents vs assistants

Three kinds of help, and how to tell which one a vendor is selling you.

5 min