Back to Zoho Mail in Google Sheets
SheetXAI logo
Zoho Mail logo
Zoho Mail · Google Sheets Guide

Bulk Delete Obsolete Zoho Mail Groups Using a Google Sheet

2026-05-14
5 min read

The Scenario

Your organization just completed a restructure. Thirty-five distribution groups were decommissioned last month as part of the reorg. Somebody put all the group IDs in a sheet — column A, 35 rows. The groups still exist in Zoho Mail. The IT admin who built the original group structure left the company two weeks ago. You need to clean them out before the next billing cycle.

The bad version:

  • Open the Zoho Admin Panel, navigate to the mail groups section, find the search bar, paste the first group ID from the sheet, locate the matching group in the results, click into it, scroll to the delete option, confirm the deletion, go back to the groups list, paste the next group ID.
  • Repeat 34 more times, keeping careful track of which rows in the sheet you've already processed so you don't delete something twice or miss an entry while your attention drifts somewhere around row 20.
  • Close the admin panel with no record of which groups were deleted or when, unless you manually noted each one.

The group IDs were compiled by someone who no longer works here, which means re-checking the list for accuracy before running the deletions is now also your problem. The admin panel doesn't make that part any easier.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent embedded in your Google Sheet. It reads the group ID list and runs the bulk deletion through the Zoho Mail admin integration. Open the sidebar, describe the operation.

Delete all Zoho Mail groups whose IDs are listed in column A of this Sheet in a single bulk operation, and mark each row "Deleted" in column B when done

What You Get

  • Each group ID in column A processed against the Zoho Mail admin API.
  • Column B updated with "Deleted" for each successful deletion, or an error note if a group ID was not found or the deletion was rejected.
  • The entire 35-row operation runs in one pass — not 35 separate admin panel sessions.
  • The sheet becomes the deletion log — every row documents whether its group was successfully removed.

What If the Data Is Not Quite Ready

Some group IDs in the list may have already been deleted by someone else

Attempt to delete each Zoho Mail group in column A — for any group ID that no longer exists or has already been removed, write "Not found" into column B instead of an error, and continue processing the remaining rows

You want to verify the groups exist before deleting them

Before deleting, check whether each group ID in column A exists in the Zoho Mail org — write "Exists" or "Not found" into column B, then delete only the groups confirmed to exist and update their column B status to "Deleted"

Some rows have blank or malformed group IDs that should be skipped

Skip any row in column A where the group ID is blank or does not match a standard Zoho group ID format — write "Skipped - invalid ID" into column B for those rows, and delete the valid group IDs with a "Deleted" status in column B

Validate IDs, verify existence, delete confirmed groups, and log everything in one shot

Check column A for blank or malformed group IDs and mark them "Skipped" in column B — for the valid IDs, verify each exists in the Zoho Mail org, mark non-existent ones "Not found," then delete the confirmed groups and mark them "Deleted" — all results written into column B

One pass handles the validation, the existence check, and the deletions so the sheet reflects exactly what happened.

Try It

Get the 7-day free trial of SheetXAI and open any Google Sheet with a list of decommissioned group IDs you need to clean out of Zoho Mail, then ask it to run the bulk deletion. See also: Bulk update group settings. Or return to the Zoho Mail hub.

Stop memorizing formulas.
Tell your spreadsheet what to do.

Join 4,000+ professionals saving hours every week with SheetXAI.

Learn more