Google Workspace Changes

Increased row limits for pivot tables in Connected Sheets for Looker

Google is expanding the maximum number of rows of results returned from Looker to 100,000 for pivot tables in Connected Sheets, allowing users to analyze larger datasets from Looker directly in Sheets.

Expanding row limits in Connected Sheets for Looker

Expanding this to Connected Sheets for Looker by increasing the maximum number of rows of results returned from Looker to 100,000 for pivot tables. With this update, users can analyze even more results in Sheets from the petabytes of data in Looker.

Expanding row limits in Connected Sheets for Looker

we’re expanding this to Connected Sheets for Looker by increasing the maximum number of rows of results returned from Looker to 100,000 for pivot tables.

Expanding row limits in Connected Sheets for Looker

We’re expanding this to Connected Sheets for Looker by increasing the maximum number of rows of results returned from Looker to 100,000 for pivot tables.

Table reference improvements in Google Sheets

This week, we introduced updates to table references that enhance discoverability and usability.

Google Sheets is enhancing table references with improved availability for table parts, formula suggestions, and formula corrections.

Google Sheets has introduced updates to table references to improve discoverability and usability. Users can now reference specific table components—including full columns (#ALL), headers (#HEADERS), footers (#TOTALS), and data (#DATA)—across both single and multiple columns. Additionally, the update includes formula suggestions to help users identify more robust formula options and formula corrections to automatically suggest proper table references when a formula is written incorrectly.

Discoverability and usability updates for table references in Google Sheets.

Table references, a way to refer to a table or parts of a table in a formula, are just one example of how tables reduce time spent manually formatting data. Today, we’re excited to announce updates to table references that enhance discoverability and usability.

Improved table reference availability with formula suggestions and corrections.

Users will now see: Improved table reference availability, which allows users to reference the items below across both single and multiple columns. Formula suggestions, which help you identify formulas that could be more robust. Formula corrections for table references, which show a formula correction with a proper table reference when a formula is written incorrectly.

Search for and reuse pre-defined queries from BigQuery in Connected Sheets

Users can now search for and reuse pre-defined queries directly from BigQuery Studio and notebooks to load data into Connected Sheets, removing the need to manually copy and paste queries.

Users can now search for and reuse pre-defined queries directly from BigQuery to load Connected Sheets data.

Users can now search for and reuse pre-defined queries directly from BigQuery to load Connected Sheets data.

Gemini in the side panel of Google Sheets now supports French, German, Italian, Japanese, Korean, Portuguese and Spanish.

Gemini in the side panel of Google Sheets now supports French, German, Italian, Japanese, Korean, Portuguese and Spanish.

Introducing a better filter by condition experience for tables in Google Sheets

Google Sheets tables now feature a smarter 'filter by condition' experience. The available filter options are now dynamically filtered based on the column's data type, ensuring users only see relevant options (e.g., number-based filters for number columns).