Tag Archives: apps

FINRA Compliance for Google Workspace: Google Drive and Calendar Updates

What’s changing 

Today, we announced Google Workspace support for FINRA compliance, continuing our commitment to meet the unique needs of heavily regulated industry. This includes the preservation of records in a non-rewritable, non-erasable (WORM) format, including support for SEC Rule 17a-4, SEC Rule 18a-6, and CFTC §1.31. 

We’re pleased to announce FINRA-compliant solutions for Google Drive and Calendar (complementing our existing FINRA-compliant features for Gmail, Chat, and Meet) that address the critical supervisory, documentation, and surveillance requirements that underpin financial regulations: 

For Google Drive, super admins can now use Google Workspace’s Data Export tool and AODocs to create a FINRA-compliant archive of their Google Drive data in a Google Cloud Storage (GCS) bucket. This data can be from specific organizational units (OUs), groups, or users, and filtered by Drive labels.

When you’re using the Data Export tool, select “FINRA” as your export type

For Calendar, super admins and admins with third-party archiving privileges can enable third-party archiving on an OU or group level and specify the email address to which Calendar archives should be sent. The following events will be captured: 
  • On the monitored user’s calendar: all events and their updates, including events modified by another user with the appropriate access to the monitored user's calendar 
  • On other calendars that the monitored user can make changes to: all actions performed by the monitored user 
When these actions are performed, an email is sent to the journaling address specified by the admin with the event data, user who performed the action, and time stamp. providing access via SMTP for a third-party service provider to archive and produce the records on demand.
Third-party archiving can be enabled in the Admin console by going to Apps > Google Workspace > Settings for Calendar > Third-party Archiving Settings

Who’s impacted 

Admins 

Why it’s important 

These updates are critical for Google Workspace customers operating in the financial services industry on a global scale. For Calendar, archival journaling functionality supports compliance news by ensuring electronic communications are captured and preserved, meeting essential record-keeping standards. For Drive, admins can manage and securely store critical documents at scale. These solutions add to our existing FINRA-compliant features for Gmail, Chat, and Meet (when certain settings are enabled and disabled), providing global communication solutions and cutting edge productivity tools that meet the regulatory needs of customers in the financial services sector. 

Additionally, we are proud to announce partnerships with several industry-leading Digital Communications Governance and Archiving (DCGA) vendors: AODocs, Mimecast, Smarsh, and Global Relay. These partners provide vital connectors for our customers, ensuring the compliant flow of Google Workspace data into their trusted archiving solutions. For more information on these partnerships and FINRA compliance for Google Workspace, visit the Workspace blog.

Getting started 


Rollout pace 


Availability 


Resources

Google Vids is now available for all Google Workspace for Education customers

What’s changing

Last year, we empowered educators and students to easily create and collaborate with video by introducing Google Vids to Education Plus customers. Today, we’re excited to expand Vids to all Google Workspace for Education customers.* 

Vids can help deepen learning opportunities, up-level instruction, and inspire the next generation of storytellers in a variety of scenarios, for example: 
  • Educators can support diverse learning styles and help students retain information with instructional videos and deep dives on complex concepts. 
  • Students can work on video projects and review recorded lessons. 
  • Education leaders can easily incorporate video in their school newsletters and create internal training videos for staff. Vids is also integrated with Google Workspace for Education tools like Google Classroom, empowering educators to easily assign video projects or post video explainers right to their students. 
*Google Workspace for Education customers will receive access to GoogleVids, without AI features. 

Who’s impacted 

End users 

Why you’d use it 

Similar to other productivity tools like Docs, Sheets, and Slides, Vids includes an easy-to-use interface and the ability to collaborate in real-time and share videos securely from your browser. You can easily get started with a variety of templates organized by use cases to create a new video. From there, you can add motion with animations, transitions, and photo effects, and customize your video using the Vids royalty free education-friendly stock content library or your own media directly from Google Drive or Google Photos. 

Getting started 

  • Admins: 
    • Google Vids is a Workspace Core Service for Workspace for Education customers. 
    • Vids will be ON by default and can be disabled at the organizational level. However, if Google Docs are turned OFF in your domain, Vids access will be unavailable. 
    • Visit the Help Center to learn more about turning Vids on or off for users. 
  • End users: 
    • To start, open Google Vids and choose an option to create a new video. You can create a new video or make a copy of an existing video for editing. 
    • You can use Vids on your computer with the two most recent versions of these browsers: 
    • Dive into Google Vids with our free, self-paced online training course, designed specifically for educators and available now in the Google for Education Learning Center. You can also leverage this one pager to get a quick summary of what you can do with Vids. 
    • Visit the Help Center to learn more about getting started with Google Vids. 

Rollout pace 

Availability 

Available for Google Workspace: 
  • Education Fundamentals, Standard and Plus 
  • Customers with a Gemini Education or Education Premium add-on 

Resources 

Gemini in Google Classroom is now available to all Google Workspace for Education editions, with added features

What’s changing

Earlier today, we announced numerous updates across Google Workspace for Education that expand feature access and further our efforts to give education customers ​​new and powerful ways of working, teaching and learning with Gemini. 

Prior to today, Gemini in Classroom was only available to customers with a Gemini Education or Gemini Education Premium add-on. Starting this week, 18+ users across all Google Workspace for Education editions will now have access to more than 30 AI-powered tools. With the help of Gemini, educators can create content and resources through one central destination in Classroom. This update is accompanied by a new admin setting that controls whether certain users in a domain have access to Gemini in Classroom. 

Now, educators can get help creating first drafts of resources, based on learning objectives, with new features like: 
In addition, educators can now ask Gemini to refine (modify, transform, or supplement) generated content however they want in a chat-like experience for select features. They can also assign content generated with Gemini in Classroom – after reviewing and editing it – directly to assignments in classes with the “Add to class” button. They’ll be able to select a class, which will then create an assignment in the chosen class and attach the Drive file to it. 

Educators will also be able to collaborate with Gemini using starter prompts for the Gemini app that help with common tasks like: 
  • Brainstorming real world examples 
  • Gamifying an activity 
  • Generating differentiation strategies 
  • Drafting an exemplar and non-exemplar 
  • Creating Depth of Knowledge (DOK) questions 
For example, if you select the "Gamifying an activity” card, a pre-set prompt will be loaded into the Gemini app to help get you started. Then, you can collaborate with Gemini to continue iterating before sharing or exporting the content. 

Who’s impacted 

Admins and end users 

Why it’s important 

Educators can now use Gemini in Classroom - free of charge - for more than 30 common educator tasks, helping to give them time back to focus on the art of teaching, from supporting students more deeply to making their instructional ideas a reality. 

Additional details

Gemini in Classroom is only available in English for education users over the age of 18. 

Getting started 

Rollout pace 

Availability 

These updates impact: 
  • Education Fundamentals, Standard, and Plus
  • Education customers with the Gemini Education or Gemini Education Premium add-on* 
*Starting September 2025, the Gemini Education add-ons will be consolidated into a single add-on referred to as Google AI Pro for Education.

Resources 

Google Workspace Updates Weekly Recap – June 27, 2025

New updates

Unless otherwise indicated, the features below are available to all Google Workspace customers, and are fully launched or in the process of rolling out. Rollouts should take no more than 15 business days to complete if launching to both Rapid and Scheduled Release at the same time. If not, each stage of rollout should take no more than 15 business days to complete.

Providing support for Microsoft Office embedded files in Google Drive 
To ensure users have a seamless experience when working with Microsoft Office files, we’re excited to announce that users can now open Microsoft Office files that contain embedded PDFs in Google Drive. | Rolling out now to Rapid Release and Scheduled Release domains. | Available to Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts. | Visit the Help Center to learn more about working with Microsoft Office files

Use Imagen 4 to generate images in Google Docs, Slides and Vids in multiple languages 
Users can now utilize our highest quality image generation model, Imagen 4, which delivers: 
  • Outstanding text rendering and prompt adherence 
  • Higher overall image quality across all styles 
  • Multilingual prompt support in these 20+ languages 
Rolling out now to Rapid Release and Scheduled Release domains. | Available to Google Workspace Business and Enterprise users with access to Gemini in Docs and Slides, and users with access to Gemini in Vids. | Visit the Help Center to learn more about collaborating with Gemini Slides, Vids and Docs.
using spanish to generate visual content in Vids
View the most relevant search results in Gmail
Over the years, we’ve implemented updates to help you find exactly what you’re looking for with less effort when searching in Gmail. In March, we announced a smarter search feature powered by AI to quickly show users the most relevant results, and today we’re excited to extend this to businesses. Now, instead of just showing emails in chronological order based on keywords, Gmail search results will factor in elements like recency, most-clicked emails and frequent contacts. With this update, the emails you’re looking for are far more likely to be at the top of your search results — saving you valuable time and helping you find important information more easily. You can also select between “most relevant” and “most recent” results. | Rollout to Rapid Release and Scheduled Release domains is complete. | Available to Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts. | Visit the Help Center to learn more about the search in Gmail.
View the most relevant search results in Gmail

    A search view before and after. Now, search results are sorted by relevance instead of in chronological order to help you find your intended result, faster.

    Automated meeting recording, transcripts and notes available in seven additional languages
    Currently, when an Admin pre-configures meeting recordings, meeting transcripts, or “Take notes for me” in Meet as ON by default for newly created meetings, the artifacts are generated in English. Today, we’re expanding the language availability to include:
    • French
    • German
    • Italian
    • Japanese
    • Korean
    • Portuguese
    • Spanish
    The meeting artifacts will automatically be generated in the meeting host’s language if it is supported. | Rolling out now to Rapid Release and Scheduled Release domains. | Meeting recordings and transcripts are available to Google Workspace Business Plus; Enterprise Essentials, Enterprise Essentials Plus; Enterprise Standard, Plus; Education Plus, and the Teaching and Learning add-on. “Take notes for me” is available to Business Standard and Business Plus; Enterprise Standard and Enterprise Plus; the Gemini Education and Education Premium add-on and those customers who previously purchased a Gemini Business, Gemini Enterprise or AI Meetings & Messages add-on. | Admins visit the Help Center to learn more about choosing automatic meeting artifact settings for your organization. | End users visit the Help Center to learn more about recording a meeting, using meeting Transcripts, and taking notes with Gemini in Meet. Meeting hosts and co-hosts can edit these settings in the Calendar invite, as well as turn these artifacts off during the meeting.

    Studio lighting in Google Meet is now available on all devices 
    We’re pleased to announce that studio lighting in Google Meet is now available on all devices. Using machine learning, Gemini in Meet will simulate studio-quality lighting and adjust light position and brightness in your video feed, so you're perfectly lit for your meeting. | Available now. | Rollout to Rapid Release and Scheduled Release domains is complete. | Available for Google Workspace Business Standard and Plus, and Enterprise Standard and Plus. | Visit the Help Center to learn more about improving your video experience. 

    Video file uploads are now available to Google Workspace users in the Gemini mobile app 
    You can now upload videos stored on your mobile device to provide more context to your prompts in the Gemini mobile app. You can ask Gemini to summarize the video, ask Gemini specific questions about the video and more. | Rollout to Rapid Release and Scheduled Release domains is complete. | Available to all Google Workspace users with access to the Gemini app. | Visit the Help Center to learn more about how to upload and analyze files in the Gemini Apps

    Boost productivity with scheduled actions in Gemini 
    You can now use scheduled actions in Gemini to create personalized updates, set reminders, or complete routine tasks in a chat or based on existing prompts. You can set these actions to your preferred frequency, be it a single reminder, or daily or weekly updates. Some ways you can use scheduled actions are: 
    • Daily summaries of your calendar, to-do list, and unread emails for the day ahead. 
    • Daily news briefings: deliver a concise, easy-to-digest summary of the day’s top news stories or a specific topic. 
    • Competitive landscape monitoring: Monitor online news, press releases, social media content, and more based on a specific industry. 
    • Weekly vocabulary builders: Receive a curated list of new vocabulary words, complete with definitions and example sentences, tailored to your learning level. 
    Rollout to Rapid Release and Scheduled Release domains is complete. | Available with a qualifying edition of Google Workspace for Gemini on the web and mobile and in all supported languages. This feature is only available for users 18+ at this time. | Admins: For Gemini to access data from apps like Gmail, Calendar, and Drive, Workspace apps in Gemini must be turned ON. | End users: Visit the Help Center to learn more about scheduling actions in Gemini.

    Google Drive log events now include search related information 
    We’re expanding Drive log events in the security investigation tool to include search events. This includes information on resources returned from a search, the query the user entered, and more. Admins can use this information to help assess whether there is normal search behavior or whether the behavior was anomalous and indicating potential data exfiltration. This information can also be queried via API – check out our API documentation for more information. | Rollout to Rapid Release and Scheduled Release domains is complete. | Available for Google Workspace Business Starter, Standard, and Plus; Enterprise Starter, Standard, and Plus; Education Fundamentals, Standard, and Plus; Frontline Starter and Standard. | Visit the Help Center to learn more about Drive log events and the security investigation tool.
    Google Drive log events now include search related information

    Previous announcements

    The announcements below were published on the Workspace Updates blog earlier this week. Please refer to the original blog posts for complete details.

    Adding granular control options for who can respond to existing Google Forms 
    In addition to being available on newly created forms, we’re excited to announce that starting today this option is now available on existing forms. As a result, form creators can upgrade existing or old forms to have more granular controls over who can respond to them. | Learn more about controls for existing forms. 

    Google Classroom now supports exporting grades and importing data with STLink SIS 
    Google Classroom teachers can now export and import select information via the new integration with Bubblecon STLink, a South Korean third-party student information system (SIS) that provides an innovative edtech platform. | Learn more about Bubblecon STLink. 

    Changes to "Who can manage" and "Who can view" members in Google Groups starting September 15, 2025 
    There are upcoming changes to permissions in Google Groups which will be implemented starting September 15, 2025. | Learn more about changes to Google Groups.

    Generate data with Gemini in Google Sheets
    Currently, you can utilize Gemini in Google Sheets to generate charts and valuable insights, and this week, we’re excited to bring AI directly into the cells of your spreadsheet with the power of AI function. | Learn more about AI function in Sheets.

    See summaries of even more file types directly in Google Chat
    Earlier this year, we introduced the ability for users to easily summarize Google Docs, Slides, and Sheets files shared within a Google Chat conversation. Today, we’re excited to expand this feature to PDF, Office (Word, Excel, PowerPoint), CSV, txt, and zip files shared as Drive links in Chat. | Learn more about summaries in Chat.

    Updates to the GitHub app for Google Chat 
    We're announcing additional updates and functionality that improve upon the overall experience using the GitHub app for Google Chat. | Learn more about GitHub app for Google Chat.

    Gemini Add-ons will no longer appear under subscriptions in the Admin console for Workspace Business and Enterprise customers
    In January 2025, we announced our plan to bring premium AI features directly to our Business and Enterprise offerings, helping our customers and their users boost productivity, creativity, and innovation, transforming how they work. We also stopped charging for Gemini add-ons that you may have purchased previously for your Business and Enterprise offerings after January 31, 2025. | Learn more about add-on subscriptions.

    Introducing Google AI Ultra for Business: Providing Access to Advanced AI Features and Next-Gen tools
    We’re pleased to introduce Google AI Ultra for Business, a new Workspace add-on that provides the highest access to AI features and models and access to next-generation AI tools. | Learn more about Google AI Ultra for Business.

    Introducing more granular controls for multi-party approvals for sensitive admin actions
    Last year, we introduced multi-party approval (MPA), a security feature that requires an admin to approve certain sensitive actions initiated by another admin. Today, we’re enhancing this feature by giving admins more granular controls. | Learn more about granular controls for multi-party approvals.

    Completed rollouts

    The features below completed their rollouts to Rapid Release domains, Scheduled Release domains, or both. Please refer to the original blog posts for additional details.

    Rapid Release Domains: 
    Scheduled Release Domains: 
    Rapid and Scheduled Release Domains: 
    For a recap of announcements in the past six months, check out What’s new in Google Workspace (recent releases).

    Introducing more granular controls for multi-party approvals for sensitive admin actions

    What’s changing 

    Last year, we introduced multi-party approval (MPA), a security feature that requires an admin to approve certain sensitive actions initiated by another admin. Today, we’re enhancing this feature by giving admins more granular controls, specifically: 
    • Admins can now select which specific settings require multi-party approval. 
    • Admins can choose separate multi-party approval settings for actions that are supported via API and the admin console, such as single-sign on with a third-party identity provider
    • Super admins can now delegate specific admins to approve MPA actions using the new multi-party approval role for admins.
    You can configure multi-party approval on a per action basis by going to Security > Authentication > Multi-party approved settings in the Admin console


    Account > Admin Roles 

    Who’s impacted 

    Admins 

    Why it’s important 

    Multi-party approval adds an extra layer of security for sensitive actions taken in the admin console by ensuring sensitive actions are not implemented in a silo and, more importantly, helps prevent unauthorized or accidental changes from being made. 

    We understand each customer has their own unique definition of security and what constitutes a high-risk action. By introducing more granular controls, we’re giving our customers the authority to decide what features should be subject to multi-party approvals and who has the authority to review these actions, in a way that works best for them, rather than the experience being “all or nothing”. 

    Additional details 

    To further strengthen security around sensitive actions, admins now require both 'reviewer' and 'requester' privileges for a given action to conduct its MPA review. This ensures that the approving admin possesses the direct authority to perform the action themselves, reinforcing the integrity of the approval process and preventing approvals from individuals with inadequate underlying permissions.

    Getting started 

    • Admins: This feature is available for eligible Workspace customers with two or more super admin accounts. Multi-party approval is OFF by default and can be turned on in the Admin console by going to Security > Multi-party approval settings. Visit the Help Center to learn more about multi-party approval for sensitive actions and pre-built admin roles.
    • End users: There is no end user impact or action required.

    Rollout pace 

    Availability

    • Available to Google Workspace 
      • Enterprise Standard and Plus 
      • Education Standard and Plus 
    • Also available to Cloud Identity Premium customers 

    Resources 

    Introducing Google AI Ultra for Business: Providing Access to Advanced AI Features and Next-Gen tools

    What’s changing

    We’re pleased to introduce Google AI Ultra for Business, a new Workspace add-on that provides the highest access to AI features and models and access to next-generation AI tools, including: 
    • The Gemini app with our most capable AI models, including higher usage limits to Gemini 2.5 Pro, Veo 3 (our latest video generation model), and Deep Research. Subscribers will also soon get access to Deep Think, an enhanced reasoning mode for highly-complex math and coding. 
    • NotebookLM with higher usage limits and best model capabilities (coming later this year), as well as higher limits for Audio Overviews, notebooks, queries, and sources per notebook, along with custom notebook styles and response lengths. 
    • Access to Gemini in Workspace: Users on Business or Enterprise Standard and Plus plans already have access to Gemini in Workspace apps, like Gmail, Docs, Sheets and more. Users on other qualifying Workspace plans can get access to most of these features by adding Google AI Ultra for Business. 
    • Access to Flow, our AI filmmaking tool, built with and for creatives. Create cinematic scenes and stories, with access to Veo 3 and premium features, including the ability to reference images to create multiple clips in a story with consistency. 
    • Access to Whisk, a new AI image and video generation tool that helps creatives quickly explore and visualize new ideas using both text and image prompts. With Whisk Animate you can turn images into 8-second videos using Veo 2. 
    • Access to Project Mariner (currently US only): A research prototype to explore the future of streamlined human-agent interaction using natural language prompts. Assign AI agents to complete time-consuming tasks like research and data entry concurrently, so you can get more done while the agents work in the background.

    Additional details 

    • Workspace users accessing Gemini in Workspace, Gemini app and NotebookLM with a Google AI Ultra for Business license access these services as a core service with enterprise-grade data protections subject to the Google Workspace Terms of Service or your offline Workspace agreement. As a reminder, their content is not human reviewed or used for Generative AI model training outside their domain without permission. Learn more at the Generative AI in Google Workspace Privacy Hub
    • Several of these tools, including Whisk, Flow, and Project Mariner are not covered by the Workspace Terms of Service and have their own privacy policies. We encourage you to read these terms for more details. 
    • Visit the Help Center for a list of countries where the Google AI Ultra for Business add-on is available for purchase and where the included services are supported. Note: Some features may only be available in select regions. 
    • The Google AI Ultra for Business add-on grants the user 12,500 credits per month for use in Flow, Whisk, and any other products where credits exist. Learn how to manage your AI Credits.

    Getting started 


     Availability 

    The Google AI Ultra for Business add-on is available for self-serve purchase* beginning on June 26, 2025 with the following Google Workspace editions: 
    • Business Starter, Standard, and Plus 
    • Enterprise Starter, Standard, and Plus 
    Note: Currently, Google AI Ultra for Business is not available everywhere Google Workspace is sold and some services or features may only be available in select regions. Visit the Help Center for more detail. 

    We're working to bring Google AI Ultra for Business to our G Suite Legacy Free Edition and Education customers, and we look forward to sharing more about this in the coming weeks. 

    *Self-serve purchase available through the Google Workspace Admin Console. Direct and resold purchasing channels will be available at a later date.

    Resources 

    Gemini Add-ons will no longer appear under subscriptions in the Admin console for Workspace Business and Enterprise customers

    What’s changing

    In January 2025, we announced our plan to bring premium AI features directly to our Business and Enterprise offerings, helping our customers and their users boost productivity, creativity, and innovation, transforming how they work. We also stopped charging for Gemini add-ons that you may have purchased previously for your Business and Enterprise offerings after January 31, 2025.

    This week, as part of a shift in our offerings, we will begin removing references to the Gemini Enterprise, Gemini Business, AI Meetings & Messages, and AI Security add-ons from the Subscriptions page within the Admin console (Menu > Billing > Subscriptions). This change will apply to customers whose Workspace edition now includes all functionality previously available with these add-ons. 

    For example, if you had a Workspace Business Standard or Enterprise Standard subscription and a Gemini Business add-on, the add-on is no longer needed since the applicable AI features are now included in your Workspace subscription.

    Important note: There will be no disruptions in service or changes in feature availability with this change. This change will have no effect on your bill.

    Getting started

    • Admins: No action is needed – we will make these updates to the Subscriptions page automatically. 
    • End users: There is no end user impact or action required.

    Rollout pace

    • This update will begin taking effect starting June 25, 2025 and may take several weeks to rollout for affected customers.

    Availability

    • This update impacts Google Workspace customers who previously purchased Gemini add-ons

    Resources

    Updates to the GitHub app for Google Chat

    What’s changing 

    Last year, we made updates to the Google Chat integration with GitHub, a cloud-based platform that enables users to store, share and collaborate with others to write code. Today, we’re excited to announce additional updates and functionality that improve upon the overall experience using the GitHub app for Google Chat. 

    Starting today, users will have the ability to: 
    • Choose from additional controls for repository notification subscriptions, allowing users to set notifications according to their needs. For example, users can subscribe only to notifications when a deployment fails, or set notifications for Pull Requests assigned only to a particular individual. 
    • Create scheduled reminders, providing a new way for teams to stay on top of open pull requests. 
    • Set personal reminders to help keep track of pull requests that require review. 
    Users can set up scheduled reminders to stay on top of open pull requests
    Users can set up scheduled reminders to stay on top of open pull requests

    Granular notification filters enable users to subscribe to notifications based on their preferences.
    Granular notification filters enable users to subscribe to notifications based on their preferences.

    Getting started 

    Rollout pace 

    Availability 

    • Available to all Google Workspace customers, Workspace Individual Subscribers, and users with personal Google accounts 

    Resources 

    See summaries of even more file types directly in Google Chat

    What’s changing 

    Earlier this year, we introduced the ability for users to easily summarize Google Docs, Slides, and Sheets files shared within a Google Chat conversation. Today, we’re excited to expand this feature to PDF, Office (Word, Excel, PowerPoint), CSV, txt, and zip files shared as Drive links in Chat.

    Simply click the new “Summarize this file” button that appears within the respective file preview card in the conversation, and Gemini will summarize the file so you can get a quick overview without having to leave Chat. 

    See summaries of even more file types directly in Google Chat

    Who’s impacted 

    End users 

    Why you’d use it 

    By providing quick, on-demand summaries of files shared in Chat, Gemini helps you save time and get the gist of shared files instantly, eliminating the need to open each document. 

    Additional details 

    This feature is only available on web at this time. 

    Getting started 

    Rollout pace 


    Availability 

    Available for Google Workspace: 
    • Business Standard and Plus 
    • Enterprise Standard and Plus 
    • Frontline Plus 
    • Customers with the Gemini Education or Gemini Education Premium add-on 
    Anyone who previously purchased these add-ons will also receive this feature: 
    • Gemini Business* 
    • Gemini Enterprise* 
    • AI Meetings and Messages* 
    *As of January 15, 2025, we’re no longer offering the Gemini Business, Gemini Enterprise, and AI Meetings and Messages add-ons for sale. Please refer to this announcement for more details. 

    Resources 

    Generate data with Gemini in Google Sheets

    What’s changing

    Currently, you can utilize Gemini in Google Sheets to generate charts and valuable insights, and today we’re excited to bring AI directly into the cells of your spreadsheet with the power of AI function. 

    From a cell, you can now input a specific prompt describing what you would like to do and an optional data range, and Gemini can do the following: 
    • Use relevant information from your spreadsheet to generate text that is tailored to your specific data. 
    • Summarize information by analyzing the content of your spreadsheet and highlighting the most important parts, so you can quickly understand your data. 
    • Categorize your data into meaningful groups, so you can easily detect patterns, such as user sentiment. ai functions in sheets

    Here are some examples of how you’d use this feature: 
    • Text generation: 
      • =AI(“Write a formal ad copy for the product. Cater copy to the objective and target audience”, A2:C2
      • =AI("Create an email to the reviewer addressing specific items in their reviews.", A2:G2
    • Summarization: 
      • =AI("For the customer, write a one sentence summary of their feedback.", A2:D2
      • =AI("You are the owner of a pet sitting business. Write a 2 sentence summary for the customer about their pet’s last stay. Be a little funny.", F2
    • Categorization: 
      • =AI("Categorize the customer inquiry as a compliment, exchange request, or return request.",C2
      • =AI("Perform sentiment analysis on the emails sent by the customers to the barbershop.", C2)
    If you want to refer to two ranges that aren’t contiguous, you can use concatenation in the prompt. Here are a few examples: 
    • =AI("Write a review of the hot sauce "&A2&" using only the ingredients "&D2&" and the popularity "&E2&".", A2:D2
    • =AI("Find the major themes in the customer feedback of "&B2&" using the rating "&C2&" and comments: "&D2&".") 

    Who’s impacted 

    End users 

    Why you’d use it 

    Now you can create hundreds of rows of data quickly to do things like categorize user feedback requests or write personalized emails, all without being an expert in data or spreadsheets. Regardless of your data needs, with instant access to Gemini from any cell in your Sheet, the Al function helps you get work done faster. 

    Additional details 

    • We currently support text-based responses for text generation, summarization, categorization, and sentiment analysis queries. While the input information is optional, we recommend using it for optimal results. 
    • After generating, if an explicitly referenced cell or the prompt is updated, the cell shows an out-of-sync state, and keeps the previous output for reference. 
    • To refresh a cell, you can select one or multiple cells and press “refresh and insert.” 
    • You can select multiple cells with AI functions and generate outputs; however, only the first 200 selected cells with AI functions will be generated. You can wait for the generation to complete and select more cells to generate outputs. 

    Getting started 

    Rollout pace 

    • Rapid Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on June 25, 2025 
    • Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on July 29, 2025 

    Availability 

    Available for Google Workspace: 
    • Business Standard and Plus 
    • Enterprise Standard and Plus 
    • Customers with the Gemini Education or Gemini Education Premium add-on 
    • Google AI Pro and Ultra 
    Anyone who previously purchased these add-ons will also receive this feature: 
    • Gemini Business* 
    • Gemini Enterprise* 
    *As of January 15, 2025, we’re no longer offering the Gemini Business and Gemini Enterprise add-ons for sale. Please refer to this announcement for more details. 

    Resources