Author Archives: Unknown

New features to help improve and analyze data in Google Sheets

What’s changing 

We’re launching two features that will make it easier to prepare and analyze data in Sheets: 
  • Cleanup suggestions, which helps ensure your data is accurate by identifying and suggesting fixes for common data errors. 
  • Column stats, which provides automated insights about the values within a column, so you can identify outliers and quickly get a sense of what your data looks like. 

We previously announced that these features were coming soon. See more details below. 


Who’s impacted 

End users 


Why it’s important 

These features assist in the identification of possible cleanup actions, and help you be more confident that your data isn’t distorted by simple errors. It will also enable quicker analysis by generating intelligent views that can help surface insights, which you can then choose to look into more closely. 


Additional details 

Cleanup suggestions 
Before analyzing and making decisions based on data in your sheets, it’s important to clean up your data by rectifying errors and improving data consistency. Cleanup suggestions will help you do this by surfacing intelligent suggestions in the side panel. These suggestions may include removing extra spaces, removing duplicate rows, adding number formatting, identifying anomalies, fixing inconsistent data, and more. This can help make data cleanup faster and more accurate. 



Column stats 
Column stats can help you quickly get a sense for your data by automatically generating visualizations and key stats that provide insight into the data in a specific column. These insights can include count and distribution charts, frequency tables, and summary statistics. This can help you quickly catch potential outliers and confidently move on to deeper analysis. 


Getting started 

  • Admins: There is no admin control for these features. 
  • End users: 
    • Cleanup suggestions: When you are in Sheets, go to Data > Cleanup suggestions. When you import data into Sheets, you may see a proactive notification as well. Visit our Help Center to learn more about cleanup suggestions
    • Column stats: When you are in Sheets, go to Data > Column stats. Visit our Help Center to learn more about column stats

Rollout pace 

Availability 

  • Available to all G Suite customers and users with personal Google Accounts 

Resources 

Service accounts in Google Groups and with Groups API now generally available

Quick launch summary 

We recently announced betas for two new features related to service accounts. Now, these features are generally available: 
  • Support for service accounts in Google Groups, which makes it easier to use service accounts with groups while increasing security and transparency. Learn more
  • Use service accounts with Google Groups APIs without domain-wide delegation, which enables service accounts to perform critical business processes without compromising your strong security and compliance posture. Learn more

Groups are a critical tool for customers to manage their G Suite deployment. Many customers use service accounts with Groups to automate user management, manage migrations, and integrate G Suite with other apps, tools, and services. Use the announcements linked above to learn more about the features and how you can use them. 

Learn more about these and other launches in our Security Blog post highlighting 10 new security and management controls for security at scale

Service accounts in Google Groups 

Getting started 

Rollout pace 

Availability 

  • Available to all G Suite customers 

Resources 

Filter out disruptive noise in Google Meet, now on mobile

Quick launch summary

Google Meet can now intelligently filter out background noise on Android and iOS. This means Meet will automatically remove distracting from your mobile device’s audio input while still letting your voice through.


Getting started

Admins: There is no admin control for this feature.

End users: This feature is OFF by default. Visit our Help Center to learn more about how to filter out noise from your video conference on Google Meet.

Rollout pace

Availability

  • Available to G Suite Enterprise, G Suite Enterprise for Education customers
  • Not available to G Suite Basic, G Suite Business, G Suite for Education, and G Suite for Nonprofits customers
  • Not currently available in some countries (currently including South Africa, the UAE, and surrounding locales). See our Help Center for more availability details.

Resources

Roadmap

Google Meet attendance reports available now for education meetings

What’s changing 

Organizers of G Suite Enterprise for Education meetings will now receive an attendance report via email once the meeting is over. Attendance reports will be generated for web or mobile meetings with at least five (and no more than 250) participants and will contain the following information for each:
  • Participant’s name 
  • Participant’s email 
  • Length of time a participant was on the call, including when they joined and exited 
Once a meeting is finished, you’ll receive an attendance report via email.

The attendance report contains the names, email addresses, and duration of time participants were in the meeting.


Students who have the ability to create meetings will receive attendance reports as well. 

Who’s impacted 

End users 

Why you’d use it 

We hope attendance reports will help meeting organizers keep track of who attended their meetings and for how long, which can be challenging during larger meetings or while presenting. 

Additional details 

Recording attendance for ejected or dial-in participants 
We’ll record the attendance of any participants who chose to dial in. The obfuscated phone number and name displayed during the meeting will appear in the attendance report. 

If a meeting participant is ejected and re-admitted to the meeting, you’ll see the time they first joined and the time they last left. The total duration of their attendance will be a sum of their sessions. 

Getting started 

  • Admins: At this time, there is no admin control for this feature. We’re planning to introduce this setting later this year; stay tuned to the G Suite Updates blog to learn when it launches. 
  • End users: There is no end user setting for this feature. Attendance reports will automatically be sent to the meeting host. Visit the Help Center to learn more about attendance tracking

Rollout pace 

Availability 

  • Available to G Suite Enterprise for Education customers only at this time. 
  • Not available to G Suite Essentials, G Suite Basic, G Suite Business, G Suite for Education, G Suite Enterprise, and G Suite for Nonprofits customers. Stay tuned to the G Suite Updates blog for information when this launches to additional customers. 

Resources 

See which apps are Google verified in the Admin console

Quick launch summary 

With this launch, we’ll show whether apps are Google verified in the Admin console on the app details page and the App Access Control summary page. We hope this visibility will make it easier to make informed decisions about access to G Suite data within your organization. 

Apps often require access to G Suite data to help your users get work done. Google works with app developers to make sure that third-party apps comply with Google privacy and security requirements. 

If apps meet certain verification requirements, they are considered “Google verified”. If they don’t complete the verification process, they are considered “unverified” and might be subject to restrictions. You can control which apps can access sensitive G Suite data via App access control, and choose to authorize unverified apps if you want. 


Getting started 


Rollout pace 

Availability 

  • Available to all G Suite and Cloud Identity customers 

Resources 

Dark theme now available for Docs, Sheets, and Slides on iOS

Quick launch summary 

You can now use Dark theme with Google Docs, Sheets, and Slides on iOS devices. Dark theme is already available for Android users

Dark theme in Google Docs, Slides, and Sheets on iOS. 

You can also preview how your document will look in light theme for collaborators and viewers by selecting the three-dot “More” menu and toggling the “view in light theme” option.  

Getting started 

Rollout pace 

Availability 

  • Available to all G Suite customers and users with personal Google Accounts 

Resources 

See apps installed on managed Windows 10 devices

Quick launch summary 

You can now view a list of all apps installed on Windows 10 devices that you manage with Windows device management. The list includes when the app was first installed, the current version, and the publisher. You can use this information to identify devices that have malicious or untrusted apps on them. 

Note that this feature requires the device to be enrolled in Windows device management. Learn more about our enhanced security for Windows or how to view Windows device details in the Admin console

See apps installed on managed Windows 10 devices 


Getting started 

Rollout pace 

Availability 

  • Available to G Suite Enterprise, G Suite Enterprise for Education, and Cloud Identity Premium customers 
  • Not available to G Suite Basic, G Suite Business, G Suite for Education, G Suite for Nonprofits, G Suite Essentials, and Cloud Identity Free customers 

Resources 

See apps installed on managed Windows 10 devices

Quick launch summary 

You can now view a list of all apps installed on Windows 10 devices that you manage with Windows device management. The list includes when the app was first installed, the current version, and the publisher. You can use this information to identify devices that have malicious or untrusted apps on them. 

Note that this feature requires the device to be enrolled in Windows device management. Learn more about our enhanced security for Windows or how to view Windows device details in the Admin console

See apps installed on managed Windows 10 devices 


Getting started 

Rollout pace 

Availability 

  • Available to G Suite Enterprise, G Suite Enterprise for Education, and Cloud Identity Premium customers 
  • Not available to G Suite Basic, G Suite Business, G Suite for Education, G Suite for Nonprofits, G Suite Essentials, and Cloud Identity Free customers 

Resources 

Migrate users and data between G Suite environments more easily

Quick launch summary 

G Suite Migrate, currently available in beta, helps admins assess, plan, and migrate large amounts of content directly into G Suite. It already supports Microsoft Exchange, Microsoft SharePoint, Microsoft OneDrive, file shares, and Box migrations. With this launch, you can now also migrate between G Suite environments. Specifically, you can: 
  • Selectively migrate Gmail, Calendar, Drive, and more data between G Suite environments. 
  • Choose to migrate all users from one environment to another. 
  • Selectively migrate specific user data (organizational units, users, or subsets of data) between G Suite environments. 

Getting started 

Rollout pace 

Availability 

  • Available to G Suite Business, G Suite Enterprise, G Suite Enterprise for Education, and G Suite Essentials customers 
  • Not available to G Suite Basic, G Suite for Education, and G Suite for Nonprofits customers 

Resources 

Migrate users and data between G Suite environments more easily

Quick launch summary 

G Suite Migrate, currently available in beta, helps admins assess, plan, and migrate large amounts of content directly into G Suite. It already supports Microsoft Exchange, Microsoft SharePoint, Microsoft OneDrive, file shares, and Box migrations. With this launch, you can now also migrate between G Suite environments. Specifically, you can: 
  • Selectively migrate Gmail, Calendar, Drive, and more data between G Suite environments. 
  • Choose to migrate all users from one environment to another. 
  • Selectively migrate specific user data (organizational units, users, or subsets of data) between G Suite environments. 

Getting started 

Rollout pace 

Availability 

  • Available to G Suite Business, G Suite Enterprise, G Suite Enterprise for Education, and G Suite Essentials customers 
  • Not available to G Suite Basic, G Suite for Education, and G Suite for Nonprofits customers 

Resources