U-M Google Updates

U-M Google April Monthly Summary

The monthly U-M Google Summaries inform campus of Google releases for Core Apps as well as the Non-Core Apps (those that are not part of the G Suite for Education agreement). We communicate important information on Core Apps throughout the month. Core and Non-Core Apps are listed on the G Suite website.

Core Apps:

You can now customize the actions you can take when swiping on an email in Gmail on your iOS device.

Swipe actions can be set up to do any of the following actions: Archive, Trash, Mark as read/unread, Snooze, and Move to.

gif of new Gmail swipe actions

You can access the swipe configuration settings by going into the Gmail iOS app and navigating to Settings > Swipe actions, and choosing the swipe options that work best for you.

Google has added the ability for users to embed MP3 and WAV audio files from Drive into Slides.

To insert an audio file into Slides:

  • Insert > Audio and select from your audio files in Drive
  • Hover over the icon to see playback controls

Once the audio file is inserted, you can find audio settings by clicking Format options in the toolbar. From there, you can set playback options, volume, and looping. You can also hide the audio icon or replace it with an image of your choice.

open computer to Slides showing new audio functionality

The ability to add an audio file into Slides is currently only available on desktop, though audio will play on all platforms.

Soon you will be able to edit the theme colors for your presentations in Slides, making it easier to set up a new theme or apply bulk color changes to existing presentations. To do this, go to any color picker dropdown and click the edit button for your Theme color palette. In the Theme color sidebar, select a color from the dropdown to begin editing.

gif of how to customize colors in Google Slides

Note: These changes will only apply to the current theme and will not create a new theme

Now, if guests of a Calendar event have been granted permission to invite others, recipients of forwarded invitation emails can RSVP to the event, adding them to the event as a guest. This eliminates the step of having to go into the event in Calendar to invite additional guests.

gif of how to  use the new RSVP via email for Calendar

Note: For this feature to work, the organizer must have granted permission for guests to add other guests to the event.

Option for allowing guests to invite other individuals to an event

Rooms will no longer accept two Calendar events that overlap in time. Previously, if an event was created directly on a room’s calendar by someone with permissions, the room would accept this meeting even if another event had already added this room for that same time. Now, if the room has already accepted another meeting, creating a new event at the same time on the room’s calendar will result in a room decline of this conflicting meeting.

Google has added new features and tools to create more compelling and stylized reports in Sheets:

  • Guides
    You can use guides to help you align, size, and position various objects within your sheets. Guides are also helpful in making sure multiple objects within the same sheet are in proportion to one another.
  • Multi-Selecting Objects
    To select multiple charts, drawings, and images to move, resize, or delete in bulk, hold down the Control or Shift key and select.

gif of multiselection in GOogle Sheets

  • Enhanced Pivot Table Insertion
    When adding a new pivot table, you now have the option to either place it in a new sheet or in a custom location on an existing sheet.
  • To create a new pivot table, go to Data > Pivot Table and select a data range.
  • In the dialogue box, under Insert to, select New sheet or Existing sheet, and click Create.
Note: If you select an existing sheet, you’ll have to select a specific cell location for the pivot table.
  • Copy and paste images into Sheets
    You can now copy images from other websites and paste them directly into your sheet. Simply right-click on an image and select Copy, then in Sheets right-click and select Paste to insert the image over the grid.
  • Formula backed charts inserted from Answers
    Now, when you use Sheets Explore to create charts, the charts you insert from the Q&A feature (Answers) will be backed by formulas. This means that charts will automatically update if the underlying data changes, ensuring you always have a fresh chart with the latest information.

According to Google, these features began rollout on May 2nd and may take up to three days for feature visibility.

Google has made it possible to copy much larger sites in order to help users efficiently copy their existing sites, allowing them to back up their work, iterate on previous sites, or create ‘templates’ to start new sites.

To make a copy with the improved site copy, open a site in the new Google Sites, click More > Duplicate site.

gif depicting how to duplicate a larger site
 

Previously Communicated:

Note: Keep in mind that even when Non-Core Apps are found in a Core App (like Add-ons in Gmail and Google Drive), they are not covered by the G Suite for Education agreement.

New live captions in Hangouts Meet!

Google has made Hangouts Meet more accessible for hearing impaired users with live captions. Live captions help make meetings more accessible by reducing barriers to holding meetings between users of different hearing abilities, regardless of whether they are participating remotely or in person.

Screenshot of Google Hangouts Meet example of captions

On the web, navigate to the triple-dot menu at the bottom right corner of your screen and select it. Then, select Turn on captions. The captions will start to generate when someone begins speaking.

Google Hangouts Meet turn on captions button

When you turn on captions, they will only be visible on your device. In order for other participants in the meeting to see captions, they’ll have to individually turn it on for their devices.

Currently, live captions are only available in English. Finally, captions will not appear in a recording of a meeting.

For more information, visit Google’s Product Updates blog post.

Threading changes in Gmail conversation view

Google has announced changes to how Gmail threads messages when you have conversation view turned ON. This change helps to make sure that messages are only threaded when there is a definite relationship between them.

Gmail settings turn Conversation View On

Previously, Gmail would thread together messages when either:

  • A message is sent in reply to another, or
  • A message has:
    • The same sender or recipients
    • The same subject
    • Is sent within one week of an earlier message in the thread

With this change, Google has added the requirement that an incoming message’s Reference header, if present, must reference IDs of previous messages in order to thread. This means that if you receive two emails with the same subject from the same sender, these emails will not be threaded together unless one explicitly references the other.

For further clarification, the first email’s Message-ID should match the second email’s References and In-Reply-To.

Gmail threading example with emails

For more information, visit Google’s G Suite Updates blog.

Write now, send later with Schedule send in Gmail

You will soon be able to schedule your emails in Gmail to be sent at a later date and time.

When drafting an email or reply in Gmail, you will see an arrow next to the Send button. Clicking this arrow will give you the option to Schedule send. After clicking Schedule send, you can pick the specific date & time at which you’d like the message to be delivered.

GIF depicting how to schedule send in Gmail
 

This feature will be available on Android and iOS apps and Gmail on desktop browsers.

With this launch, Google will also be adding a Scheduled folder in Gmail. Scheduled messages will appear in the Scheduled folder while queued to be sent.

Note: It is expected behavior that you may see the Scheduled folder before you are able to schedule emails.

new Gmail scheduled send Scheduled folder
 

According to Google, the full rollout for scheduled send starts on April 15, 2019, and may take longer than 15 days for feature visibility. For more information, visit Google’s G Suite Updates Blog.

It’s now easier to insert images in cells in Google Sheets!

You can now insert any image, like those saved on your desktop or mobile device, into a cell by using the new option found inside the Insert menu or the IMAGE function.

You can add images directly to cells in two ways.

On Desktop

  • Use the IMAGE() function within a cell
  • Via the menu bar at the top of the spreadsheet:
    • Select Insert > Image > Image in cell
    • Then select an image from Google Drive or upload one from your computer.

gif of Google Sheets steps to insert picture

On Mobile

  1. Tap once on a cell to select it.
  2. At the top of the screen, select the “+” icon.
    google sheets screenshot - step one of inserting image
  3. Select Image > Image in cell.
    google sheets insert image - step two  google sheets insert image - step three
  4. Select an image from the options presented to you: From Photos or From Camera
    Google sheets insert image - step four