Tag Archives: Google Sheets

Google Workspace Updates Weekly Recap – May 26, 2023

6 New updates

Unless otherwise indicated, the features below are fully launched or in the process of rolling out (rollouts should take no more than 15 business days to complete), launching to both Rapid and Scheduled Release at the same time (if not, each stage of rollout should take no more than 15 business days to complete), and available to all Google Workspace customers.


Improving the Google Meet experience on foldable devices
If you’re using Google Meet on a foldable device, you’ll notice an improved experience in tabletop mode. Meet will automatically adjust the grid layout and control bar to best suit your device, making it easier to participate and interact during meetings. | Learn more about joining a video meeting.


Additional refinements to email notifications sent from Google Classroom
We’re updating the email notification experience in Google Classroom to make it easier for students and teachers to find the right information more efficiently in order to take action in Classroom. Specifically, you’ll notice refreshed visual design and language, clearer focus on action items, and easier access to notification settings. | Learn more about managing notification.
Additional refinements to email notifications sent from Google Classroom

Introducing new keyboard shortcuts in Google Sheets
We’re adding new keyboard shortcuts to Google Sheets to help you increase your productivity and perform actions faster. Examples include: applying/removing bold formatting, moving to the next Sheet, and displaying the Find and Replace box. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for June 7, 2023. | Learn more about keyboard shortcuts for Google Sheets.

Find what you need faster with new Google Drive organizational options
You will now have more control over how files and folders are displayed in various views within Google Drive for Web. For example, we’re adding a new drop-down menu in both grid and list layouts that will enable you to select whether folders should always appear "on top" or if they should be "mixed with files". Additionally, while in the Search view, the new menu will provide display options specifically related to your search, which returns results sorted by relevancy and modification date. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for June 7, 2023. | Learn more about viewing & reordering your files and folders.




Pin multiple participants from Google Meet Hardware devices
You can now pin multiple video tiles using Google Meet hardware. Pinning can be used to highlight speakers, presentations, and other key attendees in the video feed. Now you can use this functionality however you’re joining a meeting: desktop, mobile, or a conference room. | Available to all Google Workspace customers with Google Meet Hardware. | Learn more about pinning Google Meet participants.

Improving the Google Meet experience on foldable devices
If you’re using Google Meet on a foldable device, you’ll notice an improved experience in tabletop mode. Meet will automatically adjust the grid layout and control bar to best suit your device, making it easier to participate and interact during meetings.

Previous announcements

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


Simplify workflows in Google Docs with variable chips
We introduced variable chips, a new feature that makes document creation for things like invoices, contracts, or broader communications much easier. | Available to Google Workspace Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Plus customers and Nonprofits only. | Learn more about variable chips in Google Docs.


Extending client-side encryption to chat messages in Google Meet
If you’re using client-side encryption for Meet, in-meeting chat will now be supported. As with the audio and video content of your client-side encrypted meetings, all in-meeting chat messages will be encrypted and inaccessible by any third party, including Google. | Available to Google Workspace Enterprise Plus, Education Standard, and Education Plus customers hosting client-side encrypted calls only. | Learn more about client-side encryption for in-meeting chat on Google Meet.


Adding new capabilities to timeline view in Google Sheets
We added the following capabilities to expand the timeline view feature: enhanced formatting options, including card text truncation and the undo/redo option, a card collapsed view that enables you to merge cards into a single row for each card group, and print and download support. | Available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Essentials Plus, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Education Standard, and the Teaching and Learning Upgrade customers only. | Learn more about timeline view in Google Sheets. 


Set expirations for files in shared drives using Google Drive API
Developers will now be able to fully control file expirations via the Google Drive API (creating, reading, updating, deleting), and users will be able to see, but not edit file expirations in the sharing dialog. | Available to Google Business Standard, Business Plus, Enterprise Essentials, Enterprise Essentials Plus, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Standard, the Teaching and Learning Upgrade and Education Plus customers only. | Learn more about setting expirations for files in shared drives using Google Drive API. 


Enable your users to report inappropriate messages for review
Admins can enable content reporting for their Google Chat users. Once a user has flagged a message, admins can find more information about the incident in the Security Investigation Tool and decide whether further action is needed. This feature is available for Google Chat on the web and mobile devices. | Available to Google Workspace Enterprise Plus, Education Standard, and Education Plus customers only. | Learn more about reporting inappropriate messages. 

Contacts delegates can now update labels and manage “Other” contacts
We’re updating the functionality for delegated users to manage contact labels on behalf of their delegator via contacts.google.com. While this functionality was previously available in Gmail, they can now be managed directly at the source: Contacts. This will happen in two phases: 

Beginning this month, delegators will be prompted to review and re-approve access for their existing delegates. If existing delegates are not re-approved before July 2023, they will lose access to manage contacts. | Learn more about these additional capabilities for Contacts delegates and additional action required.

Improving consistency of Gmail data across the Security Investigation Tool and BigQuery
In August 2022, we announced the movement of the existing Gmail logs in BigQuery to Google Workspace logs and reports in BigQuery, creating a single space to access all of your Google Workspace audit events. 

To further improve this experience, you’ll see all Gmail log events from the Security Investigation Tool (SIT) in your Google Workspace logs and reports in BigQuery. This includes device types and post-delivery actions (for example open, delete, clicked links, and attachment downloads). | Learn more about the newly added columns.

Completed rollouts

The features below completed their rollouts to Rapid Release domains, Scheduled Release domains, or both. Please refer to the original blog post for additional details.


Rapid Release Domains:
Scheduled Release Domains:

Adding new capabilities to timeline view in Google Sheets

What’s changing

Last year, we introduced an interactive timeline view that allows you to track projects in Google Sheets. The timeline view enables you to easily interact with project information and can help you manage things like marketing campaigns, project milestones, schedules, cross-team collaboration, and more. 

Today, we’re adding the following capabilities to expand the timeline view feature: 
  • Enhanced formatting options, including card text truncation and the undo/redo option 
  • A card collapsed view that enables you to merge cards into a single row for each card group 
  • Print and download support 

Getting started 

  • Admins: There is no admin control for this feature. 
  • End users: To create a timeline, navigate to Insert > timeline > select a data range > configure the attributes in the timeline settings sidebar. Visit the Help Center to learn more about Timeline View. 

Rollout pace 

Availability 

  • Available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Essentials Plus, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Education Standard, and the Teaching and Learning Upgrade customers 
  • Not available to Nonprofits, Frontline Starter, and Frontline Standard customers 
  • Not available to users with personal Google Accounts 

Resources 

Complete data-driven tasks faster with new smart chip data extraction in Google Sheets

What’s changing

In continuing our efforts to help you deliver more with smart canvas, we recently introduced additional smart chip functionality in Google Sheets. Building upon this, you’ll also be able to quickly extract information from smart chips for advanced sorting, filtering and analysis to drive your projects forward. 

With smart chip data extraction, you can enrich your Sheets with information from people, file, and events chips. More specifically, this feature allows you to pull out metadata associated with specific smart chips into its own cell, while maintaining a connection with the chip it was extracted from. 


For example, if you need to keep track of a set of documents, their owners and details, such as creation time or who last modified the file, you can do so by extracting those fields from the relevant file chips as shown below. 
Sheets Data Extraction from Smart Chips

You can keep your extractions up to date by navigating to the “Refresh & manage” section of the extraction sidebar to update your data and reflect the latest changes. 

Who’s impacted 

End users 

Why you’d use it 

Smart chip data extraction allows you to track and organize data more easily, and also perform deeper analyses using data that is derived from smart chips. Useful actions include using file chips to understand when a document was last updated or using people chips to sort and filter employees based on job location to best delegate region specific tasks. 

Additional details 

You can also nest arrays of chip extractions to perform more complex analyses. The example below uses a range of people chips in B3:B11 to count the number of unique office locations for nine different individuals. Example formula extraction across range of people chips 
Example formula extraction across range of people chips

Getting started 

  • Admins: There is no admin control for this feature. 
  • End users: 
    • To perform sidebar extraction: 
      • Open the data extractions sidebar (via either the Data menu, right clicking on a cell/range with people, event or file chips and navigating to "Data extractions," or clicking on the "Data extractions" link in people, event or file hover cards) 
      • Select the range that contains the chips you want to extract data from 
      • Choose what data you want to extract from the selected chips 
      • Pick the range where you want the data to be extracted to 
    • To perform formula extraction: 
      • Start by typing = in a cell where you want the information extracted 
      • Navigate to the cell or range with chips in them and select it 
      • Add a period after the cell or range of cells and choose from the autocomplete what to extract 
      • Accept the dialog confirming what will be extracted 
    • To refresh data in the data extraction sidebar: 
      • Open the extraction sidebar 
      • Click Refresh & manage 
      • Find the smart chips data you want to refresh 
      • Click Refresh data 
      • To refresh all smart chips data, click Refresh all at the bottom of the sidebar. 
    • Visit the Help Center to learn more about extracting data from smart chips in your Google Sheets. 

Rollout pace 

  • Rapid Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on May 17, 2023 
  • Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on June 14, 2023 

Availability 

Extraction of data already stored in chips (Name and Email for people chips. MIME Type, URL, File Name for file chips. URL and Summary for event chips.) 
  • Available to all Google Workspace customers and users with personal Google Accounts 
Extraction of all available data (See Help Center for all available fields): 
  • Available to Google Workspace Business Standard, Business Plus, Enterprise Essentials, Enterprise Essentials Plus, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Education Standard, and the Teaching and Learning Upgrade
  • Not available to Essentials Starter, Business Starter, Frontline Starter, Frontline Standard, and Nonprofits
  • Not available to users with personal Google Accounts

Resources 

Google Workspace Updates Weekly Recap – April 28, 2023

4 New updates

Unless otherwise indicated, the features below are fully launched or in the process of rolling out (rollouts should take no more than 15 business days to complete), launching to both Rapid and Scheduled Release at the same time (if not, each stage of rollout should take no more than 15 business days to complete), and available to all Google Workspace and G Suite customers.


Updates to image insertion in Google Sheets on Android 
You can now drag and drop or copy/paste an image into Google Sheets on Android as an over-grid image rather than an in-cell image. You’re also now able to convert over-grid images into in-cell images via the context menu. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for May 8, 2023. | Learn more about adding an image to a spreadsheet.
Updates to image insertion in Google Sheets on Android
Replace images quicker in Google Slides with new drag and drop feature
Previously, to replace an image in Google Slides, you could either use the menu toolbar or right-click on the image you wanted to replace and select “Replace image.” Starting this week, you’ll have the additional option to easily drag and drop images from anywhere to replace images in your Slides presentations. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for May 9, 2023. | Learn more about inserting or deleting images and videos. 
Replace images quicker in Google Slides with new drag and drop feature
Attach a document, spreadsheet, or presentation to a Google Calendar event directly from Meet in Docs, Sheets, and Slides
You can already share a file in a Google Meet chat when using Meet in Docs, Sheets, and Slides. With this launch, you can easily attach that file to the associated Google Calendar event, allowing meeting attendees to access the file more easily. | Available to Google Workspace Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Standard, Education Plus, the Teaching and Learning Upgrade, and Nonprofits customers only. | Learn more about using Google Meet with Google Docs, Sheets, Slides, & Jamboard. 


Add emoji reactions to existing comments in Google Docs
Last year, we introduced an emoji reaction feature that provides a less formal alternative to comments in Google Docs. We’re building upon this by giving you the ability to add emoji reactions to existing comments in Docs. This new feature increases collaboration by enabling you to quickly and creatively express your opinions about document content. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for May 3, 2023. | Learn more about using comments, action items, & emoji reactions. 
Add emoji reactions to existing comments in Google Docs



Previous announcements

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


Enhancing tool discovery in Google Docs, Sheets, and Slides
We’ve rolled out an enhanced tool finder at the top of Google Docs, Sheets, and Slides to make it easier for users to discover commonly used tools and features. These refined tool-finding capabilities aim to help you quickly locate relevant features or functionality using your own words. | Learn more about enhanced tool discovery in Google Docs, Sheets, and Slides. 


Full HD in Google Meet video calls
For select Google Workspace editions, you can set your Google Meet video resolution to 1080p. This resolution is available on the web when using a computer with a 1080p camera and enough computing power in meetings with two participants. | Available to Google Workspace Business Standard, Business Plus, Enterprise Starter, Enterprise Standard, Enterprise Plus, the Teaching and Learning Upgrade, Education Plus, Enterprise Essentials and Frontline customers only. Also available to Google One subscribers with 2TB or more storage space with eligible devices. | Learn more about full HD in Google Meet video calls. 


Introducing additional smart chip functionality in Google Sheets
We’re expanding YouTube chips to Sheets to help you more easily manage YouTube content. You can also now insert multiple smart chips and text into a single cell using the @ menu. | Learn more about additional smart chip functionality in Google Sheets.


New Alert Center notifications for Apple push certificates
The Apple Push Notification Service (APNS) certificate is a critical component for advanced mobile management for iOS devices. This certificate expires yearly and requires manual renewal. | Available to Google Workspace Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Standard, Education Plus, The Teaching and Learning Upgrade, Education Fundamentals, Frontline, and Cloud Identity Premium customers only. | Learn more about new Alert Center notifications for Apple push certificates.


Set a custom time period for messages to automatically be deleted in Google Chat
For select Google Workspace editions, admins can now define a duration after which their users' messages in Google Chat will be deleted automatically. | Available to Google Workspace Business Plus, Enterprise Standard, Enterprise Plus, Education Standard, and Education Plus customers only. | Learn more about setting a custom time period for messages to automatically be deleted in Google Chat. 


Set Full HD in Google Meet live streams
For select Google Workspace editions, we’re adding 1080p as a resolution option for live streaming video, an increase from 720p. | Available to Google Workspace Enterprise Essentials, Enterprise Plus, Enterprise Standard, Education Plus, and Teaching and Learning Upgrade customers only. | Learn more about full HD in Google Meet live streams.


Completed rollouts

The features below completed their rollouts to Rapid Release domains, Scheduled Release domains, or both. Please refer to the original blog post for additional details.


Introducing additional smart chip functionality in Google Sheets

What’s changing

Earlier this year, we added place chips, finance chips, and expanded date capabilities to Google Sheets as the latest innovations in smart canvas. Today, we’re adding even more features that help you access and include rich, context-setting information directly in Sheets. 

Previously in Docs, we’re expanding YouTube chips to Sheets to help you more easily manage YouTube content. This feature allows you to add YouTube data, such as the title, description, and video preview, directly into your spreadsheet cell. Simply copy and paste a YouTube link into the cell, hover over it, and click the “Chip” option included in the “Replace URL” hovercard. 
YouTube Chips in Sheets
You can also now insert multiple smart chips and text into a single cell using the @ menu. This enhances your ability to quickly preview and interact with even more context-setting information in Sheets.
insert multiple smart chips and text into a single cell

Getting started 

Rollout pace 

Availability 

  • Available to all Google Workspace customers, as well as legacy G Suite Basic and Business customers 
  • Available to users with personal Google Accounts 

Resources 

Enhancing tool discovery in Google Docs, Sheets, and Slides

What’s changing

Starting today, we’re rolling out an enhanced tool finder at the top of Google Docs, Sheets, and Slides to make it easier for users to discover commonly used tools and features. These refined tool-finding capabilities aim to help you quickly locate relevant features or functionality using your own words. For example, if you search “who last viewed this document,” the Activity dashboard will surface. 

If you open the enhanced tool finder immediately after you create a file, you’ll notice suggestions for common actions users take when preparing a new document, spreadsheet, or presentation, such as:
  • Page setup, Dropdown, Meeting notes in Docs
  • Insert rows/columns, merge cells, and freeze rows/columns in Sheets
  • Page setup, Spell check, Edit theme in Slides
Once you begin editing, you can find recent actions by clicking into the tool finder for easy access to your previously used features. 

Prior to this launch, you could find features by navigating to Help>Search the menus. Starting today, that will redirect you to the enhanced tool finder. After a short transition period, the redirect will be removed and the tool finder will live permanently in the toolbar.
enhanced tool discovery

Who’s impacted 

End users 


Why you’d use it 

Whether you’re exploring collaboration, smart canvas, or formatting features, the enhanced tool finder will save you time and streamline your flow of work by helping you find the exact features you’re looking for much quicker.


Additional details 

You’ll also always be able to get to the find & replace tool at the bottom of search results, which will open with your query pre-populated.


Getting started 

Rollout pace 

Availability 

  • Available to all Google Workspace customers, as well as legacy G Suite Basic and Business customers 
  • Available to users with personal Google Accounts

Resources

Google Workspace Updates Weekly Recap – April 21, 2023

2 New updates

Unless otherwise indicated, the features below are fully launched or in the process of rolling out (rollouts should take no more than 15 business days to complete), launching to both Rapid and Scheduled Release at the same time (if not, each stage of rollout should take no more than 15 business days to complete), and available to all Google Workspace and G Suite customers.


Improving multi-instance support for the Google Drive Android app
Last year, we announced multi-instance support on Google Drive, a feature that gives you better insight into your files by allowing you to have two Drive app windows open side-by-side on large screen Android devices. Now, we’re improving this experience by adding multi-account support, which lets a single user have two instances of the Drive app open side-by-side on a single device, showing content from two different Google Accounts. With this update, you can preview a file from one account in one instance, while navigating through the folders of your secondary account in the other instance. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for April 28th, 2023. | Learn more about using Google Drive.
Improving multi-instance support for the Google Drive Android app

Autofill using a mouse on the Google Sheets Android app
Following the recent announcement of full mouse support for the Google Sheets app on Android, we’re introducing mouse autofill capabilities. With this update, you can autofill by dragging or double clicking a selection handle using a mouse in Google Sheets. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for April 25th, 2023.
Autofill using a mouse on the Google Sheets Android app



Previous announcements

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


Assign admin roles to specific groups
Scale and secure your role-based access controls (RBAC) practice on Workspace by leveraging a new capability for role assignments to groups. You can now assign admin roles to groups in addition to or instead of individual users. | Learn more about assigning admin roles to specific groups. 


Expanding admin privileges for Google Meet hardware devices
We’re increasing the number of admin privileges for Google Meet hardware devices from three to twelve. This gives admins more ways to delegate admin roles and access as it pertains to device data and management within the Admin console. | Learn more about expanding admin privileges for Google Meet hardware devices. 


Turn off the video feed for select tiles in Meet
You can now turn off the video feed from other participants during a Google Meet call. This can be helpful in situations where you want to focus your meeting view to just the presenter or hide participants with distracting video feeds. | Learn more about turning off the video feed for select tiles in Meet. 


Better location context for events and RSVPs in Gmail
Earlier this year, we made it even easier to use RSVPs in Google Calendar to let others know how you’re planning to join a meeting. Now, you can do the same thing directly from an invite in Gmail. | Available to Google Workspace Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Education Standard, Teaching & Learning Upgrade, and Nonprofits, as well as legacy G Suite Business customers only. | Learn more about better location context for events and RSVPs in Gmail. 


Co-present Google Slides in Google Meet
We’re adding a new feature that allows multiple people to present together in Meet. As the primary presenter, you can assign participants to co-present Slides with you. | Available to Google Workspace Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Plus, the Teaching and Learning Upgrade, and Nonprofits customers  only. | Learn more about co-presenting Google Slides in Google Meet. 


Completed rollouts

The features below completed their rollouts to Rapid Release domains, Scheduled Release domains, or both. Please refer to the original blog post for additional details.


Google Workspace Updates Weekly Recap – April 21, 2023

2 New updates

Unless otherwise indicated, the features below are fully launched or in the process of rolling out (rollouts should take no more than 15 business days to complete), launching to both Rapid and Scheduled Release at the same time (if not, each stage of rollout should take no more than 15 business days to complete), and available to all Google Workspace and G Suite customers.


Improving multi-instance support for the Google Drive Android app
Last year, we announced multi-instance support on Google Drive, a feature that gives you better insight into your files by allowing you to have two Drive app windows open side-by-side on large screen Android devices. Now, we’re improving this experience by adding multi-account support, which lets a single user have two instances of the Drive app open side-by-side on a single device, showing content from two different Google Accounts. With this update, you can preview a file from one account in one instance, while navigating through the folders of your secondary account in the other instance. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for April 28th, 2023. | Learn more about using Google Drive.
Improving multi-instance support for the Google Drive Android app

Autofill using a mouse on the Google Sheets Android app
Following the recent announcement of full mouse support for the Google Sheets app on Android, we’re introducing mouse autofill capabilities. With this update, you can autofill by dragging or double clicking a selection handle using a mouse in Google Sheets. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for April 25th, 2023.
Autofill using a mouse on the Google Sheets Android app



Previous announcements

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


Assign admin roles to specific groups
Scale and secure your role-based access controls (RBAC) practice on Workspace by leveraging a new capability for role assignments to groups. You can now assign admin roles to groups in addition to or instead of individual users. | Learn more about assigning admin roles to specific groups. 


Expanding admin privileges for Google Meet hardware devices
We’re increasing the number of admin privileges for Google Meet hardware devices from three to twelve. This gives admins more ways to delegate admin roles and access as it pertains to device data and management within the Admin console. | Learn more about expanding admin privileges for Google Meet hardware devices. 


Turn off the video feed for select tiles in Meet
You can now turn off the video feed from other participants during a Google Meet call. This can be helpful in situations where you want to focus your meeting view to just the presenter or hide participants with distracting video feeds. | Learn more about turning off the video feed for select tiles in Meet. 


Better location context for events and RSVPs in Gmail
Earlier this year, we made it even easier to use RSVPs in Google Calendar to let others know how you’re planning to join a meeting. Now, you can do the same thing directly from an invite in Gmail. | Available to Google Workspace Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Education Standard, Teaching & Learning Upgrade, and Nonprofits, as well as legacy G Suite Business customers only. | Learn more about better location context for events and RSVPs in Gmail. 


Co-present Google Slides in Google Meet
We’re adding a new feature that allows multiple people to present together in Meet. As the primary presenter, you can assign participants to co-present Slides with you. | Available to Google Workspace Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Plus, the Teaching and Learning Upgrade, and Nonprofits customers  only. | Learn more about co-presenting Google Slides in Google Meet. 


Completed rollouts

The features below completed their rollouts to Rapid Release domains, Scheduled Release domains, or both. Please refer to the original blog post for additional details.


Google Workspace Updates Weekly Recap – March 31, 2023

3 New updates

Unless otherwise indicated, the features below are fully launched or in the process of rolling out (rollouts should take no more than 15 business days to complete), launching to both Rapid and Scheduled Release at the same time (if not, each stage of rollout should take no more than 15 business days to complete), and available to all Google Workspace and G Suite customers.


Full mouse support now available for Google Sheets and Slides on Android 
Last year, we announced full mouse support while using Google Docs on Android devices that mirrors mouse behavior on the web. This week, we’ve expanded this to Sheets and Slides, enabling you to resize unselected rows and columns, click, drag, hover, and more with your mouse. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for April 12, 2023.
Move folders from My Drive to shared drives
Earlier this year, we introduced a beta that allows end users to move folders from My Drive into shared drives. We’re happy to announce this is now generally available to Google Workspace Essentials, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Education Standard, the Teaching and Learning Upgrade, and Nonprofits, and legacy G Suite Business customers. | Rollout to Rapid Release domains complete; launch to Scheduled Release domains planned for April 11, 2023. | Learn more. 




Multi-instance support now available for Google Keep on large screen Android devices 
Following the recent update to view Google Keep notes on the home screen of Android devices, we’re introducing the ability to open a second instance of the Keep app on the same device. Having two windows open side-by-side enables better insight into your notes and gives you more ways to work with, display, and organize your content across Google Workspace. 

Previous announcements

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


Connected Sheets for Looker now available for all Looker-hosted instances
We’re making Connected Sheets available for Looker instances hosted on non-Google Cloud providers like AWS and Azure. | Available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Education Standard, the Teaching and Learning Upgrade, Frontline, and Nonprofits only. | Learn more.


Launching in beta: manage working locations with the Calendar API
Available now in beta through our Developer Preview Program, you can read working location data using the Calendar API and get notified when those working locations change. |Available to Google Workspace Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Education Standard, the Teaching and Learning Upgrade and Nonprofits customers, as well as legacy G Suite Business customers only. | Learn more. 


Admins can install Chat apps for use in direct messages
Starting this week, admins can install Chat apps for direct messages on behalf of users within their domain from the Workspace Marketplace. | Available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Education Standard, the Teaching and Learning Upgrade, Frontline, and legacy G Suite Basic and Business customers only. | Learn more.


Find files quicker with search chips in Google Drive
Last month, we pre-announced numerous features that offer new experiences in smart canvas, including enhancing Google Drive to help you complete your most frequent tasks more quickly. This week, we introduced search chips in Drive that enable you to filter by criteria like file type, owner, and last modified date. | Learn more.


Completed rollouts

The features below completed their rollouts to Rapid Release domains, Scheduled Release domains, or both. Please refer to the original blog post for additional details.


Rapid Release Domains:

Scheduled Release Domains:

Rapid and Scheduled Release Domains:

Connected Sheets for Looker now available for all Looker-hosted instances

What’s changing

In 2020, we introduced Connected Sheets on Google Sheets, to help you analyze, visualize, and share billions of rows of data from your spreadsheets. Since then, we’ve made numerous improvements to the feature, including the recent announcement that you can now explore Google Cloud hosted Looker instances using Connected Sheets.


Today, we’re expanding upon this by making Connected Sheets available for Looker instances hosted on non-Google Cloud providers like AWS and Azure. 
Connected Sheets for Looker now available for all Looker-hosted instances

Getting started 

  • Admins: 
  • End users: 
    • If enabled by your admin, follow these steps to explore Looker data using Connected Sheets: 
      • In a Google Sheet navigate to “Data” > “Data connectors” > “Connect to Looker” > enter in the URL of a Looker instance, for example: https://example.looker.com. You will then need to authorize Sheets to access your Looker data. After you connect to an Explore, you can see the available data and continue your analysis in Google Sheets. 
      • Visit the Help Center to learn more about Connected Sheets for Looker. 

Rollout pace 

  • This feature is available now for all users. 

Availability 

  • Available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Education Standard, the Teaching and Learning Upgrade, Frontline, and Nonprofits 
  • Not available legacy G Suite Basic and Business customers 
  • Available to users with personal Google Accounts 

Resources