The Scenario
You are a fintech product manager and quarterly audit season has arrived. Your engineering team keeps a users table in your application database. MX Technologies keeps its own user records. The question your compliance lead emailed this morning: do they match?
You have a Google Sheet open. Column A is supposed to list every MX user GUID. It is blank. Getting that list into your sheet — all 800 users with their GUIDs, partner IDs, email addresses, and disabled status — is step one before any reconciliation work can start.
The bad version:
- Call the MX list-users endpoint, which paginates at 100 records per page, meaning 8 separate API calls to get all 800 users.
- Copy the response from each page into a text editor, manually extract the GUID, ID, email, and disabled fields from the JSON, and paste them into your sheet.
- Discover partway through that 17 accounts have email addresses that are empty strings rather than null, which breaks the formula you were using to count disabled accounts.
This is supposed to be a data pull, not a half-day project.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that runs inside your Google Sheet. It connects to MX Technologies, pages through the full user list automatically, and writes every record to your sheet in one pass.
List all users in MX Platform and write each user's GUID, ID, email, and disabled status to this sheet starting at row 2.
What You Get
- One row per MX user, starting at row 2.
- Column A: user GUID.
- Column B: partner-specific user ID.
- Column C: email address (or blank if not set).
- Column D: disabled status (true/false as returned by MX).
- All 800 rows written in a single operation — no page-by-page copying.
What If the Data Is Not Quite Ready
You need to flag disabled accounts separately
List all users in MX Platform and write user GUID, ID, email, and disabled status to columns A through D — in column E write "Disabled" for any row where disabled is true, and "Active" for all others.
Some users have empty string emails instead of null
List all users in MX Platform and write GUID, ID, and email to columns A, B, C — in column D write "Missing email" if the email field is empty or blank, and "Valid" otherwise, so I can see which records need correction.
You need to reconcile this list against your internal database roster
List all MX platform users and write GUID and email to columns A and B — then in column C check whether each GUID appears in the Internal Users tab column A and write "Match" or "Not found" to flag any discrepancy.
You want to pull the full user list, flag disabled accounts, cross-reference against your DB, and export a summary in one shot
List all MX platform users and write GUID, email, and disabled status to columns A, B, C in Sheet1 — flag any disabled user in column D, then in column E check whether the GUID exists in the Internal DB tab column A and write "In DB" or "Missing" — finally write a summary to Sheet2 showing total users, total disabled, and total missing from internal DB.
Combining the data pull, the flag logic, and the reconciliation into one prompt saves you from having to re-run each step as a separate SheetXAI call.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet you're using for user audits, then ask it to pull the full MX user roster and flag anything that needs attention. For auditing the transaction categorization rules applied to those users, see the transaction rules configuration article.