The Scenario
You're the IT administrator for a Google Workspace domain with roughly 800 users. Someone from HR handed you an org chart project this morning: they need every employee's display name, work email, job title, and department in an Excel workbook by end of week so the designer can build the chart. No partial list. All 800.
You could go into the Admin Console and export a user list. The export runs, the CSV downloads, and you open it in Excel to find 47 columns — most of them empty, the headers in a format that doesn't match what HR asked for, and the job title and department columns nowhere near column A.
The bad version:
- Open the Admin Console export in Excel, spend 30 minutes deleting columns, renaming headers, and reformatting the data into the shape HR actually needs
- Use the Directory API in Apps Script or a PowerShell module, write the pagination logic, handle the 100-user-per-page limit, debug the token expiry, and spend the afternoon on it instead of the three other tickets waiting
- Export page by page through the Admin Console (if your domain is big enough that it times out), stitch the CSV files together in Excel manually, and run the cleanup twice
None of those paths delivers a clean workbook in the next 20 minutes.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It can query your Google Workspace domain directory through the Google People API and write every user record into the workbook — paginated automatically, formatted to your spec, in a single prompt.
Search my Google Workspace directory for all users and export their names (A), email addresses (B), phone numbers (C), and organizations (D) into my Excel workbook — fetch all pages of results and write results to the "Directory" worksheet
What You Get
- Every user in the Google Workspace domain written to the "Directory" worksheet, one per row, across all pages of the directory API response
- Columns set exactly as specified: display name, email, job title, department
- A row count written to a summary cell so you can verify the total matches what the Admin Console reports
- The workbook ready to hand to HR without any additional cleanup
What If the Data Is Not Quite Ready
You also need phone numbers, and they're not always in the directory
List all users in my Google Workspace domain directory and write their display name (A), email (B), job title (C), department (D), and primary phone number (E) to the "Directory" worksheet — for users with no phone number on file, leave column E blank
You only need users from a specific organizational unit — not the whole domain
List all users in the "/Engineering" organizational unit of my Google Workspace domain and write their display name (A), email (B), job title (C), and manager email (D) to the "Engineering Directory" worksheet — fetch all pages
You want to cross-reference the directory export with an existing headcount workbook to find discrepancies
Export all users from my Google Workspace domain directory to the "Live Directory" worksheet with columns for display name, email, job title, and department — then compare against the "Headcount" worksheet (column B has emails) and write "matched", "not in headcount", or "not in directory" to column E of each worksheet for each email
You need the full picture: directory data plus last login date for an access audit
List all people in my Google Workspace domain directory and write their display name (A), email (B), job title (C), department (D), and last login date (E) to the "Access Audit" worksheet — sort by last login date ascending so the oldest logins are at the top, and flag anyone who hasn't logged in since 2025-11-14 with "review" in column F
One prompt handles the export, the sort, and the conditional flagging — no separate formulas or filtering step needed after the fact.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook, then ask SheetXAI to pull your Workspace directory into it — the full paginated result lands in seconds. For related tasks, see Bulk Import Contacts Into Google Contacts From a Google Sheet and the Google Contacts overview.