What Is It?

Starting April 22, 2026, Google is rolling out significant enhancements to Gemini in Google Sheets. This update empowers users to create and refine entire spreadsheets through simple natural language prompts. Whether you are managing small business finances or complex project trackers, Gemini acts as an orchestration engine, handling the heavy lifting of spreadsheet construction from the very beginning.

Key Features

auto_awesomeEnd-to-End Creation
Generate entire spreadsheets, including data retrieval, formatting, and complex structures, from a single prompt.
settingsSide-by-Side Editing
Refine your existing budgets, models, or data analyses directly via the side panel, keeping your workflow seamless.
cloudWorkspace Intelligence
Automatically pull relevant context from your emails, chats, and Drive files to build accurate and data-rich spreadsheets.

What Is the Impact?

info
The impact of this update is profound for business professionals who rely on data but often lack the time to master complex spreadsheet functions. By leveraging advanced research from Google DeepMind, Gemini can now navigate sophisticated optimization tasks that previously required expert-level knowledge. This effectively democratizes data analysis, allowing you to derive insights without needing to be a spreadsheet guru.

Furthermore, the 'Workspace Intelligence' feature eliminates the friction of siloed information. Gemini understands the context across your entire Google Workspace environment, enabling it to suggest tables, pivot tables, and formulas based on the actual content of your organization's files. This integration drastically reduces the time spent on manual data entry and cross-referencing.

Finally, the performance gains are industry-leading. With a 70.48% success rate on the SpreadsheetBench dataset, Gemini is now approaching human expert performance in spreadsheet manipulation. This provides a high level of confidence that the logic, formulas, and visual formatting generated by the AI are reliable for professional use cases.

Gemini in Google Sheets

Who Is It For?

These features are designed for professionals who need to work smarter, not harder. Specifically, it is available for users with the following licenses:

  • check_circleBusiness Standard and Plus subscribers.
  • check_circleEnterprise Standard and Plus users.
  • check_circleGoogle Workspace accounts with AI Add-ons (e.g., AI Expanded/Ultra Access).
  • check_circleOrganizations looking to streamline reporting and data visualization tasks.

When Will It Roll Out?

The rollout is occurring in phases:

  • Rapid Release Domains: Gradual rollout starting April 22, 2026 (up to 15 days for visibility).
  • Scheduled Release Domains: Gradual rollout starting May 6, 2026 (up to 15 days for visibility).

What Should You Do?

To get started with Gemini in Sheets, follow these steps:

1
Step 1: Check Eligibility
Ensure your account has a supported Business or Enterprise license with the necessary AI add-ons enabled.
2
Step 2: Enable Smart Features
Navigate to
Settingsarrow_forward_iosAccount Settingsarrow_forward_iosSmart Features
and ensure all Workspace smart features are toggled on.
3
Step 3: Access the Sidebar
Open any Google Sheet and click the Gemini icon in the side panel to start your first prompt.
warning
Note: Promotional usage limits are in effect until July 15, 2026. After this date, standard usage limits will apply. Keep an eye on the Workspace Updates blog for further details.