Generate charts and valuable insights using Gemini in Google Sheets

Qué está cambiando 

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.

A quién afecta 

Usuarios finales 

Por qué utilizarlo 

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. 

Más información 

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

Para empezar 

Ritmo de implantación 

Disponibilidad 

Disponible para Google Workspace:
  • Empresas Standard and Plus 
  • Empresa Standard and Plus 
  • Customers with the Gemini Education o Gemini Education Premium add-on 
  • Google One AI Premium 
Anyone who previously purchased these add-ons will also receive this feature: 
  • Géminis Business* 
  • Géminis 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. 

Recursos 

Curate and customize the Chrome Web Store for your organization

Qué está cambiando

Admins can now customize the Chrome Web Store experience for their users with several new options, including:

  • Branding and custom messaging: Add company logos, custom welcome banners and announcement banners.
  • Curated collections: Organize specific extensions for your users, including recommended and private extensions. We have also introduced a new collection of extensions that displays all items that are allowlisted by IT administrators.
  • Category controls: Hide specific extension categories to help streamline the browsing experience for users.

Additionally, we’ve enhanced the Chrome Web Store search experience. In the search results. end-users can quickly notice blocked item tags, and they can benefit from more advanced filtering such as a “Private items” filter.  

Example of a customized Chrome Web Store

A quién afecta

Administradores y usuarios finales

Por qué es importante 

Every Google Workspace customer has unique users with unique needs – Chrome extensions can help improve their workflows and increase productivity. However, navigating the numerous available extensions can present challenges for both admins and end users. For admins, it is often a manual and time consuming process to vet which Chrome extensions they want to allow for their users. For end users, it can be frustrating to sift through a vast catalog of extensions to find relevant and admin-approved extensions.
This update significantly improves the Chrome Web Store experience for enterprises. Admins can customize, organize, and control the Chrome Web Store experience for their users. For end users, finding work-relevant and admin approved extensions becomes significantly easier cutting down on guesswork or wasted time searching for extensions that might be blocked.

Para empezar

  • Admins: Four new Apps & Extensions settings have been added to the Chrome section of the Admin console. To find the new settings, go to Menu > Chrome Browser > Apps and extensions > Navigate to the “Settings” tab > Chrome Web Store settings. Visite el Centro de ayuda para obtener más información sobre customizing the Chrome Web Store for your users.

Ritmo de implantación

Disponibilidad

  • Available for all Google Workspace customers with access to the Admin console

Recursos

Use Gemini in the side panel of Workspace apps to generate images in seven additional languages

Qué está cambiando

Tras la anuncio reciente of being able to use Gemini in the side panel of Workspace apps in seven additional languages, we’re excited to announce that image generation is now supported in the following languages as well: 
  • French 
  • German 
  • Italian 
  • Japanese 
  • Korean 
  • Portuguese 
  • Spanish 
using gemini to generate an image of coffee in Spanish

Más información 

  • Although Gemini is generally available in the side panel of Docs, Sheets, Drive, and Gmail in these languages, users with Gemini alpha features enabled may still see the “Alpha” badge as we continue rolling out more alpha features 
  • Image generation of people is not supported at this time in these additional languages. 
  • Gemini in the side panel of Slides is only available in English at this time. 

Para empezar 

  • Admins: There is no admin control for this feature. 
  • Usuarios finales: You can access the side panel by clicking on “Ask Gemini” (spark button) in the top right corner of Docs, Sheets, Drive, and Gmail on the web. Visit the Help Center to learn more about collaborating with Gemini in the side panel of Docs, Sheets, Drive, and Gmail. Note that for accessing other Gemini for Google Workspace features that are supported in English only, you will need to set your Google Account language to English

Ritmo de implantación 

Disponibilidad 

Image Generation in the side panel of Gmail only is available for Google Workspace: 
  • Empresas Inicio 
  • Empresa Inicio 
Image Generation in the side panel of Docs, Sheets, Drive, and Gmail is available for Google Workspace: 
  • Empresas Standard and Plus 
  • Empresa Standard and Plus 
  • Customers with the Gemini Education o Gemini Education Premium add-on 
  • Google One AI Premium 
Anyone who previously purchased these add-ons will also receive this feature: 
  • Géminis Business* 
  • Géminis 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. 

Recursos 

Better understand app access with the new Access Evaluation log event

Qué está cambiando 

We’re introducing a new log event, Access Evaluation, which will help admins better understand how security policies affect their users’ access to OAuth apps. This includes settings and policies such as Controles API, endpoint management configurations, domain wide delegation and more. The log contains information on the specific policies applied, when access was granted and the reasoning. Admins can use this information to review their security policies and revise them as needed to protect the sharing of Workspace data with users’ apps.
Example of an Access Evaluation log

Para empezar

  • Admins: Access Evaluation are available in the herramienta de auditoría e investigación (Menu > Reporting > Audit and investigation > Access Evaluation log events), and the herramienta de investigación de seguridad (Menu > Security > Security center > Investigation tool > Data source > Access Evaluation log events)  for specific Google Workspace editions. Visit the Help Center to learn more about Access Evaluation log events. 
  • Usuarios finales: There is no end user impact or action required.

Ritmo de implantación

Disponibilidad

  • Available in the herramienta de auditoría e investigación for all Google Workspace customers.
  • Available in the herramienta de investigación de seguridad for Google Workspace:
    • Frontline Estándar
    • Empresa Standard and Plus
    • Education Standard and Plus
    • Enterprise Essentials Más
    • Cloud Identity Premium

Recursos

Logitech Android devices for Google Meet can now join Webex and Zoom calls

Qué está cambiando

We’ve been working to expand our customers’ calling networks through interoperability between Google Meet hardware devices, and other third-party video conferencing apps and devices. Beginning today, we’re expanding this interoperability to include support for Cisco Webex and Zoom on Logitech Android-based hardware devices for Google Meet. These include  Logitech Rally Bar, Rally Bar Mini, and Rally Bar Huddle appliances. These Google Meet hardware devices now have the embedded capability to call directly into Cisco Webex and Zoom calls, which allows  users to collaborate with more customers and partners outside their companies. 

This feature is already supported on ChromeOS-based Google Meet hardware devices from Logitech. 

Para empezar

  • Usuarios finales: 
    • When enabled by your admin, you can join a Webex or Zoom meeting from a Logitech Android-based Google Meet hardware device: 
      • Join an ad-hoc call by tapping “Find a meeting” on your touch controller and selecting Webex or Zoom from the dropdown options. 
      • Join a scheduled call by adding a room to an event with Webex or Zoom meeting details.  
        • Note: Calendar events that originate outside of Google Calendar must be duplicated and populated with room details manually.
    • Visite el Centro de ayuda para obtener más información sobre Interoperabilidad de Google Meet.

Ritmo de implantación

Disponibilidad

  • Disponible para todos los clientes de Google Workspace con dispositivos de hardware Google Meet

Recursos

More options now available to customize digital signage on your Google Meet hardware

Qué está cambiando 

In the coming weeks, admins will be able to use their Comeen o StratosMedia digital signage content on their Google Meet hardware devices. We know many of our customers use these tools for general digital signage needs within their organization and this update allows that content to be leveraged as screensavers across your Google Meet hardware fleet.
The Google Meet hardware ‘Screen Saver’  setting is located in the admin console under Devices > Google Meet hardware > Settings > Device settings

Más información

  • Note that Comeen and StratosMedia are paid services and there may be additional costs associated with registering your devices on their platform. 
  • In some cases, this feature can conflict with the power-saving feature on your Meet hardware devices. To ensure that your custom screen saver is visible, be sure to set displays as active during working hours in the organizational unit you’re targeting. 
  • Screen savers are not interactive—tapping your touch controller or using the remote will cause the screen saver to be dismissed, and the device will return to displaying the agenda on the homepage. 

Para empezar

  • Admins: Custom screen savers are opt-in and managed at the OU-level and apply to all devices in that organizational unit (OU). Visit the Help Center to learn more about how to display custom screen saver images.
Ritmo de implantación

Disponibilidad

  • Disponible para todos los clientes de Google Workspace

Recursos

Google Workspace Updates Weekly Recap – January 24, 2025

1 New update

A menos que se indique lo contrario, las funciones que se indican a continuación están disponibles para todos los clientes de Google Workspace y se han lanzado completamente o están en proceso de despliegue. Las implantaciones no deberían tardar más de 15 días laborables en completarse si se lanzan a ambos tipos de clientes. Liberación rápida y programada al mismo tiempo. Si no es así, cada etapa de la implantación no debería tardar más de 15 días laborables en completarse.

Improving event summary cards in the Gmail mobile app 
Following last year’s announcement of purchase summary cards, we’re excited to introduce updates to the summary cards for Google Calendar events that make it easier for you to find relevant event information directly in Gmail. Now, when you receive an event related email, such as a restaurant reservation or dentist appointment, an updated card will show above the email content. This card summarizes the most up to date event information from the email and lets you quickly complete event actions, such as adding the event to your Calendar, getting directions to the location, or calling the venue. | Rollout to Ámbitos de liberación rápida y liberación programada 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 using summary cards in Gmail.
event summary cards in the Gmail mobile app

Anuncios anteriores

There are no previous announcements to share this week. For a recap of announcements in the past six months, check out What’s new in Google Workspace (recent releases).

Lanzamientos finalizados

Las siguientes funciones han completado su despliegue en Dominios de liberación rápida, dominios de liberación programadao ambos. Para más información, consulte las entradas originales del blog.

    Dominios de liberación programada: 
    Dominios de liberación rápida y programada: 

    Google Workspace Updates Weekly Recap – January 17, 2025

    Nuevas actualizaciones 

    Esta semana no hay novedades que compartir. A continuación encontrará un resumen de los anuncios publicados. 

    Anuncios anteriores

    Los anuncios que figuran a continuación se publicaron en el blog Actualizaciones del espacio de trabajo a principios de esta semana. Consulte las entradas originales del blog para obtener más información.


    Generate vocabulary lists using Gemini in Google 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. | Learn more about Gemini vocab lists in Classoom. 
    Introducing the ability to ‘grade all’ in Google Classroom
    To further improve upon grading options for teachers and give them the ability to perform bulk grading, we’re introducing ‘grade all’. With this new feature, teachers can quickly and efficiently grade all students’ work on the Gradebook page by selecting ‘grade all’. | Learn more about grade all in Classroom. 
    New Chrome Browser Profile Reporting for Workspace users available in the Admin console
    For Google Workspace customers with Chrome Enterprise Core, we’re pleased to introduce a new Chrome browser profile list and reporting features for signed-in Google Workspace users. | Learn more about Chrome Browser Profile Reporting. 
    The best of Google AI, now included in Workspace Business and Enterprise plans
    This week, we announced that we’re including the best of Google AI in Workspace Business and Enterprise plans without the need to purchase an add-on. | Learn more about Google AI in Workspace. 
    Configure Google Meet hardware devices to trust private certificates 
    You can now use private CAs to securely connect your Google Meet hardware with a third-party room control system’s UCI. | Learn more about configuring Google Meet hardware devices. 
    See phonics-based performance insights for decodable books in Google Classroom 
    To improve upon the current analytics dashboard experience and provide teachers with phonics-based performance insights for decodable books, we’re adding a new analysis section. | Learn more about phonics-based performance insights in Classroom.
    Use tokens as placeholders for user specific information when configuring managed iOS applications
    Admins can now use tokens in the app configurations for managed iOS apps. Tokens act as placeholders for information specific to a user or device that uses the app, such as a user’s email address or their device serial number. | Learn more about tokens when configuring managed iOS applications.

    Lanzamientos finalizados

    Las siguientes funciones han completado su despliegue en Dominios de liberación rápida, dominios de liberación programadao ambos. Para más información, consulte las entradas originales del blog.

    Dominios de liberación rápida: 
    Dominios de liberación programada: 
    Dominios de liberación rápida y programada: 


    Para recapitular los anuncios de los últimos seis meses, consulte Novedades de Google Workspace (versiones recientes)).

    Configure Google Meet hardware devices to trust private certificate authorities

    Qué está cambiando

    Google Meet hardware devices can now trust HTTPS certificates signed by a private certificate authority (CA). This simplifies the process of setting up and managing third-party user control interfaces (UCIs), especially in high impact meeting spaces with systems like Q-SYS.

    Previously, you had to get certificates signed by a public CA to enable Google Meet hardware touch controllers to load third-party UCIs. This process was often time-consuming and expensive, and required frequent renewals.

    Now, Google Meet hardware devices can trust certificates signed by a private certificate authority, enabling them to securely load a third-party room control system’s UCI. This gives you more control over your network security and eliminates the costs and complexities associated with public certificate signing.

    Para empezar

    Admin console >Menu > Devices > Networks > Certificates
    • Usuarios finales: There is no end user impact or action required.

    Ritmo de implantación

    Disponibilidad

    • Disponible para todos los clientes de Google Workspace con dispositivos de hardware Google Meet
    • Please note that Android devices aren’t supported yet.

    Recursos

    Use tokens as placeholders for user specific information when configuring managed iOS applications

    Qué está cambiando

    In May 2024, we launched the ability for admins to remotely configure managed iOS apps on end-user devices via Google Mobile Device Management. 

    Beginning today, admins can use tokens in the app configurations for managed iOS apps. Tokens act as placeholders for information specific to a user or device that uses the app, such as a user’s email address or their device serial number. Previously, configuration data was static, but this update gives admins the flexibility to configure devices dynamically according to various users and devices.

    Creating the app configuration using XML information using a token placeholder

    Para empezar

    Ritmo de implantación

    Disponibilidad

    Disponible para Google Workspace:
    • Empresas Más
    • Empresa Standard and Plus
    • Enterprise Essentials and Essentials Plus
    • Education Standard and Plus
    • Nonprofits
    • Frontline Starter and Standard
    • Cloud Identity Premium 

    Recursos