Automation

Google Gemini Now Generates Apps Script Code from Plain English

Workspace users can automate Gmail, Sheets, and Calendar tasks without JavaScript knowledge, but IT teams must review permissions and generated logic.

Omega Editorial · November 17, 2026 · 3 min read

Key takeaways

  • Google Gemini in Apps Script is now generally available, generating JavaScript automations from plain-language descriptions for eligible Workspace users.
  • The feature works across Gmail, Sheets, Docs, and Calendar but requires users to review and authorize permissions before execution.
  • Business Standard and Plus, Enterprise Standard and Plus, and select Education and personal AI subscriptions have access; Starter editions do not.
  • IT administrators can control access through service settings, organizational units, OAuth restrictions, and audit logs to manage security risks.
  • Organizations should pilot with non-sensitive data and establish clear ownership for script maintenance before expanding access widely.

Google has made Gemini generally available in Apps Script, allowing eligible Workspace users to build custom automations using plain-language instructions instead of writing JavaScript. The feature, announced November 16, 2026, removes the coding barrier for connecting Gmail, Sheets, Docs, and Calendar.

Users describe their desired workflow in the Apps Script editor's side panel, and Gemini generates executable code. The system can create calendar events from urgent emails, clean and organize spreadsheet data, convert tables into formatted reports, and schedule recurring tasks. Generated code appears in reviewable blocks that users can accept or reject individually.

Why it matters

This capability extends automation development beyond technical staff, letting business users create custom workflows without developer support. However, generated scripts run with real Workspace permissions and can access sensitive data. Organizations must establish clear governance around which automations require technical review, who maintains generated scripts when requirements change, and how to audit what these automations actually do with company information.

Who can access the feature

Gemini in Apps Script is available to Business Standard and Plus, Enterprise Standard and Plus, Education AI Pro, and personal AI Pro and Ultra subscribers. Business Starter and Enterprise Starter editions are not included. The rollout began November 12 and may take up to 15 days to reach all eligible accounts.

Users access the feature by opening Apps Script directly or through Extensions > Apps Script in Sheets, Docs, or Slides. The Gemini side panel appears automatically for new projects or via the Ask Gemini icon in existing scripts.

What administrators should configure

IT teams can control access through Apps Script service settings, generative AI controls, organizational units, OAuth app restrictions, external URL allowlists, and audit logs. Generated scripts operate using the account holder's existing permissions through standard OAuth authorization.

Administrators should review both the generated logic and requested permissions before connecting scripts to sensitive systems. A generated script may request broader access than necessary or perform actions the user didn't anticipate, even if it follows existing permission boundaries.

Testing before wider deployment

Google recommends starting with a small pilot using non-sensitive data. Organizations should confirm eligible subscriptions, limit initial access to selected users, review generated code and OAuth scopes, test with nonproduction data, establish script ownership, and monitor execution logs.

Teams must also decide who maintains scripts when workflows change or APIs stop working. Google has removed the initial coding barrier, but someone still needs to understand what automations are allowed to access and modify.

Apps Script versus other Workspace automation

Google now offers multiple automation approaches. Apps Script generates inspectable JavaScript useful for custom logic, API calls, or functionality beyond standard features. Workspace Studio builds visual workflows and AI agents without direct JavaScript management. Workspace skills provide reusable instructions for recurring tasks.

For straightforward tasks supported by Studio, visual workflows may be easier to maintain. Apps Script offers more flexibility for custom behavior but creates additional testing and maintenance responsibilities.

Details were first reported by TechRepublic.

  • #google workspace
  • #apps script
  • #gemini
  • #automation
  • #low-code
  • #enterprise ai

This is an original analysis by the Omega editorial team. Source reporting: Automation Watch.

Want systems like this working for your business?

Book a Call

More in Automation