The Scenario
The company just completed a storage tier upgrade. Sixty users are moving from the 5 GB plan to the 25 GB plan. Your IT manager handed you a sheet before leaving for a client call: 60 rows, columns A and B — ZohoUserId and NewPlan. She said to apply the changes before end of business.
The bad version:
- Open the Zoho Admin Panel, navigate to the user accounts section, search for the first user ID from the sheet, click into their account, find the storage settings section, change the plan from 5 GB to 25 GB, click Save, go back to the search, type the next user ID from the sheet.
- Repeat for all 60 users, being careful not to accidentally apply the wrong plan to the wrong account because you pasted the user ID from the wrong row.
- Close the admin panel and mark the task done with no audit trail unless you remembered to note down each change manually.
The upgrade list was ready before the call ended. The only work left is applying it — and the Zoho admin panel forces you to do that one user at a time, by hand, with no way to batch the operation natively.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent embedded in your Google Sheet. It reads the user ID and plan data from your sheet and applies the storage tier changes through the Zoho Mail admin integration. Open the sidebar, describe the update.
Update the storage plan for each user in this Sheet — use the ZohoUserId column and the NewPlan column to set the correct storage tier for all 60 users at once via Zoho Mail
What You Get
- The storage plan updated for each user listed in the sheet, using the values in columns A and B.
- SheetXAI writes an update status into column C for each row: Updated, or an error note if a user ID was not found or the plan value was invalid.
- All 60 updates applied in one operation, not 60 separate admin panel sessions.
- The sheet becomes the audit log — every row shows the user ID, the new plan applied, and the status of the change.
What If the Data Is Not Quite Ready
Some plan values in column B are not in the expected format
Before updating, check column B for plan values that do not match the expected format (25GB, 50GB, 100GB) — write "Invalid plan" into column C for any non-conforming row, then apply the updates for all valid rows
Some user IDs may no longer exist in the organization
Attempt to update the storage plan for each user in the Sheet using ZohoUserId and NewPlan — for any user ID that cannot be found in the Zoho Mail org, write "User not found" into column C and continue to the next row
You need to apply updates only to users currently on a specific plan
Update the Zoho Mail storage plan only for users in this Sheet where their current plan is 5GB — skip any user already on 25GB or above, write "Already upgraded" into column C for those rows, and apply the new plan for the rest
Validate plan values, filter by current plan, apply updates, and log results in one shot
Check column B for any plan values that do not match 25GB, 50GB, or 100GB and mark those "Invalid" in column C — for the valid rows, apply the storage plan update only to users currently on the 5GB plan, mark already-upgraded users "Already upgraded," and mark successful updates "Updated" in column C
The validation, filter, and update all run together so you hand the IT manager a sheet where every row tells its own story.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a user ID and storage plan list, then ask it to apply the batch update. See also: Audit user storage across the org. Or return to the Zoho Mail hub.