The Scenario
End of Q1. Twenty-three people left the company over the past three months. HR has compiled the offboarding records into an Excel workbook — Roam SCIM user IDs in column A, names in column B, departure dates in column C. Legal wants confirmation that all Roam access has been revoked before the audit closes next Tuesday.
The accounts are still active in Roam. They've been sitting there since the last person's last day.
The bad version:
- You open Roam's admin console and search for each departing employee by name. Some names don't match exactly — one was a nickname, two had name changes during tenure. You find 18 of the 23.
- For the remaining five, you fall back to the SCIM IDs from the workbook and try to deactivate them via the SCIM endpoint manually. Three calls succeed. Two return 404 errors you can't easily explain before the deadline.
- You mark the audit response "partially complete" and spend the next day chasing down the edge cases with the DevOps team.
Legal doesn't care that SCIM was hard to use. They care that the accounts are off.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your offboarding data and sends the SCIM deactivation calls to Roam for every row — you don't write a single API call.
Archive all 30 Roam users listed in my Excel 'Departed Staff' sheet using SCIM — SCIM IDs in column A, log the result status in column B
What You Get
- Each SCIM user ID in column A gets a PATCH request setting active to false in Roam
- Column B gets "Deactivated" written next to each successful row
- Any row that fails (ID not found, already inactive) gets an error note in column B instead, so you know exactly which ones need follow-up
- No rows are skipped silently
What If the Data Is Not Quite Ready
Some rows have email addresses instead of SCIM IDs and you need to handle both
In the Excel 'Departed Staff' worksheet, column A contains either a Roam SCIM user ID or an email address. For each row: if the value looks like an email, look up the SCIM ID first; then deactivate the account and write the result in column B.
You want to log the deactivation timestamp alongside the status
Deactivate every Roam user in the Excel 'Departed Staff' worksheet (SCIM IDs in column A), write 'Deactivated' in column B, and write the current UTC timestamp in column C for each successful deactivation.
The workbook has a mix of active and already-inactive users — skip the ones already off
For each row in the Excel 'Departed Staff' worksheet where column B is empty, check the user's current active status in Roam (SCIM ID in column A). If active is already false, write 'Already Inactive' in column B. If still active, deactivate and write 'Deactivated'.
You need a summary count at the top plus full row-by-row results
Deactivate all Roam users listed by SCIM ID in column A of the Excel 'Departed Staff' worksheet — write the result status in column B. Then write the count of successful deactivations in cell D1 and the count of failures in cell D2.
One prompt gets you the deactivation run and the audit summary simultaneously.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook your HR or IT team uses for offboarding records, then ask it to deactivate the Roam accounts. Link this to the compliance audit spoke to get the before-and-after user roster in the same session.