Passer au contenu principal
Back to projects
Apps Script Admin SDK Sheets

Google Workspace Directory Bulk Update

Audit then bulk-edit Workspace directory users from Google Sheets, with a prior dry run.

Description

Editing hundreds of records in the Admin console, or through a CSV import, always leaves a doubt: was a field overwritten, was a user suspended by mistake? This spreadsheet-bound tool makes every change visible before it is applied.

  1. Load the directory: the whole domain, an organizational unit or a targeted query.
  2. Edit the cells in the spreadsheet, with validation rules.
  3. Compute the differences: nothing is written, a report details each change row by row against the live directory.
  4. Review, tick, apply, after a dry run if you wish.

Standard fields, multi-valued fields (phones, organizations) and automatically discovered custom attributes. A double lock keeps the tool read-only until writing is explicitly enabled, and every change is logged.

Use Cases & Features

Fix dozens or hundreds of user records (department, phone, title, custom attributes) without opaque CSV imports.

Infos dépôt

  • Licence Elastic-2.0
  • Plateforme GitLab
  • Auteur Fabrice Faucheux