The Scenario
End of Q1. Twenty-three people left the company over the past three months. HR has compiled the offboarding records into a Google Sheet — 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 sheet 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 Google Sheet. It reads your offboarding data and sends the SCIM deactivation calls to Roam for every row — you don't write a single API call.
Deactivate every Roam user whose SCIM ID is listed in column A of the 'Offboarding' sheet — set active=false for each and write 'Deactivated' into 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 'Offboarding' sheet, 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 Roam SCIM ID first; then deactivate the user and write the result in column B.
You want to log the deactivation timestamp alongside the status
Deactivate every Roam user in the 'Offboarding' sheet (SCIM IDs in column A), write 'Deactivated' in column B, and write the current UTC timestamp in column C for each successful deactivation.
The sheet has a mix of active and already-inactive users — skip the ones already off
For each row in the 'Offboarding' sheet 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 'Offboarding' sheet — write the result status in column B for each row. 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 Google Sheet 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.