Google Workspace Changes

Added drill down functionality to Connected Sheets pivot tables for granular data access.

Users can now drill down into Connected Sheets pivot tables to immediately access granular data. By double-clicking a pivot table cell or using the "Show details" menu option, users can instantly create a pre-configured extract focused on the specific records contributing to the summary metric.

Doubled row capacity for Connected Sheets pivot tables backed by BigQuery.

The row capacity for pivot tables backed by BigQuery in Connected Sheets has been doubled from 100,000 to 200,000 rows. This enhancement allows users to analyze substantially larger BigQuery datasets within a single pivot table in Google Sheets.

The AI function in Google Sheets is now enhanced with Google Search results for more up-to-date answers.

The AI function in Google Sheets has been enhanced to automatically ground its responses in Google Search results. This allows the AI function to access up-to-the-minute information from the web to answer user prompts. For example, users can now use the AI function to find daily box office schedules, track market sentiment for new products, or get the latest weather information directly within their spreadsheets.