The Scenario
Your client is a personal finance coach who works with a dozen clients simultaneously. One of them — a freelancer who connected six bank and credit card accounts through MX — sent a message at 8 AM asking for a category breakdown of their spending over the last 90 days. You have the client's MX user GUID in your sheet. You do not have the transactions.
The bad version:
- Authenticate to the MX API, call the list-members endpoint for the user, then loop through each member to call list-transactions with a date filter — three separate endpoints before you even have data.
- Page through transaction results manually, copying records into a CSV because the response cap means you get 250 at a time and this client has over 400 transactions across their accounts.
- Import the CSV into your sheet, fix the date format because MX returns ISO 8601 and Excel imported it as text, then build the category pivot by hand.
The client's budget review call is at 10 AM. What you just described takes longer than 90 minutes even if nothing goes wrong.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that runs inside your Google Sheet. It reads the data already in your sheet, connects to MX Technologies, and writes results back to your columns — pagination, member scoping, and date filtering handled automatically.
Fetch all transactions for MX user USR-abc123 from the last 90 days and write each transaction's date, description, amount, category, and account name to Sheet1 starting at row 2.
What You Get
- Every transaction in its own row, starting at row 2.
- Column A: transaction date in readable format (YYYY-MM-DD).
- Column B: transaction description as returned by MX.
- Column C: amount (negative for debits, positive for credits).
- Column D: MX category label (e.g., "Food and Dining", "Auto and Transport").
- Column E: account name associated with the transaction.
- All pages fetched automatically — no 250-row cap.
What If the Data Is Not Quite Ready
The category labels from MX don't match the ones your client uses
Fetch all transactions for MX user USR-abc123 from the last 90 days and write date, description, amount, and MX category to columns A through D — then in column E remap the category using this mapping: "Food and Dining" to "Dining", "Auto and Transport" to "Transport", "Bills and Utilities" to "Bills".
Some transactions have no category assigned
Fetch all transactions for MX user USR-abc123 from the last 90 days and write date, description, amount, and category to Sheet1 — for any transaction where category is blank or uncategorized, write "Review" to column E.
You need transactions from multiple members summarized together with a running total
Fetch all transactions for MX user USR-abc123 from the last 90 days across all their connected members and write date, account name, description, amount, and category to Sheet1, then in a Summary tab write total spend by category sorted highest to lowest.
You want to clean up duplicate entries and see net spend in one shot
Fetch all transactions for MX user USR-abc123 from the last 90 days, remove any duplicate transaction GUIDs, group by category to calculate net spend per category, and write the final category summary to Sheet2 — flag any category over 500 dollars in column C.
The underlying approach is the same whether you need raw data or a finished summary: write the cleanup and the analysis into one prompt rather than doing them as separate steps.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with MX user GUIDs, then ask SheetXAI to fetch the last 90 days of transactions and build a category breakdown. For pulling account balances across all a user's connected accounts, see the net worth snapshot article.