Gemini in Google Sheets can now analyze data across multiple tables

 What’s changing

Starting today, Gemini in Sheets can understand and analyze multiple tables within a single tab of a spreadsheet.  This new functionality allows you to ask questions and perform analysis that spans multiple data sources, dramatically increasing the power and accuracy of your queries. You can select or deselect tables to focus Gemini’s attention, and you can also directly make a selection within a table to be used as input for your query.

You can use this update while:

  1. Generating formulas: Generate complex formulas that reference and perform calculations across several tables in one go. For example, you can now have Gemini write XLOOKUP functions to look up values from one table to use in another, or aggregate data from multiple tables into a single summary calculation. 
  2. Analyzing and generating charts: Ask Gemini to analyze data scattered across multiple tables to uncover insights and create data visualizations. You can get a holistic view of your data, whether you’re identifying top performers by combining sales data from different tables, or creating a single chart that compares sales performance data from separate tables.
  3. Editing your data: Apply changes to multiple tables at once with a single request. For example, you can now use Gemini to apply consistent conditional formatting across all your tables in a spreadsheet or build a single pivot table that summarizes data from multiple tables. 
  4. Targeting analysis with selections: You can now make selections within your tables to focus Gemini’s analysis. Ask for summaries of specific data, find outliers in a selected range, or generate formulas based on the data you’ve highlighted. For example, you can select a column and ask, "What are the trends in the selected column?"
Gemini in Google Sheets

Prompt: “Generate a formula that fills the column next to due date that looks up the assigned teammate based on task id” 

Generate one chart of trends over time which contain the data from all three teams

Prompt: “Generate a formula that fills the column next to due date that looks up the assigned teammate based on task id” 

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


Dynamic App Links: Elevating your Android deep linking

Posted by Ran Mor - Product Manager
   
We're excited to announce the availability of Dynamic App Links, a significant leap forward for Android App Links that brings them on par with, and in many ways surpasses, industry standards for deep linking. For too long, Android App Links have been limited in their functionality, but with this launch, we're introducing powerful new features that provide unparalleled control and flexibility for developers.

Since Android 6, App Links has been crucial for delivering a seamless web-to-app user experience. By directing users directly to relevant content within your app, rather than a web browser or mobile-web page, you enhance engagement, boost conversions, and foster greater customer loyalty. Now Dynamic App Links, available on Android 15 and later,  makes achieving this even easier and more effective.

What's New: Functionalities Enabled by Dynamic App Links

The core of these enhancements lies in the Digital Asset Links JSON file. Previously, this file was primarily used for basic verification. Now, it's a powerful configuration tool that allows you to specify paths, query parameters, fragments, and exclusions, providing a dynamic and robust deep linking solution.

Here what’s new in Dynamic App Links:

Exclusions support

You can now specify certain paths or sections of a URL that should not open your app, even if they would otherwise match your App Link configuration. This is incredibly useful for:

  • Unsupported Content: Directing users to web content that isn't yet supported within your app.

  • Legacy Content: Managing old URLs that you no longer want to route to your app.

  • Specific Campaigns: Temporarily excluding certain links during promotions or tests.

This granular control ensures users always land in the most appropriate experience.

Query parameters support

With the new Query parameters functionality you can define specific parameters that, if present in a URL, will prevent your app from opening. This opens up exciting possibilities for:

  • Dynamic Exclusions: Quickly turning off app linking for specific scenarios without requiring an app update.

  • A/B Testing: Directing users to different experiences (app vs. web) based on test parameters.

  • Controlled Rollouts: Gradually enabling app linking for certain user segments.

Dynamic updates

Make easier updates to your App Links configuration without needing to update your app. You can now specify the URL paths that your app will handle directly within the Digital Asset Links JSON file that is hosted on your server. 

This means you can:

  • Respond quickly to changes: Adapt your deep linking strategy in real-time without the overhead of a new app release.

  • Reduce development cycles: Implement and test App Link changes much more efficiently.

  • Maintain agility: Keep your app's deep linking configuration current with your evolving content and features.

Why Dynamic App Links?

Android Dynamic App Links are the preferred way to link to content within your app because they offer:

  • Seamless User Experience: Direct users instantly to the exact content they're looking for, bypassing browser redirects.

  • Improved Engagement: Keep users within your app, leading to higher engagement and longer session times.

  • Increased Conversions: Guide users effortlessly through your app's flows, improving the likelihood of desired actions.

  • Enhanced Customer Loyalty: Deliver a polished and efficient experience that keeps users coming back.

With Dynamic App Links, you now have the tools to build even more powerful and flexible deep linking experiences, ensuring your users always find the content they need, right where they expect it.

We're excited to see what you'll build with Dynamic App Links. Visit our documentation to start exploring these new features today and elevate your app's deep linking strategy!

Simplify Your Code: Functional Core, Imperative Shell

This article was adapted from a Google Tech on the Toilet (TotT) episode. You can download a printer-friendly version of this TotT episode and post it in your office.

By Arham Jain

Is your code a tangled mess of business logic and side effects? Mixing database calls, network requests, and other external interactions directly with your core logic can lead to code that’s difficult to test, reuse, and understand. Instead, consider writing a functional core that’s called from an imperativ​​e shell.

Diagram of functional core, imperative shell

Separating your code into functional cores and imperative shells makes it more testable, maintainable, and adaptable. The core logic can be tested in isolation, and the imperati​​ve shell can be swapped out or modified as needed. Here’s some messy example code that mixes logic and side effects to send expiration notification emails to users:

// Bad: Logic and side effects are mixed

function sendUserExpiryEmail(): void {

  for (const user of db.getUsers()) {

    if (user.subscriptionEndDate > Date.now()) continue;

    if (user.isFreeTrial) continue;

    email.send(user.email, "Your account has expired " + user.name + “.”);

  }

}

A functional core should contain pure, testable business logic, which is free of side effects (such as I/O or external state mutation). It operates only on the data it is given.

An imperative shell is responsible for side effects, like database calls and sending emails. It uses the functions in your functional core to perform the business logic.

Rewriting the above code to follow the functional core / imperative shell pattern might look like:

Functional core

function getExpiredUsers(users: User[], cutoff: Date): User[] {

  return users.filter(user => user.subscriptionEndDate <= cutoff && !user.isFreeTrial);

}

function generateExpiryEmails(users: User[]): Array<[string, string]> {

  return users.map(user => 

    ([user.email, “Your account has expired “ + user.name + “.”])

  );

}

Imperative shell

email.bulkSend(generateExpiryEmails(getExpiredUsers(db.getUsers(), Date.now())));

Now that the code is following this pattern, adding a feature to send a new type of email is as simple as writing a new pure function and reusing getExpiredUsers:

// Sending a reminder email to users

function generateReminderEmails(users: User[], cutoff: Date): Array<[string, string]> {...}

const fiveDaysFromNow = ...

email.bulkSend(generateReminderEmails(getExpiredUsers(db.getUsers(), fiveDaysFromNow)));


Learn more in Gary Bernhardt’s original talk about functional core, imperative shell.

Chrome Dev for Desktop Update

The Dev channel has been updated to 143.0.7475.8 for Windows, Mac and Linux.

A partial list of changes is available in the Git log. Interested in switching release channels? Find out how. If you find a new issue, please let us know by filing a bug. The community help forum is also a great place to reach out for help or learn about common issues.

Chrome Release Team
Google Chrome

Chrome Dev for Desktop Update

The Dev channel has been updated to 143.0.7475.8 for Windows, Mac and Linux.

A partial list of changes is available in the Git log. Interested in switching release channels? Find out how. If you find a new issue, please let us know by filing a bug. The community help forum is also a great place to reach out for help or learn about common issues.

Chrome Release Team
Google Chrome

Google Workspace Updates Weekly Recap – October 17, 2025

 

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

AI-powered makeup in Google Meet
Now you can choose from 12 new studio makeup looks, with a range of options from a polished, professional touch to a more expressive flair. Your AI-powered makeup remains seamless and untouched—even through everyday movements like sipping your coffee or touching your face. | Learn more about using AI makeup in Meet. 


The AI function in Google Sheets is now enhanced with Google Search results for more up-to-date answers
Earlier this year, we announced AI function in Sheets to help you generate text, summarize information, categorize data, and analyze sentiment at scale, directly from any cell in your spreadsheet. Last month, we expanded feature availability to seven additional languages. Now, we're making AI function even more powerful by automatically grounding it in results from Google Search, so it can access up-to-the-minute information from the web to answer your prompts. | Learn more about Google Search in the Sheets AI function. 


Google Keep reminders now saved to Tasks
As announced last year, Keep reminders will be automatically saved to Tasks. This means that now users can view their Keep reminders as tasks in Calendar, in the Tasks app, and even ask the Gemini app about them (via the Tasks extension). As part of this launch, any existing date/time based Keep reminders will automatically be saved to Google Tasks. | Learn more about the reminders to Tasks migration. 


Use Help me schedule to easily set up a meeting time over email
Gmail with Gemini will detect when you’re trying to coordinate a time within an email and will surface a Help me schedule button in the toolbar. After you click on the Help me schedule button, Gemini will automatically suggest ideal slots based on your Google Calendar and the email's context. | Learn more about Help me schedule in Gmail. 


Summarize shared files with Gemini in Google Chat, now available on mobile
Simply tap the “Summarize” button on the file preview card in your conversation. Gemini will summarize the file so you can get a quick overview without having to leave Chat. | Learn more about summarizing files in Chat. 


Video Overviews in NotebookLM are now available to users of all ages
Google Workspace for Education users of all ages can now use Video Overviews in NotebookLM. Users can now turn documents, slides, charts and more into engaging explainer videos that are narrated by an AI voice. | Learn more about Video Overviews in Notebook LM. 


Extract, categorize, and summarize data in AppSheet with the power of Gemini
AppSheet Enterprise Plus users can now add the new AI Task powered by Gemini, directly into their existing AppSheet automations. The AI Task can perform the following functions: Extract, Extract Rows, Categorize, and Summarize. | Learn more about Gemini in AppSheet. 


Gemini in Google Sheets now tackles multi-step tasks with expanded editing capabilities
Earlier this year, we introduced powerful new editing options within Gemini in Sheets like creating pivot tables, applying filters, and adding conditional formatting. Building on that momentum, we’re excited to announce that Gemini can now execute multiple actions at once from a single prompt - no need to simplify your instructions or disrupt your workflow by typing multiple different prompts. | Learn more about multi-step actions using Gemini in Sheets. 


Your organization's logo will now appear in the Gemini app
Similar to other Google Workspace service pages, your organization’s logo will now appear next to a user’s profile picture in the Gemini app when they are using their business or education account. | Learn more about organizational logos in the Gemini app. 


Introducing Business Continuity editions: Support business continuity and resilience for enterprise customers
When your primary systems are compromised, you need a dependable partner to keep your organization operational. Our new Business Continuity editions are designed to serve as a robust backup solution that works in tandem with your primary, non-Google Workspace collaboration platform, providing a secure and familiar environment that can be activated when you need it most. | Learn more about the new Business Continuity editions. 


Flashcards in Gemini are now available to users of all ages 
Google Workspace for Education users of all ages can now use Flashcards in Gemini. Users can ask Gemini to instantly create flashcards and study guides based on your quiz results or other class materials, providing a simple and effective way to review key concepts and reinforce your learning. | Learn more about creating Flashcards with Gemini. 



Flashcards in Gemini are now available to users of all ages

What’s changing

Google Workspace for Education users of all ages can now use Flashcards in Gemini. Users can ask Gemini to instantly create flashcards and study guides based on your quiz results or other class materials, providing a simple and effective way to review key concepts and reinforce your learning.



Why you’d use it

Flashcards can be a helpful resource for students as they study and learn with Gemini. For example, students under 18 can now:

  • Get ready for your next test with powerful new study tools
  • Get personalized study guidance  - complete a quiz within Gemini and create flashcards based off of the results to hone in on subject areas that need more attention. 

The Gemini app is covered under the Google Workspace for Education Terms of Service for all Workspace for Education users and has enterprise-grade data protection, meaning your data is not human reviewed or otherwise used to train AI models.

Who’s impacted

  • Admins and end users

Getting started 

Rollout pace

Availability

Available for Google Workspace:
  • Education Fundamentals, Standard, and Plus
  • Customers with the Google AI Pro for Education add-on*
*On September 2, the Gemini Education and Gemini Education Premium add-ons were consolidated into a single add-on called Google AI Pro for Education. 

Resources