Starting today, Enhanced Smart Fill in Google Sheets is available for customers with the Duet AI for Google Workspace Enterprise add-on. This builds upon Smart Fill in Google Sheets, a feature we introduced in 2020 that detects patterns between columns and suggests data for remaining cells using Google’s Knowledge Graph. More recently, we launched Help me organize in Sheets, a Duet AI feature that gives you a running start for creating highly-organized plans and trackers. 

As previously announced, offering Enhanced Smart Fill will continue our efforts to help users spend less time on manual data organization and analysis in Sheets. This capability uses AI to detect if there are relationships between cell contents. If a relationship exists, Sheets can make contextual suggestions in the form of remaining values that you can accept. Once you click to accept the suggested values, Sheets will automatically fill them. 

Enhanced Smart Fill can recognize and fill patterns like: sentiment classification, combining and generating text, extracting specific text, formatting addresses, structuring phone numbers and emails, condensing text and more. For example, a restaurant could organize their reviews and rating data more easily with Enhanced Smart Fill. Rather than manually typing in data, ​​Sheets can detect a pattern in the existing ratings and reviews content and suggest values for the remaining cells. Simply review the suggestions and accept them in one click using Enhanced Smart Fill.

For years, users have had the ability to scan physical documents, such as a receipt or passport, using the Google Drive app on Android devices. And earlier this year, we added additional functionality to recommend relevant title suggestions for scanned documents by leveraging machine learning. 

Today, we’re introducing additional enhancements to the Drive scanner on Android devices, which now powers the Google Pixel camera and includes improvements to the scanner experience when capturing content. Specifically, you’ll notice: 

Automatic capture to help you get the best scan quickly Camera viewfinder that helps you position your document for the highest quality scan The option to import from your camera roll A faster way to initialize a scan with a new scanner button 

We’re also expanding the Google Drive scanner and title suggestion feature to iOS devices. Now, when using your iOS phone or tablet, you can easily scan and digitally organize physical documents, crop them if needed, and receive relevant title suggestions based on machine learning. 

Admins: There is no admin control for this feature. End users: Open the Drive app on your Android device > scan a document via the camera icon or scan a document via the Scan button under the “+” icon > assess/adjust the automatic cropping > scan multiple pages in a session (if needed) > apply filters > save to Drive. Open the Drive app on your iOS device > scan a document via the camera icon or scan a document via the Scan button under the “+” icon > > scan multiple pages in a session (if needed) > click on scan to apply filters or crop as needed > save to Drive. Note: Title suggestions are only available in the US. Visit the Help Center to learn more about scanning documents with Google Drive. 

iOS: 

Rapid Release and Scheduled Release domains: Full rollout (1–3 days for feature visibility) starting on November 28, 2023 Android: 

 This feature is now available 

Availability 

Available to all Google Workspace customers and users with personal Google Accounts 

Resources 

In September, we introduced message bubbles in Google Chat on web and Android, enabling users to more easily differentiate incoming versus outgoing messages in the Chat message stream. Today, we’re excited to announce the expansion of message bubbles to iOS devices. 

On your phone or tablet: 

Each incoming message will have an independent message bubble aligned to one side with a solid color background Each outgoing message will have an independent message bubble aligned to the other side with a different color background 

Admins and end users: No action required. You’ll automatically see these updates in your web and mobile experience over the next several weeks. 

Rapid Release and Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on November 28, 2023 

Availability 

Available to all Google Workspace customers and users with personal Google Accounts 

Resources 

We recently announced a streamlined user experience in Google Chat to help you find what you need much faster, including new features like home and mentions. Starting today, we’re excited to introduce a new bottom navigation bar within the Chat app on Android & iOS devices to help you easily access these features on mobile. You will now have easy access to the following views: 

Home: helps you stay on top of all conversions in one unified view, with a filter that allows you to drill down to unread messages. Direct messages: see a compact list of all your 1:1 and group messages, including pinned conversations at the top of the list. Spaces: see a compact list of all your spaces, including pinned conversations at the top of the list. Mentions: helps you easily find messages from conversations and spaces where you’ve been mentioned. 

Admins and end users: No action required. You’ll automatically see these updates on your mobile devices over the next few weeks. Visit the Help Center to learn how to use Google Chat and how to mention someone else in a message. 

Android & iOS: 

Rapid Release and Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on November 29, 2023 

Available to all Google Workspace customers and users with personal Google Accounts 

Google Vault now supports Calendar, which means customers can take the following actions around Calendar data: 

Manage retention with default and custom rules. Search and preview events with a number of filters, such as keyword search across description, title, guests, locations and invite response status which can be used to quickly refine your search. Search for historical versions of events, which allows Vault Admins to search and export events as they appeared on a specific date. Export data in multiple formats, including ICS, PST (MSFT format) and CSE-decryptable formats. Apply holds to prevent purging of data which must be retained for legal purposes.