U-M Google Updates

New Updates to Google Sheets


Macros in Sheets

Starting today, you can record macros in Sheets. Now, when you record a macro, Sheets automatically converts the macro actions into an Apps Script. With this feature, if you want to update your macro, you can edit the script directly instead of having to re-record the macro from scratch. You can also write your own Apps Script functions and import them as new macros.

Sheets macros are built for use in cloud-based files, which means that teams can run macros at the same time that others are working in the sheet. It also means that coworkers or clients won’t be forced to download sensitive files to use macros. Because your Sheets files are in the cloud, you can keep tighter controls over who can view and re-share your data.

More updates to Sheets

In addition to the new ways to record macros, Google has added more updates to Sheets based on frequently requested features:
Printing page breaks, custom paper sizes
More options for row and column grouping 
Checkboxes in cells 
Grouping data by time frame (week, month, or year) when creating pivot tables
Intelligent pivot tables 


Try Out the New Gmail!


G Suite is introducing an all-new Gmail, with a brand new look on the web, advanced security features, Google’s suggested replies and even more integrations with other G Suite apps. They are also introducing a new way to manage work on the go with Tasks.

The U-M Google team entered the UMICH domain into the early adopter program for the new GMail. If you are curious, check out the new Gmail on the web to see what’s new and what has changed. We also encourage you to tell us about your experiences to help us prepare campus for the change. Google is still rolling out new features, some of which include:

  • Hover over unopened messages in your inbox and click an icon to archive, delete, mark as unread (or read), or snooze messages.
  • Postpone reading emails to a future date or time that's more convenient. Learn how to snooze emails.
  • Quickly reply to emails using phrases that appear based on the message you've received. Learn how to use Smart Reply.
  • You might see old emails at the top of your inbox with a suggestion to reply or follow up.
  • Change how spacious or compact you want your inbox view. In the top right, click Settings > Display density.
    Tip: If you choose Default, you'll see a preview of attachments from your inbox.
  • You can now use Google Calendar, Keep, Tasks, and Add-ons while in Gmail.

To try out the new Gmail and get comfortable with it before it becomes general availability, select Try the new University of Michigan Mail from the Settings  menu. You can still switch back to the Classic University of Michigan Mail using the same Settings menu.

Note: You may need to refresh your web browser.

Let Google know what you think of the new Gmail. Click Send feedback from the Settings menu.

Learn more about the new Gmail on the G Suite Help site.

Google Drive Desktop Application Stops Working May 12


As we announced in September and in February, the Google Drive desktop application will stop working on May 12, 2018. Accessing Google Drive with a web browser is not affected.

Recommended Action:

Note: MiWorkspace devices with Google Drive will receive the new Drive File Stream as part of the regular weekly updates on May 10.

  1. Uninstall Drive (standard OS uninstall)
  2. Uninstall Backup and Sync (special process)
  3. Install Drive File Stream

Reminder: To use Drive File Stream on macOS 10.13 (High Sierra):

  1. Open Drive File Stream.
  2. At the top left, go to the Apple menu and then System Preferences and then Security & Privacy.
  3. Next to "System software from developer 'Google, Inc.' was blocked from loading," click Allow.

Learn more about Drive File Stream at the G Suite Help Center.

Google I/O 2018


Are you interested in the new and exciting things that Google is working on? Watching the 2018 Google Input/Output (I/O) conference is a great way to learn what’s happening now and what’s on the horizon. Google will stream events and speakers from May 8–10. A schedule of events is available for people interested in viewing the conference.

Coming Soon: Google Chrome Verification Pop-Up


Starting May 7, 2018 you might see a new window when logging into University of Michigan Google resources using Chrome as a web browser. After logging in to weblogin, the page will redirect to a new screen at accounts.google.com to confirm your identity. Verifying your identity this way will provide an additional layer of security and help prevent anyone from accidentally signing in to an account created and controlled by an attacker. To minimize disruption, this feature will only display the pop-up once per account per device