The Scenario
You are a financial advisor with a client annual review coming up in four hours. The client has eight accounts spread across four different financial institutions, all connected through MX. Your Google Sheet has the client's MX user GUID in cell A2. It does not have any account data in it yet.
The bad version:
- Call the MX list-members endpoint to get the four member connections, write down each member GUID, then call list-accounts for each member separately — four API calls just to get a flat list of accounts.
- Manually sort the results into asset accounts (checking, savings, investments) and liability accounts (credit cards, loans) because MX does not separate them automatically in a way that maps to your sheet columns.
- Calculate net worth by hand in the spreadsheet using a formula that will break the moment someone adds or removes an account from the MX connection.
The review packet is due to your admin for printing before 3 PM, and you haven't started the rest of it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that runs inside your Google Sheet. It reads your sheet, connects to MX Technologies, and writes the full account list back into your columns — no member-by-member iteration on your end.
List all accounts for MX user USR-abc123 and write each account's name, institution, type, and current balance to Sheet1, then calculate total assets minus total liabilities in a summary cell in column F row 1.
What You Get
- One row per account across all member connections for that user.
- Column A: account name as held at the institution.
- Column B: institution name from the MX record.
- Column C: account type (checking, savings, credit card, investment, loan).
- Column D: current balance from the most recent MX sync.
- Column F, row 1: net worth calculated as sum of asset balances minus sum of liability balances.
What If the Data Is Not Quite Ready
Some accounts have stale balances from more than 48 hours ago
List all accounts for MX user USR-abc123 and write account name, institution, type, balance, and last-updated timestamp to columns A through E — flag any account where the balance was last updated more than 48 hours ago by writing "Stale" to column F.
You need accounts grouped by institution with subtotals
List all accounts for MX user USR-abc123 and write them to Sheet1 grouped by institution — include account name, type, and balance per row, then for each institution group write a subtotal of balances in a bold summary row.
You need to join the account list against a reference tab of expected accounts
List all accounts for MX user USR-abc123 and write account name, type, and balance to columns A, B, C in Sheet1 — then in column D check whether each account name appears in the Expected Accounts tab in column A and write "Found" or "Missing" accordingly.
You want a complete net worth snapshot with categorized breakdown and variance from last month
Fetch all accounts for MX user USR-abc123, write account name, institution, type, and current balance to Sheet1, then in a Summary tab show total assets, total liabilities, and net worth — in column E compare the current balance against last month's balance in the Historical tab using account name as the key and show the change.
Rather than treating the fetch and the comparison as separate tasks, put both into one prompt and let SheetXAI resolve the join.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet containing a client's MX user GUID, then ask it to pull all accounts and calculate net worth. For analyzing spending against budget targets, see the budget vs. actual spend article.