The Scenario
You're preparing a governance report for a DAO treasury and the opening section requires a token holdings audit across 25 Ethereum addresses that the treasury controls. A committee member asked for it by end of week. The addresses are in column A. You need token symbol, contract address, and balance for every ERC-20 held across all 25 addresses — in a flat table that a non-technical committee member can read.
The bad version:
- Open beaconcha.in or a block explorer, search for address 1, open the token holdings tab, copy the ERC-20 table, paste into the report sheet
- Repeat for all 25 addresses, trying to keep each address's holdings grouped correctly in the paste
- Discover that address 7 holds 14 different tokens and the paste expanded the rows in a way that pushed all subsequent data out of alignment
A governance report going to a committee is not something you want to rebuild at 9 PM because the paste structure broke on address 7.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the 25 Ethereum addresses from column A, calls Beaconchain's token balance endpoint for each one, and writes every ERC-20 holding into a flat table — one token per row — without any manual alignment or grouping on your part.
For each Ethereum address in column A of my sheet, fetch ERC-20 token balances from Beaconchain and write token symbol, contract address, and balance into new rows below each address — one token per row — and label each row with the source address in column A
What You Get
- A flat table with one row per token per address
- Four columns: Ethereum address, token symbol, contract address, and token balance
- All 25 addresses processed in sequence, with each address's token rows written contiguously
- Any address with no ERC-20 holdings gets a single row with a note rather than being silently skipped
What If the Data Is Not Quite Ready
You need the output as a completely flat table with no address-grouping, just one row per address-token pair
Fetch ERC-20 token balances for all addresses in column A via Beaconchain and write a flat table to the Token Holdings tab: address, token symbol, contract address, and balance — one row per token, no grouping, no intermediate label rows
Some addresses have dozens of tokens and you only want tokens with a balance above a threshold
Pull ERC-20 token balances for addresses in column A via Beaconchain — filter out any holdings where balance is zero or below 0.001 — write address, symbol, contract, and balance to the Token Holdings tab as a flat table
The committee wants a summary view: one row per token symbol showing total balance across all treasury addresses
Fetch ERC-20 balances for all addresses in column A — write full detail to the Token Holdings tab — then create a Summary tab with one row per unique token symbol showing total balance summed across all treasury addresses, sorted by total balance descending
Build the complete governance report package: full holdings detail, filtered summary, and a flag for any token held by more than 10 addresses
Pull ERC-20 balances for all 25 addresses in column A — write full detail to Token Holdings tab — create a Summary tab with total balance per token symbol — add a column on the Summary tab showing how many treasury addresses hold that token — flag any token held by 10 or more addresses as WIDELY HELD
A complete audit package from a single instruction, so the report is governance-ready before the committee meeting.
Try It
Get the 7-day free trial of SheetXAI and open your DAO treasury tracking sheet with the 25 Ethereum addresses in column A, then ask SheetXAI to pull the full ERC-20 holdings audit. The spoke on bulk ENS resolution is useful if any of those addresses are ENS names, and the hub page documents all Beaconchain integrations available in SheetXAI.