Author Archives:

Paste and convert unformatted text into Google Sheets tables with Gemini

We're excited to introduce a new AI-powered feature in Google Sheets that allows you to transform unstructured text into organized tables.

Manually formatting and organizing unformatted data in spreadsheets can be a tedious, time-consuming task. Now, when you paste content like bulleted lists, freeform text, or JSON we surface a “Convert to table” button which leverages Gemini to turn your pasted content into a table with just a single click. This helps to streamline data entry so you can move to analysis faster.

Getting started

Admins: This feature is an additional entry point to existing AI table generation functionality. This feature will be hidden if the Smart features for Google Workspace setting is disabled. Visit the Help Center to learn more about setting smart features controls on or off for users.
End users: You must have Workspace smart features enabled to use this feature. This feature will be ON by default for eligible users. To use it, simply paste text into a Sheet; if the content is suitable, a "Convert to Table" prompt will appear. Visit the Help Center to learn more about collaborating with Gemini in Google Sheets.

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
Education: Google AI Pro for Education
Consumer: Google AI Pro and Ultra

Resources

Google Help: Collaborate with Gemini in Google Sheets

Source: Google Workspace Updates

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

Source: Google Workspace Updates

New Gemini capabilities in Google Docs help you go from blank page to brilliance

We’re reimagining the AI writing experience in Google Docs to help you move from a blank page to a finished document faster than ever. Google Docs is evolving from a traditional word processor into a collaborator that understands your organization’s context.

Reimagined Gemini experience in Docs

Google Docs now offers a centralized place to generate, write, and refine your documents with Gemini. Powered by Workspace Intelligence, Gemini leverages data across Drive, Gmail, Chat, and the web to provide personalized, context-aware assistance.

The upgraded Help me create experience enables you to generate relevant, fully formatted first drafts that synthesize information from your files, emails, chat, and the web.
With Help me write, simply prompt Gemini from the new bottom bar or side panel to make edits across your doc, or select text to focus Gemini’s attention. Gemini’s suggested edits are only visible to you until you approve them.
Match writing style helps maintain a consistent tone and style across your entire doc, no matter how many people are working on it.

To generate new docs from scratch, open a new doc, enter your prompt, and click submit. To edit existing docs, simply hover over the spark near the bottom of your doc and type a prompt in the bottom bar.

Generate on-brand documents using your existing docs and templates

Looking to quickly populate a template or replicate the refined style of your favorite docs? With Match doc format, Gemini can now mirror a source document to generate content that adheres to the original's formatting (e.g., fonts and colors) and structural elements (e.g., headings and table columns).

Note that we’re launching these features in English first, with Spanish, Japanese, Brazilian Portuguese, French, German, Italian, and Korean support to follow soon after.

Getting started

Admins: These features are available by default if Gemini for Workspace in Drive is enabled. Note that enabling Workspace Intelligence expands the range of supported use cases.
End users: You must have Workspace smart features enabled to use these features. Visit the Help Center to learn more about creating personalized documents with Gemini in Google Docs.

Note: Through June 1, 2026, Workspace customers will get promotional access to higher limits for Match writing style and Match document format tools within the upgraded Gemini in Docs, allowing users to experiment with this feature. Per-user usage limits will apply after that date; 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
Education: Education Plus
Consumer: Google AI Pro and Ultra
AI Add-ons: AI Expanded Access*; AI Ultra Access*; Google AI Pro for Education*
Other Add-ons: Teaching and Learning

*Once promotional limits are no longer in effect, users with AI Expanded Access, AI Ultra Access, and Google AI Pro for Education add-on licenses will have higher limits on usage of Match writing style and Match document format tools.

Resources

Google Help: Write & edit with Gemini in Google Docs
Google Help: Create personalized documents with Gemini in Google Docs
Google Workspace Blog: Introducing Workspace Intelligence
Workspace Updates Blog: Introducing Workspace Intelligence, with admin controls

Source: Google Workspace Updates

Introducing Workspace Intelligence, with admin controls

Today, we announced Workspace Intelligence, an underlying AI system that provides Gemini with a real-time understanding of your work across Google Workspace. With Workspace Intelligence, all of your generative AI tasks within Workspace will be grounded in your Workspace data across Gmail, Chat, Calendar, and Drive (including Docs, Sheets, and Slides), eliminating the need for users to manually provide context to Gemini on every query.

As an administrator, you can control which data sources Workspace Intelligence can use for your organization via new settings in the Admin console.

Impact of disabling data sources

If you turn off Workspace Intelligence for a data source, generative AI features will not actively search for content from the disabled source. However, if a user adds a specific source to their prompt, that source will be used in Gemini's response. For example, if you turn off Drive as a source, users can still ask Gemini about specific files. Gemini will consult these specific files, but it won't actively search for other files. We recommend keeping access to all data sources ON to ensure optimal performance of AI features across Workspace.

Strong privacy protections

These changes align to our existing data handling practices and privacy commitments. AI features respect user-level content access, ensuring that responses are grounded only in content that a user already has permission to view. Your data is never used to train generative AI models or for advertising purposes.

Getting started

Admins: Workspace Intelligence is ON by default; admins can disable access to certain data sources at the domain, OU, or group level. Visit the Help Center to learn more about controlling Workspace Intelligence for generative AI features.
End users: There is no end user setting for this feature.

Rollout pace

Rapid Release and Scheduled Release domains: Full rollout (1–3 days for feature visibility) starting on April 22, 2026

Availability

Business: Business Starter, Standard, and Plus
Enterprise: Enterprise Starter, Standard, and Plus
Education: Education Plus
Other Editions: Frontline Plus, Enterprise Essentials, and Enterprise Essentials Plus; Nonprofits
AI Add-ons: AI Expanded Access; AI Ultra Access; Google AI Pro for Education
Other Add-Ons: Teaching and Learning