The Scenario
It's end-of-quarter reconciliation and your crypto treasury report is due to the CFO by noon. You have 20 company wallet addresses in your 'Wallets' sheet — address in column A, network in column B, last known balance in column C from three weeks ago, and the current balance column D is blank. The CFO wants current balances grouped by network and flagged empties before approving the quarter-end report.
The bad version:
- Copy the first address from column A, open a block explorer for the right network, paste the address, read the balance, flip back to the sheet, type the number into D2.
- Repeat for all 20 addresses across three different networks, switching block explorers between rows when the network changes.
- Finish row 20 and realize you weren't consistent about units — some balances are in ETH, some in Wei — and now you need to normalize them before the CFO can read the report.
Reconciling 20 wallets across multiple networks is a morning of context-switching that produces a report the CFO needed two hours ago.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the 'Wallets' tab, understands the addresses and networks, and through the Poof integration it fetches the current balance for each row, writes it into column D, and flags the empty ones — without you touching a block explorer.
For each wallet address in column A of my 'Wallets' sheet, use Poof to check the current balance and write the result into column D, then add a summary row at the bottom that sums balances by network using the network names in column B.
What You Get
- Column D filled with the current balance for each wallet address.
- A summary row at the bottom that totals balances grouped by the network values in column B.
- Any address that returns a zero balance flagged in column E with the word 'Empty'.
- Any address that Poof cannot resolve flagged in column D with an error note.
What If the Data Is Not Quite Ready
Some addresses have formatting issues — extra spaces or mixed case
A few rows in column A have trailing spaces or inconsistent capitalization that could cause the balance lookup to fail.
For each row in my 'Wallets' sheet, normalize the wallet address in column A by trimming whitespace and converting to lowercase, then use Poof to fetch the current balance and write it into column D. Flag any address that still fails after normalization with 'Invalid address' in column D.
Balances come back in token units but you need USD equivalent
You want column D in USD, not raw token amounts, so the CFO can read the totals directly.
For each wallet in column A of my 'Wallets' sheet, fetch the current balance from Poof and convert it to USD using the current token price. Write the USD equivalent into column D and the raw token balance into column E. Sum the USD totals by network in a summary section below the data.
Wallets are split across two tabs — main treasury and a reserve tab
Your workbook has a 'Main Treasury' tab and a 'Reserve Wallets' tab with the same column layout.
For every wallet address in both my 'Main Treasury' and 'Reserve Wallets' sheets, fetch the current balance via Poof and write it into column D of each respective tab. Flag zero-balance wallets with 'Empty' in column E of each tab.
The full reconciliation-plus-variance kill chain
You have last quarter's balances in column C, and the CFO wants to see both current balances and the change, with any wallet that dropped more than 50% since last quarter highlighted.
For each wallet in column A of my 'Wallets' sheet, fetch the current balance from Poof and write it into column D. Calculate the change from the last known balance in column C and write the percentage change into column E. Flag any wallet where the balance dropped more than 50% with 'Variance alert' in column F, and flag zero-balance wallets with 'Empty' in column F as well. Add a network-level summary at the bottom.
Running the fetch, the comparison, and the flagging in one prompt gives the CFO a complete reconciliation without a separate analysis pass.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a list of blockchain wallet addresses — even if they span multiple networks or need a variance comparison against last quarter — and ask it to fetch balances and surface the empties in one pass. You can also see how SheetXAI handles looking up gas prices before batch payouts or return to the full Poof integration overview.