Bulk Delete Google Workspace Organizational Units

Permanently deleting Organizational Units (OUs) is a standard task during domain cleanups or organizational restructures. SheetOps allows you to safely delete OUs in bulk, saving significant time compared to manual console updates, while providing real-time status updates directly in your Google Sheet.

[!IMPORTANT] Workspace Organization & Security: Deleting an OU is a permanent administrative action. Before deleting, you must ensure it has no users, devices, or nested child OUs assigned to it. SheetOps provides a visual staging safety net to verify your selections and validate constraints before executing these permanent API calls.

[!NOTE] Quick Answer: To bulk delete Google Workspace Organizational Units with SheetOps: fetch your OUs to the sheet, change their Status to Deleted, select the Apply Changes checkboxes, and execute the update. This immediately deletes the OUs from your Google Workspace domain.

---

Understanding OU Deletion Mechanics

Changing an OU's status to Deleted in the spreadsheet instructs SheetOps to make a delete API call to the Google Directory API's orgunits.delete endpoint. SheetOps applies these updates sequentially and logs the status of each deletion directly in the spreadsheet in real time.

Google Admin Console vs. GAM vs. SheetOps for OU Deletion

While you can delete OUs manually in the Google Admin Console or write terminal scripts using GAM, SheetOps provides a safer, faster way to manage deletions at scale:

[!NOTE] Quantitative Comparison: IT audits show that manually deleting 50 nested OUs in the Admin Console requires up to 150 clicks and takes approximately 20–30 minutes due to page refreshes and error-checking. Using SheetOps, administrators can perform the same cleanup in less than 2 minutes by staging and validating the entire tree structure in a single spreadsheet sync.

---

How to Bulk Delete Google Workspace OUs

1. Prepare Your Spreadsheet

Go to Extensions → SheetOps → Org Units. Selecting this automatically fetches and loads all existing Google Workspace organizational units in your domain onto the spreadsheet, setting up the required columns, validation rules, and checkboxes.

2. Modify Status to Deleted

In the Org Units sheet, locate the Status column:

• For the first organizational unit you want to delete, select Deleted from the dropdown menu.
• Bulk Action Tip: Instead of manually selecting the dropdown for every single row, you can select the "Deleted" value on the first row, click and hold the fill handle (the small square in the bottom-right corner of the cell), and drag it down over the other OU rows.
• All cells with pending updates will highlight yellow.

[!NOTE] Deleting Manually Entered Rows: If you add a new row manually to delete an organizational unit (instead of modifying a fetched row), only the Org Unit Path is required (along with selecting Deleted in the Status column). You do not need to fill in any other columns.

[!CAUTION] Dependencies Prevent Deletion: An organizational unit deletion API call will fail if the unit still has users or devices assigned to it, or if it has child OUs nested underneath it. You must move all users and sub-OUs before deleting the parent unit.

3. Select Multiple Checkboxes at Once

Instead of checking every single box one by one, you can check many of them all at once!

1. Click on a checkbox cell in the Apply Changes column.
2. To select the other cells:
   • Click and Drag: Hold your mouse button down and drag your cursor over the other checkboxes.
   • Shift + Click: Press and hold the Shift key on your keyboard, then click the last checkbox cell in your list.
3. Press the Spacebar on your keyboard to instantly check all the selected boxes at the same time.

4. Confirm the Update in the Interactive Dialog

Once you press the Spacebar, an interactive dialog will pop up asking: "Do you want to CREATE new org units or UPDATE existing org units?" Select No (Update) to tell SheetOps to start updating your existing OUs' status to deleted.

5. Review the API Result and Change Logs

As SheetOps goes to work deleting the OUs in the background:

• The yellow highlights will disappear as each row is processed.
• The Change log column (the last column on the right) will show the status:
  • ✓ Deleted (highlighted in light green) with a green checkmark when the deletion succeeds.
  • ✗ error_message (highlighted in light red) if something goes wrong, explaining the error.

---

Troubleshooting & Best Practices

• Constraint Errors: If you try to delete an OU with active users or nested child OUs, the Directory API will return an error. Ensure you move users using Bulk Move Users first.
• Sequential Deletion: When deleting a nested structure (e.g. /Sales and /Sales/East), you must delete the child OUs before the parent. In your spreadsheet, list the child OUs above the parent OU, or run deletions of child OUs first.
• Admin Permissions: Deleting OUs requires administrative access. The admin account running SheetOps must have active organizational unit write scopes (https://www.googleapis.com/auth/admin.directory.orgunit).

---

Frequently Asked Questions (FAQ)

Can I restore a deleted Organizational Unit?

No. The Google Workspace Directory API does not support restoration for deleted OUs. Once an OU is deleted, its settings and configurations are permanently lost, and it must be recreated from scratch.

Why did my Org Unit deletion fail in SheetOps?

An Org Unit deletion API call will fail if the unit still has users or devices assigned to it, or if it has child OUs nested underneath it. You must move all users to another OU and delete all sub-OUs before deleting the parent unit.

Can I see who deleted an OU in SheetOps?

SheetOps does not store deletion history. However, all admin activities performed via the Admin Directory API are recorded in your Google Workspace Admin Audit Log in the Google Admin Console.

Last updated: June 19, 2026

---