As a Google Workspace administrator, you've likely encountered a common frustration: visibility. While Google Voice is a powerful tool, managing it at scale can be tricky when the native tools don't give you the specific views you need.
The Problem
Currently, Google Workspace administrators face two main hurdles when auditing phone assignments:
- Admin Console Limitations: There isn't a single, "at-a-glance" report in the Admin Console that maps every assigned Google Voice number to its respective user.
- API Filtering: While the Directory API allows you to list users, it doesn't provide an easy way to filter specifically for those with Google Voice numbers assigned without fetching and parsing the entire user object.
The Solution: GAM 7.36.00+
With the release of Google Apps Manager (GAM) 7.36.00, we finally have a streamlined way to export this data. We can now target users with Google Voice licenses and extract their assigned numbers directly into a Google Sheet.
The Command
Run the following command in your terminal to generate a full report:
gam license voicepremier print users fields primaryemail,phone filtermultiattrcustom phone "Google Voice" todrive
Breaking Down the Logic
-
gam license voicepremier print users: Targets only the users who have a Google Voice Premier license assigned. (Change voicepremier to voicestandard if applicable to your organization). -
fields primaryemail,phone: Tells GAM to specifically retrieve the user's email address and their phone attributes. -
filtermultiattrcustom phone "Google Voice": This is the "magic" part. It filters the results to only show phone numbers that are tagged as "Google Voice" numbers, excluding personal mobile or desk phone entries. -
todrive: Automatically uploads the resulting CSV data to a new Google Sheet in your Admin account for easy sharing and sorting.
Why This Matters
Auditing your numbers is crucial for cost management and ensuring that employees have the correct contact information listed in the company directory. By using GAM, you turn a manual, multi-hour verification process into a single-line command that takes seconds.
Are you using GAM to manage Google Voice? Let me know in the comments if you have any other useful scripts!
Resources:
Top comments (0)