The Scenario
You operate validators on behalf of 10 investors and produce a monthly rewards report. One of your investors sent a message this morning asking why last month's report showed lower execution rewards than they expected based on public explorer data. You have no fast answer because the report was built by hand from CSV exports and you're not entirely confident the gwei conversions were consistent across all 80 validators.
The bad version:
- Export reward data from beaconcha.in for validator 1, import the CSV into Excel, extract the 1d, 7d, 31d consensus and execution columns
- Repeat for all 80 validators, being careful to keep consensus and execution rewards in separate columns as you paste
- Discover midway that some validators have null execution rewards for certain time windows and decide on the fly whether to use 0 or leave blank, then rebuild the affected rows
Investor trust is a long-term asset. Sending a corrected report three days after the question is fine once. Sending one every month is a different problem.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your validator indices from column A, calls the Beaconchain reward summary endpoint for each one, and writes the full time-window breakdown into the workbook with consistent column structure across all 80 validators.
For each validator index in column A of my Excel table, pull Beaconchain reward summaries and fill columns B through G with: consensus 1d, 7d, 31d rewards and execution 1d, 7d, 31d rewards in gwei
What You Get
- Six reward columns per validator: consensus 1d, 7d, 31d and execution 1d, 7d, 31d — all in gwei
- A total rewards column summing consensus and execution across each window
- Null execution reward entries written as 0 rather than blank, so your SUM formulas stay intact
- All 80 validators in a single pass with consistent column order throughout
What If the Data Is Not Quite Ready
You need the rewards converted from gwei to ETH for the investor report format
Fetch consensus and execution reward summaries from Beaconchain for validators in column A of my Excel table — convert all values from gwei to ETH before writing — six reward columns plus a total, one row per validator
The report needs validator indices grouped by investor, which are tagged in column B
Fetch Beaconchain reward summaries for validators in column A of my Excel table — write 1d, 7d, and 31d consensus and execution rewards to columns C through H — then sort the completed table by the investor tag in column B so all rows per investor are grouped together
You want a subtotal row per investor group added automatically
Pull Beaconchain reward summaries for validators in column A of my Excel table — write rewards to columns C through H — sort by investor tag in column B — then insert a subtotal row after each investor group showing the sum of each reward column for that investor
Build the full investor report in one shot: pull data, convert units, subtotal by investor, and flag any validator with zero execution rewards for 31d
Fetch Beaconchain 1d, 7d, 31d consensus and execution rewards for validators in column A of my Excel table — convert to ETH — sort by investor tag in column B — insert subtotal rows per investor group — then add a column I flagging rows where execution reward 31d is zero as INVESTIGATE
SheetXAI resolves the entire pipeline in one instruction so the report is investor-ready without intermediate manual steps.
Try It
Get the 7-day free trial of SheetXAI and open your rewards tracking workbook with validator indices in column A and investor tags in column B, then ask SheetXAI to pull the full reward summary. The spoke on income breakdowns covers the tax-filing angle, and the hub page documents all Beaconchain integrations available in SheetXAI.