Tag Archives: Google Sheets

Google Workspace Updates Weekly Recap – August 11, 2023

4 New updates 

Unless otherwise indicated, the features below are available to all Google Workspace customers, and are fully launched or in the process of rolling out. Rollouts should take no more than 15 business days to complete if 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.


Adding bulk conversion for place chips in Google Sheets
Earlier this year, we introduced a smart canvas feature that enables you to open a location directly in Google Maps and see a preview of the location or find directions when a Google Maps place chip is added to your Sheet. Starting this week, users can now convert links to place chips in bulk from the insert menu or cell menu. This time-saving update is especially helpful when formatting data in bulk for event schedules, vendor lists, trip itineraries, etc. | Rolling out now to Rapid Release and Scheduled Release domains at an extended pace (potentially longer than 15 days for feature visibility). | Learn more about inserting smart chips in your Google Sheets. 
Adding bulk conversion for place chips in Google Sheets
Easily set up dropdown chips in Google Sheets with a new pre-fill feature 
If you select a range of cells then insert a dropdown chip, manually entered cell data will convert to pre-fill the dropdown values. You can then use the dropdown sidebar to easily adjust the options or add styles to the dropdowns before accepting. | Learn more about creating a dropdown list with existing data. 
Easily set up dropdown chips in Google Sheets with a new pre-fill feature
Reorganizing the file and folder menu in Google Drive
Earlier this year, we introduced a refreshed interface for Google Drive, Google Docs, Google Sheets, and Google Slides. Building upon this, when right-clicking a file or folder in Drive, you will now see a new menu format. While the menu functionality remains the same, we’ve reordered and renamed menu items, and also added new sub-menus. 
Reorganizing the right-click menu format in Google Drive

Updated timeline for upgrading to the in-line threaded experience in Google Chat 
Earlier this year, we announced that existing spaces organized by conversation topic will be upgraded to the new in-line threaded experience by Q4 2023. We’d like to provide an update on that timing: 
  • The upgrade will start in September 2023 and is expected to be completed by the end of Q1 2024. 
Ahead of the upgrade, Google Workspace admins, partners, and resellers will receive an email with more information about what to expect before any changes are made to their experience. For more information, please refer to our previous announcement. 


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 lesson planning with shareable class templates and classwork with new Google Classroom beta 
We’re excited to announce a Google Classroom beta that will simplify lesson planning with others and make classroom materials more accessible. | Available to Education Plus only. | Learn more about the new Google Classroom beta. 

Updates for exporting your organization’s data 
Google Workspace customers can choose to export the data of a specific user, rather than a customer’s full set of user generated content. Additionally, you’ll notice an improved user interface for the data export tool, which provides more detailed information about exports, records a longer history of exports, and offers more features (filtered takeout). | Available to Google Workspace Business Starter, Business Standard, Business Plus, Enterprise Starter, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Standard, Education Plus, and the Teaching and Learning Upgrade and Assured Controls customers only. | Learn more about exporting your organization’s data. 

Review suggested hints, add your own resources, and more for practice sets in Google Classroom We’ve announced an update that gives teachers more control over the resources for students in practice sets. | Available to Google Workspace for Education Plus and Google Workspace for Education Teaching and Learning Upgrade only. | Learn more about practice sets in Google Classroom. 

Expanding branding and customization capabilities in Google Slides and Google Forms 
Users now have access to a domain template with a variety of branded slides, layouts, images, colors and fonts that will appear when creating a new presentation in Slides. They also have access to a domain theme including fonts, branded colors and a header image that you can use when creating a new form or editing an existing form in Forms. | Available to Business Plus, Enterprise Standard, Enterprise Plus, Education Plus only. | Learn more about default templates & themes. 

Adding Gmail translation to mobile devices 
There is now a native translation integration within the Gmail mobile app that will enable you to seamlessly communicate in a wide range of languages. | Learn more about translating on mobile devices in Gmail. 

Google Keep integration with Assistant available to all Google Workspace users 
If you’re using the Google Assistant with your Google Workspace device, you can set Google Keep as the default provider for your notes and lists. You can ask Assistant to create a new list, add or delete items for an existing list, or read back all the list items to you. | Learn more about the Google Keep integration with Assistant. 

Introducing eSignature for Google Docs and Google Drive: launching to open beta for Workspace Individual subscribers, launching to beta for Google Workspace customers 
eSignature is now available as an open beta for Google Workspace Individual subscribers — no additional sign-up is required to use the feature. eSignature will be available in beta for select Google Workspace customers — see the “Additional details” section below for more information. | Eligible for beta: Google Workspace Business Standard, Business Plus, Enterprise Starter, Enterprise Standard, Enterprise Plus, Enterprise Essentials, Enterprise Essentials Plus, Education Plus, and Nonprofits customers only. | Learn more about eSignatures in Google Docs. 

Gallery view for Zoom interoperability on Google Meet hardware 
We’re now introducing support for Zoom’s Gallery view, which makes much better use of screen real estate and allows more participants to be seen on screen at the same time. | Available for all Google Meet hardware customers. | Learn more about Zoom interoperability for Google Meet hardware devices. 

Add annotations to your presentations in Google Slides 
There is a feature that lets you highlight or emphasize key content while you present in Google Slides. With the new pen tool, you can circle, underline, draw connections or make quick notes directly on your presentation. | Learn more about annotations in Google Slides

Set Context Aware Access policies for 1P & 3P applications to access Workspace APIs
Admins can now use context-aware access to block users' access to Workspace Applications via other Google (1st party) & non Google (3rd party) applications. | Available to Google Workspace Enterprise Standard, Enterprise Plus, Education Standard, Education Plus, and Cloud Identity Premium customers. | Learn more about Context Aware Access policies.


Completed rollouts

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


Rapid Release Domains: 

Scheduled Release Domains: 

Rapid and Scheduled Release Domains: 

Google Workspace Updates Weekly Recap – August 4, 2023

6 New updates 

Unless otherwise indicated, the features below are available to all Google Workspace customers, and are fully launched or in the process of rolling out. Rollouts should take no more than 15 business days to complete if 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.

Empty the entire trash folder of shared drives in Google Drive
In order to make it easier to manage shared drive files and eliminate the manual effort of removing items in the trash folder, we’ve added the ability to empty the entire trash folder of a shared drive. As a reminder, files and folders in Trash are deleted forever after 30 days. You can also delete files in Trash by selecting “Delete Forever”.

Linkable headings now available in Google Docs
To improve shareability of documents, especially longer ones, we’re adding the ability to copy links to headings in Google Docs. Simply, open a Google Doc on web > add a heading (type some content and set to “Heading 1”) > right-click the heading > click the “Copy heading link” button > paste the contents. 
Linkable headings now available in Google Docs
People chips in Google Sheets now available on mobile devices 
In 2021, we introduced people chips in Google Sheets. These chips allow you to quickly view more information about colleagues or contacts, including their location, job title, and contact information. We’re excited to announce that these smart chips are now available on iOS and Android devices. | Learn more about inserting smart chips in your Google Sheets. 
People chips in Google Sheets now available on mobile devices
Adding drag & drop to Google Drive multi-instance support on large screen Android devices
Earlier this year, we added the option for a single user to have two instances of the Google Drive app open side-by-side on a single device, which shows content from two different Google Accounts. Starting this week, you can now drag and drop between two instances of the Drive app, enabling you to quickly share files and folders between two different accounts. | Learn more about using Google Drive. 
Adding drag & drop to multi-instance support on the Google Drive Android app

Insert emojis into Google Sites 
You can now create more engaging content on Google Sites with the new option to insert emojis directly into text boxes and headings. Simply, create or open a Site > click any textbox and the emoji button will be visible in the toolbar > select the emoji button > choose an emoji. 
Insert emojis into Google Sites

Paste HTML into document on iOS 
Last month, we announced the ability to paste copied HTML elements into a document on Android. We’re excited to announce that this functionality is now available on iOS devices.

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.

Bringing Collaborations in Canvas to Google Assignments 
We’re introducing a new feature exclusively for Canvas that allows users to create a Drive item and collaborate on it with other users in the course. | Available to Education Fundamentals, Education Standard, Education Plus, and the Teaching and Learning Upgrade only. | Learn more about the collaborative power of Google Workspace for Education to Canvas. 

Import and convert sensitive Excel files into client-side encrypted Google Sheets 
Launching in open beta, you can now import and convert sensitive Excel files into Google Sheets with client-side encryption. Your encrypted Excel file won’t be changed, even as you change the encrypted Sheets file. | Available to Google Workspace Enterprise Plus, Education Standard and Education Plus customers only. | Learn more about client-side encrypted Google Sheets. 

Google Classroom now supports grade export to Skyward Qmlativ 
Google Classroom teachers can now export their grades to Skyward Qmlativ, a third-party Student Information System (SIS) that helps education teams simplify student and business data management, and complete administrative tasks faster. | Available to Education Fundamentals, Education Standard, Education Plus, and the Teaching and Learning Upgrade only. | Learn more about grade export to Skyward Qmlativ. 

Q&A moderation now available for Google Meet 
Meeting hosts can now enable Q&A moderation, which will allow hosts to review and approve questions before they’re shared with meeting attendees. Question moderation can be used for meetings and in-domain live streams, on web and mobile devices. | Available to Google Workspace Essentials, Business Standard, Business Plus, Enterprise Starter, Enterprise Essentials, Enterprise Essentials Plus, Enterprise Standard, Enterprise Plus, Education Plus, the Teaching and Learning Upgrade, and Nonprofits customers only. | Learn more about Q&A moderation for Google Meet. 

More granular control for Google Forms 
We’re introducing a new toggle in the Admin console that adds controls for who can access Google Forms features and services. When disabled, end users cannot create, edit or respond to Google Forms. | Learn more about Google Forms controls.


Completed rollouts

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


Rapid Release Domains: 

Scheduled Release Domains: 

Rapid and Scheduled Release Domains: 

Import and convert sensitive Excel files into client-side encrypted Google Sheets

What’s changing 

Launching in open beta, you can now import and convert sensitive Excel files into Google Sheets with client-side encryption. Your encrypted Excel file won’t be changed, even as you change the encrypted Sheets file. 


In Google Sheets, navigate to File > Import.




Additional details 

With this release: 
  • You can only import encrypted .xslx Excel file types. 
  • Additional Excel and tabular file types are not supported. 
  • During import, unsupported Excel features in Sheets will be ignored. 
  • The maximum file size is 20MB. 
  • The maximum number of cells that can be imported is 5 million. 

Getting started 


Rollout pace 


Availability 

  • Available to Google Workspace Enterprise Plus, Education Standard and Education Plus customers 

Resources 

Google Workspace Updates Weekly Recap – July 14, 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. 


Improved media viewing on Android devices in Google Chat 
We’re introducing a new media viewer in Google Chat on Android devices that significantly improves the media browsing experience. Now, media thumbnails open faster in full screen, repeat playback is quicker, and you can swipe between all of the media in the conversation. We've also added a shared media option that allows users to quickly browse through all media shared in a Chat conversation, which is accessible from the conversation as well as from the full-screen view of every media item. | Learn more about sending & sharing files in Google Chat messages.




Extending long running queries within Connected Sheets
Currently, we timeout any queries that take longer than 5 minutes for Connected Sheets. This week, we extended the timeout time from 5 minutes to 10 minutes for BigQuery and Looker. This means Connected Sheets users will be able to analyze data from queries that scan even larger data sets in Sheets.  


Filter by measures and value in a pivot table with Connected Sheets for Looker
Previously, Connected Sheets users could filter by dimensions in pivot tables, but not measures. Now, Looker users are able to filter by measures in a pivot table, which allows for even more targeted analysis on Connected Sheets. Additionally, Looker users will be able to filter by value in a pivot table on Connected Sheets. | Learn more about measure types on Looker and creating & using pivot tables. 




Add emojis in Google Sheets
Emojis are a great way for people to express themselves across Google Workspace. We’re excited to announce that you can now insert emojis into a Google Sheet by:
  • Typing “@” > “Emoji” > select the desired emoji
  • Going to “Insert” > “Emoji” > select the desired emoji

Scale meetings to 1,000 attendees, with 500 attendees being viewers, now available for Google Workspace Education Plus
In June 2023, we announced viewer mode for Google Meet. For certain Google Workspace editions, viewer mode can be used to scale their meetings to 1,000 attendees, with 500 attendees being viewers. We’re now expanding this functionality to Google Workspace Education Plus customers. | Learn more about scaling meetings with viewer mode.


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.


Add hyperlinks to text in Google Chat
You can now hyperlink text on web and Android when composing or editing a message in Google Chat. This update also includes the ability to copy over hyperlinks from other places like Gmail, Docs, Sheets and Slides. | Available to all Google Workspace customers and users with personal Google Accounts. | Learn more about adding hyperlinks to text in Chat.


Paid appointment bookings now available in Google Calendar
To improve upon the current capabilities of appointment scheduling, the Google Calendar feature that allows users to share their availability via a booking page, we're now integrating paid appointment bookings into Google Calendar. | Available to Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Standard, Education Plus, the Teaching and Learning Upgrade, Nonprofits and Workspace Individual only. | Learn more about paid appointment bookings in Google Calendar.


Negotiate time directly in Gmail to schedule meetings faster
We’re adding a feature into Gmail that helps you find convenient 1:1 meeting times with others much quicker. This is especially useful when scheduling time with customers, partners or people in your organization whose Google Calendars are not visible to you. | Learn more about scheduling meetings in Gmail.


Completed rollouts

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


Rapid Release Domains:

Google Workspace Updates Weekly Recap – July 7, 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 customers.



Easily convert email addresses and links into smart chips using the tab key in Google Sheets 
You will now have the option to insert a link and press the tab key to convert the link into a smart chip in Google Sheets. Access this feature when you copy and paste email addresses or links to Google Drive files, Google Maps places, or Youtube videos into a Sheet. | Learn more about inserting smart chips in your Google Sheets. 
Easily convert email addresses and links into smart chips using the tab key in Google Sheets

Revamping the "First Open Experience" in Docs on Android devices 
Last week, we announced a more creation-focused experience when first opening the Sheets and Slides apps on Android devices. We’re extending this to the Docs app, which will now start in edit mode. Additionally, the formatting toolbar will be more visible, you will see an I-beam cursor, and tapping once exposes an on-screen keyboard unless a physical keyboard is attached.
Revamping the "First Open Experience" in Docs on Android devices

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.


Pin links to the top of the navigation bar in the Admin console 
Admins can now pin up to five links to the top of the left-hand navigation menu. This is particularly helpful if there are areas of the admin console you navigate to more than others, helping to save clicks and navigate to relevant pages faster. | Learn more about the top of the navigation bar in the Admin console. 

Customize error messages for Google Chat data loss prevention rules, available in open beta 
For new and existing data protection rules for Google Chat, you can now customize the message shown to users when a message is blocked or intercepted. Previously, the message would be a standard warning, shared for all cases. Now, you can provide more context for users, including what they can do to unblock themselves or links to additional resources. | Available to Google Workspace Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Standard, Education Plus, the Teaching & Learning Upgrade, and Frontline Standard customers only. | Learn more about customized error messages for Google Chat data loss prevention rules.

Client-side encryption for Google Calendar is now generally available on mobile 
Earlier this year, we expanded the client-side encryption beta to Google Calendar on mobile to help customers strengthen the confidentiality of their data while helping address a broad range of data sovereignty and compliance requirements. Today, we’re happy to announce that client-side encryption for Google Calendar is now generally available on Android and iOS devices for eligible Workspace editions. | Available to Google Workspace Enterprise Plus, Education Standard, and Education Plus customers only. | Learn more about client-side encryption for Google Calendar on mobile. 

Adding more flexibility to working locations in Google Calendar 
We’re introducing the option to set working locations in Calendar that indicate where you’re working for specific portions of the day. This will help you more accurately reflect your availability based on the physical location you set, which can change throughout the day. | Available to Google Workspace Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Standard, Education Plus, the Teaching and Learning Upgrade, and Nonprofits only. | Learn more about adding your working location for part of a day.

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 – June 30, 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 customers.


Revamping the "First Open Experience" in Sheets and Slides on Android devices 
In addition to the recent announcement that documents on tablet and foldables will now be in paginated mode upon first open, there will now be a more creation-focused experience when first opening the Sheets and Slides apps on Android devices. For example:

In the Sheets app, there will be larger tap targets and tapping once exposes the formula bar, tab bar, and a contextual formatting toolbar. 
Revamping the "First Open Experience" in Sheets
In the Slides app, you will now see the filmstrip on the left-hand side and selecting an object exposes the contextual toolbar and an on-screen keyboard. 
Revamping the "First Open Experience" in Slides on Android devices

Paste HTML into document on Android 
In continuing our mission to provide a top-class user experience on large screen devices, we’re introducing the ability for users to paste copied HTML elements into a document on Android. You can now copy HTML elements to clipboard and paste the elements into a Doc, all while maintaining the formatting elements. 


Easily duplicate groups and objects in Google Sites 
Currently, Google Site editors can duplicate a section of their Site, and the duplicated section appears directly below the section it was duplicated from. Starting this week, we’re extending the duplicate feature by enabling you to easily duplicate objects (images, buttons, text boxes) and groups when editing a Site. | Learn more about adding or editing text & images in Google Sites. 
Easily duplicate groups and objects in Google Sites


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.


Quickly access more features during meetings, available for Google Meet on the web 
We’ve introduced a new quick action to access popular features in Google Meet. By hovering the mouse on top of your own video feed, you can access video effects such as immersive backgrounds or fun filters to bring more fun to your meetings and a reframing option to improve your visibility. | Learn more about features in Google Meet. 

Apply background blur when joining a call using a virtual desktop 
If you’re using a virtual desktop infrastructure (VDI) to join a Google Meet meeting, you can now use background blur and light adjustment. Background blur will intelligently separate you from the background, blurring your surroundings while keeping you clear and in focus. | Available to Workspace Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, and Individual customers only. | Learn more about background blur in Google Meet. 

Google Sheets now integrated with mail merge in Gmail 
Mail merge will support Google Sheets in the web version of Gmail. This integration will allow you to link a Sheet with up to 1,500 recipients and use any data column from your Sheet as a mail merge tag. | Available to Google Workspace Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Standard, Education Plus customers and Nonprofits only. | Learn more about mail merge with Sheets in Gmail. 

Simplified access controls coming to Google Meet beginning July 17, 2023 
We’re introducing simplified controls for meeting access in Google Meet. These will replace the existing Quick access meeting settings and the admin setting to turn Quick access on or off by default will be removed. This update will begin rolling out on July 17, 2023. | Learn more about access controls coming to Google Meet. 

Use polls or Q&As during Google Meet live streams 
If you’re live streaming a video meeting, meeting hosts can now enable the Q&A and poll features, which previously were only offered in traditional Meet meetings. Expanding these features to live streamed meetings will help take your meetings to the next level with a more feature-rich, collaborative experience. | Available to Google Workspace Enterprise Essentials Plus, Enterprise Starter, Enterprise Plus, Enterprise Standard, Education Plus, and the Teaching and Learning upgrade customers. | Learn more about polls and Q&As during Google Meet live streams. 

Making focus time more productive with new Google Calendar setting 
To increase concentration and bridge the gap between do not disturb and focus time, you can now mute notifications for the duration of your focus time directly in Calendar. | Available to Enterprise Standard, Enterprise Plus, Business Standard, Business Plus, Education Standard, Education Plus, and Nonprofits only. | Learn more about the new Google Calendar setting. 

See read receipts for messages in Google Chat group direct messages 
We’re introducing read receipts in group direct messages. With this feature, you can now quickly identify if other members of a group have read your latest message within a Chat stream. | Learn more about read receipts in Google Chat.

Improvements for client-side encryption in Gmail 
We’ve introduced two new features for client-side encryption in Gmail which will help you quickly identify ineligible recipients and any attachments that may be blocked. | Available to Google Workspace Enterprise Plus, Education Plus, and Education Standard customers. | Learn more about client-side encryption in Gmail.


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 Sheets now integrated with mail merge in Gmail

What’s changing

Last year, we made it easier to send individual emails to many recipients with the launch of multi-send in Gmail, and introduced the ability to personalize multi-send emails with mail merge tags like @firstname and @lastname. 

Today, we’re excited to announce that mail merge will support Google Sheets in the web version of Gmail. This integration will allow you to link a Sheet with up to 1,500 recipients and use any data column from your Sheet as a mail merge tag. 
Google Sheets now integrated with mail merge in Gmail

Who’s impacted 

End users 

Why it’s important 

With mail merge you can send more personalized and engaging emails to large audiences from web Gmail. 

Additional details 

With this update, mail merge will fully replace multi-send. We’re also moving the icon for mail merge from the main compose toolbar at the bottom of your email draft to the top-right corner of your compose window. You can still use mail merge without linking a Sheet, using the built-in merge tags: @firstname, @lastname, @fullname, and @email. 

Like multi-send, mail merge emails contain a unique unsubscribe link for each recipient by default. Recipients who unsubscribe from your emails are automatically excluded from future mail merge emails you send. 

Learn more about mail merge in Gmail.

Getting started 

  • Admins: 
    • For Google Workspace Enterprise Standard, Enterprise Plus, Education Standard, and Education Plus customers, mail merge is restricted to internal recipients by default. 
    • For Google Workspace Business Standard and Business Plus customers, mail merge is available for external recipients by default. 
    • For all Google Workspace editions, you can turn mail merge ON for external recipients at the OU or Group level. 
    • Visit the Help Center to learn more about managing Gmail settings for your users, and customizing access policies for different organizational units or groups. 
  • End users: 
    • To link your Sheet to a draft in Gmail: 
      • Turn on mail merge using the icon in the top-right corner of a new compose tab. 
      • Click Add from a spreadsheet and select which Sheet you want to use for recipient data.
        • The Sheet must contain at least one column of email addresses and one column with recipient names. 
          Mail Merge + Add from a spreadsheet
        • Note: Your recipient data must be in the first tab of the Sheet. 
        • Note: Users are limited to 1,500 mail merge recipients or messages per day, and you can't use Cc or Bcc when recipients are added from a Sheet. 
      • Next, you will see a Finish linking spreadsheet dialog:
        • Choose the columns that contain recipients’ email addresses and names. 
      • To insert merge tags to your draft: 
        • Type “@” in your draft to show a list of available merge tags. 
        • Every valid column in the first tab of your Sheet should be available as a merge tag. 
        • Insert the desired merge tag by pressing Enter or by clicking on the tag. 
        • Note: Merge tags can’t be used in the subject line or in links. 
      • Visit the Help Center to learn more about mail merge in Gmail. 

Rollout pace 

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

Availability 

  • Available to Google Workspace Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Standard, Education Plus customers and Nonprofits 

Resources 


Google Workspace Updates Weekly Recap – June 23, 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 customers.



Adding flexibility to email collection in Google Forms 
Previously, when creating or modifying a Google Form and editing the “Responses” section, form creators only had the option to toggle the "Collect email addresses" option on or off. If enabled, this meant when users filled out the form, their email was automatically collected with their form submission. To add flexibility, we’ve introduced the ability to choose between the following email collection options:
  • Verified email collection (previously known as automatic email collection)
  • Responder input (previously known as manual email collection)
  • Do not collect
The verified collection option will now require a user to click a checkbox to confirm which email address is being collected upon submission. | Learn more about viewing & managing form responses. 

Adding flexibility to email collection in Google Forms
Gain consensus from collaborators quickly with voting chips in Google Docs 
You can now add smart chips that contain emojis to use as voting indicators in Google Docs. This feature helps teams express themselves while they’re collaborating in Docs by allowing you to rank or compare ideas. | Available to Google Workspace Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Plus customers and Nonprofits only. | Learn more about inserting smart chips & building blocks in your Google Doc. 
Voting chips 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.


Launching in beta: programmatically write working locations with the Calendar API 
Available now in beta through our Developer Preview Program, you can write a user’s working location using the Calendar API. | 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 only. | Learn more about writing working locations with the Calendar API. 

Enhancing Google Vault file retention capabilities using Google Drive Labels 
Google Vault now supports custom retention rules based on Drive labels. | Available to Google Workspace Business Plus, Enterprise Essentials, Enterprise Essentials Plus, Enterprise Standard, Enterprise Plus, Education Standard, and Education Plus customers only. | Learn more about Vault file retention using Google Drive Labels. 

Respond to access requests for Google Workspace files more efficiently 
Users can now review and respond to requests from within the file. Approvers will see a notification dot on the “Share” button if they have a pending access request and a new banner at the top of the sharing dialog. | Learn more about responding to access requests. 

Monitor additional Google Meet hardware issues in the Admin console 
You can now use the Admin console to detect and monitor additional Meet hardware issues, such as: missing display, missing controller, missing default camera, missing default microphone, missing default speaker, and missing default whiteboard camera. | Learn more about monitoring Google Meet hardware issues. 

Use companion mode to check-in to a Google Meet conference room, so everyone can know you by name
If you’re joining a meeting from a conference room, you can use companion mode on your personal device to check in to that specific room. Room check-in allows everyone on the call to easily identify who is in the conference room, rather than simply seeing the conference room name. | Learn more about companion mode check-in with 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.

Scheduled Release Domains:
Rapid and Scheduled Release Domains:


    For a recap of announcements in the past six months, check out What’s new in Google Workspace (recent releases).

    Add or remove client-side encryption from Google Sheets and Google Slides files

    What’s changing 

    You can now simply add or remove client-side encryption to existing spreadsheets in Google Sheets or presentations in Google Slides. This update gives you the flexibility to control encryption as your documents and projects evolve and progress. This feature is already available for Google Docs. 


    In Google Sheets or Slides, navigate to File > Make a copy > Add/Remove additional encryption.




    Getting started 


    Rollout pace 


    Availability 

    • Available to Google Workspace Enterprise Plus, Education Standard and Education Plus customers 

    Resources 

    Google Workspace Updates Weekly Recap – June 2, 2023

    1 New update

    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.


    Additional updates for the Google Docs, Sheets and Slides apps on Android devices
    In continuing our efforts to improve the Google Workspace experience on large screen Android devices, we’re adding the following updates:
    • The ability to access a vertical context menu when you use mouse right-clicking in the Google Docs and Slides apps.
    docs-vertical-context-menu
    Sheets Android - Formula Keyboard Improvements



    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.


    More call performance data in the Google Voice audit logs
    You’ll now see specific per-call performance information, including: Round Trip Time, Packet Loss per 1000 and Jitter. | Available only to Google Workspace customers who can use the security investigation tool. | Learn more about call performance data in the Google Voice audit logs.


    Expanded actions in the Admin console space management tool 
    We’re giving admins the ability to delete individual spaces and remove individual members from a space. | Learn more about expanded actions in the Admin console space management tool.


    Existing spaces organized by conversation topic will be upgraded to the new in-line threaded experience by Q4 2023
    All existing spaces organized by conversation topic will be upgraded to the in-line threaded experience. We anticipate that this upgrade will take place in early Q4 2023. | Learn more about the new in-line threaded experience. 


    See the top search results first in Gmail on mobile
    When searching in Gmail, machine learning models will use the search term, most recent emails and other relevant factors to show you the results that best match your search query. | Learn more about the improved search experience in Gmail on mobile. 


    Plan, organize, and analyze assignments and grades with grading periods in Google Classroom
    We’re introducing grading periods, an option that allows teachers to define and apply grading periods segmented from the entire school year to their Classroom assignments. | Available to Education Plus and the Teaching and Learning Upgrade customers only. | Learn more about grading periods in Google Classroom. 


    Declutter your conversations in Google Chat
    Chat declutter automatically hides direct messages and spaces that have been inactive for the last 7 days. This feature only activates when a section has more than 10 conversations, and does not affect pinned conversations. | Learn more about accessing your most relevant Chat conversations. 


    Better control the flow of meetings with viewer mode in Google Meet
    To help provide a better experience and scale attendance for larger meetings, you can now select “Everyone is a viewer” when creating your Calendar invite. | Learn more about new controls for meetings 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.


    Rapid Release Domains:
    Scheduled Release Domains: