April 22, 2026
Build and edit complex spreadsheets with Gemini in Google Sheets
We’re excited to introduce new Gemini in Sheets capabilities that enable you to build and edit entire spreadsheets using simple natural language.
Whether you need a quick view of your small business's financial health or a complex project tracker, Gemini in Sheets orchestrates the multi-step construction from start to finish. Workspace Intelligence synthesizes data across your files, emails, chats, and the web to help you visualize your data with stylized tables, formulas, pivot tables, and charts.
Gemini in Sheets can handle complex, multi-step tasks that previously required expert-level knowledge of Sheets. For example, you can ask Gemini to do end-to-end creation to "build a P&L dashboard leveraging my historic service incidents and rate cards," or do side-by-side editing to “add scorecards and bar charts above my sales and inventory data”. Gemini will synthesize relevant information, construct a plan for your approval, and then build out the entire formatted spreadsheet.
Key capabilities include:
- End-to-end creation: Build entire spreadsheets from a single prompt, including data retrieval and formatting.
- Side-by-side editing: Refine and update existing models, budgets, or analysis directly in the side panel.
- Workspace Intelligence: Automatically pull context and data from other Workspace apps to ensure your spreadsheet is accurate and relevant.
- Advanced task fulfillment: Leverages Sheets’ most powerful tools, like pivot tables and complex formulas, without requiring manual configuration.
- Advanced optimization: Handle complex optimization problems that typically require complex manual formulas or third-party tools. Powered by research from Google DeepMind and Google Research OR-Tools.
- State-of-the-art performance: Gemini in Sheets achieved a 70.48% success rate in autonomously manipulating complex, real-world spreadsheets on the full SpreadsheetBench dataset, nearing human expert ability.
Getting started
- Admins: This feature is available by default if Gemini for Workspace in Sheets is enabled. Note that enabling Workspace Intelligence expands the range of supported use cases.
- End users: You must have Workspace smart features enabled to take advantage of these features. Eligible users will see the Gemini icon in the Sheets side panel. Simply describe the spreadsheet or edit you need to begin collaborating. Visit the Help Center to learn more about building and editing spreadsheets with Gemini in Sheets.
Note: Through July 15, 2026, Workspace customers will get promotional access to higher limits for the improved Gemini in Sheets experience, allowing users to experiment with this feature. Users will see a notification when they use this feature, informing them of the promotional access period. Per-user usage limits will apply after July 15; we’ll provide more information in the Help Center in advance of updated usage limits going into effect.
Rollout pace
- Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on April 22, 2026
- Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on May 6, 2026
Availability
- Business: Business Standard and Plus
- Enterprise: Enterprise Standard and Plus
- AI Add-ons: AI Expanded Access*; AI Ultra Access*; Google AI Pro for Education
- Consumer: Google AI Pro and Ultra
*Once promotional limits are no longer in effect, users with AI Expanded Access and AI Ultra Access add-on licenses will have higher limits on usage of Gemini in Sheets.
Resources
- Google Help: Build or edit entire spreadsheets with Gemini in Sheets
- Google Workspace Blog: Introducing Workspace Intelligence
- The Keyword: Gemini in Google Sheets just achieved state-of-the-art performance
- Workspace Updates Blog: Introducing Workspace Intelligence, with admin controls