The Scenario
You administer a staking fund with 40 validators and the fund accountant sends the same request every month: a withdrawal reconciliation. They need epoch, slot, amount, and recipient address for every withdrawal made during the month. Last month you pulled it by hand and it took three hours. The accountant found two rows where the amounts didn't match the on-chain record because you'd accidentally transposed two gwei values. The fund's audit is next quarter.
The bad version:
- Open beaconcha.in, search for validator 1, navigate to the withdrawals tab, copy the records for the relevant date range, paste into the sheet
- Repeat for all 40 validators, keeping a checklist of which ones you've done because the browser doesn't tell you
- Discover that two validators had multiple withdrawals in the same epoch and you have to go back and check whether they both got written as separate rows or collapsed into one
An audit doesn't ask "did you try your best?" It asks "does the number match?"
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your 40 validator indices from column A, pulls withdrawal records from Beaconchain for each one, and writes the complete reconciliation table in a flat format the accountant can work with directly.
Fetch Beaconchain withdrawal history for all validator indices in column A of my sheet and write epoch, slot, amount in gwei, and withdrawal address to new rows — one withdrawal per row — starting in the Withdrawals tab at row 2
What You Get
- One row per withdrawal event across all 40 validators
- Four columns: epoch, slot, withdrawal amount in gwei, and recipient address
- Validator index in a fifth column for attribution
- Multiple withdrawals in the same epoch written as separate rows, not combined
What If the Data Is Not Quite Ready
The accountant needs amounts in ETH, not gwei
Pull Beaconchain withdrawal history for all validators in column A — write epoch, slot, amount converted from gwei to ETH, and recipient address to the Withdrawals tab — one row per withdrawal
You need to filter to only withdrawals that occurred in April 2025
Fetch Beaconchain withdrawal history for validators in column A — filter to withdrawals in epochs corresponding to April 2025 — write epoch, slot, amount in ETH, and recipient address to the Withdrawals tab
The accountant also needs a per-validator subtotal at the end of each validator's rows
Pull Beaconchain withdrawal history for validators in column A — write epoch, slot, amount in ETH, and recipient address one row per withdrawal grouped by validator — insert a subtotal row after each validator's withdrawals showing total amount and count
Build the complete audit-ready package: all withdrawals, per-validator subtotals, and a summary tab
Fetch Beaconchain withdrawal history for all validators in column A — write detailed records to the Withdrawals tab with subtotal rows per validator — create a separate Summary tab showing each validator's total withdrawal amount in ETH and withdrawal count for the period
All three views from a single instruction, so the accountant gets the package rather than a starting dataset.
Try It
Get the 7-day free trial of SheetXAI and open the fund's reconciliation sheet with your 40 validator indices in column A, then ask SheetXAI to pull the complete withdrawal history. The spoke on reward summaries is a useful companion for the investor report, and the hub page documents all Beaconchain workflows available in SheetXAI.