Tag Archives: Gemini

Generate charts and valuable insights using Gemini in Google Sheets

What’s changing 

Building data visualizations and identifying trends in data is a critical business function, however it can be time consuming and oftentimes overwhelming. To improve upon this experience, we’re making it easier for Sheets users, ranging from small business owners to marketing analysts, to visualize and analyze data using Gemini in Sheets. 

Starting today, Gemini in Sheets can perform actions or answer questions to address a wide variety of scenarios. Specifically, you can ask Gemini questions about your data and Gemini can provide valuable insights, such as contextual trends, patterns, and correlations between different variables in your data. Gemini will also generate charts based on your data that you can insert as static images over cells in your spreadsheet. For example: 
  • A marketing manager analyzing campaign performance can ask "Provide some insights on my top 3 performing channels by conversion rate" and can receive a detailed breakdown with supporting visualizations. 
  • A small business owner managing cash flow can ask "Predict my net income for the next quarter based on historical data" to proactively identify potential shortfalls. 
  • A financial analyst investigating inventory trends can ask "Identify any anomalies in inventory levels for Product X" to uncover potential supply chain issues or unusual demand patterns. 
Ask Gemini in Sheets to share insights and trends from the data.
Ask Gemini in Sheets to share insights and trends from the data.

Ask Gemini in Sheets to visualize data with a chart or bar graph.
Ask Gemini in Sheets to visualize data with a chart or bar graph.



Who’s impacted 

End users 


Why you’d use it 

This update reflects Gemini in Sheets’ enhanced intelligence as it now yields valuable outputs by transforming your requests into Python code, executing on them and then analyzing the results to perform multi-layered analysis. As a result, you’re able to do things like identify top-performing products and then instantly dive into their sales trends — all without writing a single line of code. 


Additional details 

  • For the most accurate results, ensure your data is in a consistent format, with clear headers and no missing values. 
  • When asking Gemini in Sheets to analyze your data, be as specific as possible in your prompts to ensure Gemini understands your request. 
  • For complex analysis, Gemini in Sheet's performance is most consistent in files below 1 million cells. 
  • For some simpler questions about your data, Gemini in Sheets may still provide answers using formulas instead of Python code. 
  • Charts are generated as static images and can be easily inserted into your sheet. 
  • Charts are not linked to your sheet data, so they won't update automatically if your data changes. 
  • Once inserted, charts cannot be modified. If you need to make changes, you'll need to generate a new chart. 

Getting started 

Rollout pace 

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 One AI Premium 
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 

Generate vocabulary lists using Gemini in Google Classroom

What’s changing 

Since May of last year, education institutions have been leveraging new and powerful ways of working, teaching and learning with Gemini for Google Workspace. This includes products and features such as the Gemini app, Gemini Learning Tools Interoperability (LTI™), Gemini in Google Vids and Gemini in Classroom.

In continuing our efforts to ensure AI helps educators save time, create captivating learning experiences, and inspire creativity, we’re introducing a new way to generate vocabulary lists with the help of Gemini. 

Starting today, educators can generate custom word lists that are tailored to specific grade levels and topics identified by the educator. Specifically, the list will provide the word’s grammatical category, a clear definition, and a relevant example sentence to help students understand and use the vocabulary effectively. This functionality is accessible via the “Gemini Education” tab in Google Classroom. 

creating a vocab list using gemini in classroom


Who’s impacted 

Admins and end users 


Why it’s important 

This update helps educators create vocabulary lists tailored to specific grade levels and topics while simultaneously empowering students to master vocabulary and deepen their understanding of language – all right within Google Classroom. 


Getting started 


Rollout pace 


Availability 

Available for Google Workspace customers with these add-ons: 
  • Gemini Education and Education Premium 

Resources 

Use Gemini to interact with PDFs in Google Drive’s overlay file previewer

What’s changing

Earlier this year, we introduced the ability to use Gemini in Google Drive to interact with PDFs. To improve your viewing experience when reviewing PDFs from Drive, we’re excited to announce that Gemini in the side panel of Drive is now integrated into Drive's overlay file previewer. 

As a result, you can seamlessly switch between multiple files while leveraging AI capabilities using Gemini in Drive to do things like: 
  • Admins: To access Gemini in the side panel of Workspace apps, users need to have smart features and personalization turned on. Admins can turn on default personalization setting for their users in the Admin console. 
  • End users:
    • To access this feature, double-click on a PDF from the Google Drive file list and click on "Ask Gemini" (star button) in the top right corner. 
    • Note: When Gemini initially launched in Workspace, PDFs viewed in Drive opened in a new browser tab to allow interaction with the Gemini side panel. With this update, the default behavior will open a file in the overlay file previewer. If you prefer for PDFs to open in a new tab by default, you can update your PDF opening default behavior in your Drive settings. If you previously set a preferred PDF opening default behavior in your Drive setting, your default open behavior will remain the same. 
    • Visit the Help Center to learn more about using Gemini in Drive to work with PDFs. 

Rollout pace 


Availability 

Available for Google Workspace customers with these add-ons: 
  • Gemini Business 
  • Gemini Enterprise 
  • Gemini Education 
  • Gemini Education Premium 
  • Google One AI Premium 

Resources 

Google Workspace Updates Weekly Recap – December 20, 2024

3 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.


Introducing instant video playback after uploads in Google Drive 
Following up on the recent announcement of a smoother, more modern video player in Google Drive, we’re excited to share that you can now watch videos the moment you upload them to Drive on web. This highly-requested feature eliminates wait times between upload and playback, while ensuring your videos still get fully processed. | Rollout to Rapid Release domains is complete; launch to Scheduled Release domains planned for January 2, 2025. | Available to all Google Workspace customers, Workspace Individual Subscribers, and users with personal Google accounts. | Visit the Help Center to learn more about storing & playing video in Google Drive.

instant video playback after uploading video to Google Drive

Updated keyboard shortcuts for Google Groups 
Google Groups is designed to work with keyboards, screen readers, braille devices, screen magnification, and more. We’re excited to improve the accessibility of Groups by introducing updated keyboard shortcuts. New and existing keyboard shortcuts will continue to work through early 2025, after which only new shortcuts will work. | Rolling out now to Rapid Release and Scheduled Release domains, with expected completion by January 13, 2025. | Available to all Google Workspace customers, Workspace Individual Subscribers, and users with personal Google accounts. | Visit the Help Center to learn more about using keyboard shortcuts in Google Groups.


SOC 1 compliance for Gemini 
We’re pleased to announce that the Gemini app on web and mobile has achieved SOC 1 compliance. This latest certification is in addition to SOC 2 and SOC 3, which the Gemini app achieved on web and mobile earlier this year. | SOC 1 is available now for Google Workspace customers with a Gemini Business, Enterprise, Education, or Education Premium add-on. Also available for Google Workspace customers accessing the Gemini app as a core service with a qualifying edition. | Visit the Help Center to learn more about how Google Workspace satisfies certification and compliance standards and about turning the Gemini app on or off for your users.


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.


Available in open beta: migrate messages from Microsoft Teams to Google Chat 
We're expanding our data migration experience to include the ability for Google Workspace admins to migrate conversations from channels in Microsoft Teams to spaces in Google Chat, making it easier for organizations to onboard and deploy Chat. | Learn more about migrating messages from Microsoft Teams to Google Chat. 


Available in open beta: Set up Single-Sign On with custom OpenID Connect profiles 
Via open beta, admins now have the option to set up a custom OpenID Connect (OIDC) profile for single sign-on (SSO) with Google as their Service Provider. | Learn more about Single-Sign On with custom OpenID Connect profiles. 


Now generally available: Monitor and manage AppSheet usage in your organization with the AppSheet Admin console 
All Google Workspace Admins with the AppSheet service privilege can access the AppSheet Admin Console. | Learn more about the AppSheet Admin console. 


Control whether your users can add account recovery information with two new admin settings
We’re launching two new settings that will allow admins to control whether their users can add recovery email information and phone information to their Google Workspace account. | Learn more about the new admin settings.


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.


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).

NotebookLM Plus now available to Google Workspace customers

What’s changing

Today, we’re announcing that NotebookLM Plus, our newest and most advanced version of NotebookLM, is available to Gemini for Google Workspace customers. In addition to what's already included with NotebookLM, which we introduced in September, this enhanced version allows users to: 
  • Get 5x more Audio Overviews, queries, notebooks, and sources per notebook 
  • Customize the style and length of their notebooks 
  • Create shared notebooks for their team and get usage analytics 
  • Use with confidence knowing their sources, queries and responses stay within their organization 
example of a strategic account planner and customer insights in NLM Plus


Who’s impacted 

Admins and end users (18+) with a Gemini for Google Workspace add-on or Gemini Education add-on. 
  • NotebookLM Plus is available in 180+ regions where Gemini API is available and currently supports 35+ languages. For Audio Overviews, while you can upload sources from all supported languages, the spoken audio is currently only available in English. 
  • See the ‘Getting started’ section below to learn more about adding Gemini to your Google Workspace plan. 

Why you’d use it 

NotebookLM Plus supercharges productivity and collaboration through AI that’s grounded in the information you provide. For example: 
  • Sales teams can add their product roadmap and feature specs, competitor benchmarking analysis, customer audio interviews, and market research to NotebookLM Plus. As a result, NotebookLM can help you prepare for customer meetings by creating an account plan to help your team find information faster and better engage with customers. 
  • Marketers can use NotebookLM Plus to help summarize customer trends and purchase behaviors, draft communications, create campaign briefs, and more–all based on market research, customer segmentation analysis, and marketing roadmaps. 
  • Educational customers can add their district’s strategy plan, education standards, lecture notes and/or course readings to get real-time summaries, guided lesson plans, discussion questions, quizzes and more. They can also generate audio overviews to take learning on the go and make content more accessible, digestible and engaging.

Additional details 

NotebookLM Plus is an Additional Service and is covered under the NotebookLM Plus for Workspace Additional Terms of Service.

As a Gemini for Workspace user of NotebookLM Plus, your uploads, queries and the model's responses are not used to train models and are not reviewed by humans. Your data remains your data and any files uploaded, queries and responses are not shared outside your organization’s trust boundary. 

Users can only upload sources from Workspace that they have permission to access. Furthermore, they can control who has access to their notebooks and set more granular permissions within each. Notebooks can only be shared within your organization. 


Getting started 

Rollout pace

Availability 

Available for Google Workspace customers with these add-ons: 
  • Gemini Business 
  • Gemini Enterprise 
  • Gemini Education 
  • Gemini Education Premium 

Resources