Bulk Suspend Google Workspace Users from Sheets

Suspending user accounts is a critical administrative action during employee offboarding or security incidents. SheetOps lets you suspend Google Workspace users in bulk directly from Google Sheets, disabling login access while keeping their data intact.

[!IMPORTANT] Offboarding Security: Immediate deprovisioning is vital for corporate security. According to industry reports, up to 20% of ex-employees retain access to corporate data due to delayed deprovisioning. As Google's official Security Best Practices state, "deprovisioning of terminated users must be immediate and comprehensive to prevent unauthorized access to corporate resources." SheetOps facilitates this by removing manual administrative delays.

[!NOTE] Quick Answer: To bulk suspend Google Workspace users with SheetOps: export your users to a sheet, change their Status to Suspended, select the Apply Changes checkboxes, and execute the update. This immediately revokes login access and terminates active sessions while preserving all user data.

---

Understanding User Suspension Mechanics

In SheetOps, every user row contains a Status column (status). By modifying this value to Suspended, you instruct SheetOps to make an API update to suspend the user's login access. Under the hood, SheetOps sets the suspended attribute to true in the Google Admin SDK Directory API.

Google Admin Console vs. GAM vs. SheetOps for User Suspension

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

---

How to Bulk Suspend Google Workspace Users

1. Prepare Your Spreadsheet Template

To target and update users, you have two options to bring them into the sheet:

• Fetch with Filters: Go to Extensions → SheetOps → Users, select Fetch with Filters, and choose your target criteria (such as a specific organizational unit) to bring existing users to the sheet. For a detailed guide on how to filter workspace users, refer to the filtering guide. Once imported, you can suspend accounts as needed.
• Just the Sheet: Go to Extensions → SheetOps → Users, select Just the Sheet, and click Create Sheet to generate a clean template. You can then simply input the user email and change their status.

2. Modify Status to Suspended

In the user sheet, locate the Status column (the third-to-last column):

• For the first user you want to suspend, select Suspended from the dropdown menu.
• Bulk Action Tip: Instead of manually selecting the dropdown for every single row, you can select the "Suspended" 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 user rows. This instantly copies the Suspended status across all selected rows.
• All cells with pending data or updates will highlight yellow.

[!TIP] When you enter data or select dropdown choices, SheetOps automatically applies a yellow background to the edited cells. This visual indicator helps you keep track of pending changes before you push them.

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. This highlights all the cells in between!
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 users or UPDATE existing users?" Select No (Update) to tell SheetOps to start updating your existing users' status to suspended.

5. Review the API Result and Change Logs

As SheetOps goes to work updating the users 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:
  • ✓ Updated (highlighted in light green) with a green checkmark when the update succeeds.
  • ✗ error_message (highlighted in light red) if something goes wrong, explaining the error.

---

How to Unsuspend or Restore Users

If you need to restore access to a suspended user account, you can perform the exact same update flow but change their status back to active:

1. Locate the suspended user row in your sheet (or use Fetch with Filters and set User type to Suspended to load them).
2. Change the value in the Status column to Active. You can also use the drag-to-fill handle to restore multiple users in bulk.
3. Check the Apply Changes column for those rows (using the multi-select Spacebar trick for bulk operations).
4. Click apply, and in the interactive confirmation dialog, select No (Update).
5. Once complete, the Change log will display ✓ Updated, and the user's login access will be immediately restored.

---

Troubleshooting & Best Practices

• License Preservation: Suspended accounts continue to incur subscription license fees unless you archive or delete them. Converting accounts to Google Archive User (AU) licenses typically reduces licensing costs by 75% to 80% (ranging from $1.50 to $7.00 per user/month). If your goal is to save on licensing costs, consider archiving the user or deleting the account. For more details on licensing policies, see the Google Workspace Help Center.
• Immediate Propagation: While policy changes can take up to 24 hours to propagate in Google Workspace, account suspension or restoration is instantaneous. The user's active login sessions are terminated immediately upon suspension.
• Data Retention & Transfer: Suspending a user blocks their login but retains all of their data (Gmail, Google Drive files, Calendar events, etc.) intact. Because they own their data while suspended, you can safely transfer their Drive files to another owner using Google's Data Transfer tool prior to eventual deletion.
• Email Forwarding: If you want a suspended user to stop receiving new emails or set up an auto-responder, you must configure email forwarding or routing rules before or during the suspension period, as suspended accounts continue to accept incoming mail.

---

Frequently Asked Questions (FAQ)

Does suspending a user stop incoming emails?

No. Suspending a Google Workspace user only blocks their login access. Their mailbox continues to receive emails in the background. If you want to block incoming mail or bounce messages, you must delete the user or delete their email alias.

Can I suspend users and free up Google Workspace licenses?

No. Suspended users still occupy an active Google Workspace license. To stop paying for a license, you must either Archive the user (with an Archive User license, which is cheaper) or Delete the account entirely.

How do I suspend only specific users (e.g. by domain)?

You can use standard spreadsheet filters in Google Sheets. Export all users, filter the table by domain or department, select 'Suspended' for those rows in bulk, tick the 'Apply Changes' checkboxes, and click apply.

Last updated: June 18, 2026