The Scenario
You're a compliance analyst at a crypto exchange. The sanctions screening team needs a third-party data pull: all ERC-20 transfers over $10,000 for 30 wallet addresses across Ethereum and Polygon in the last 30 days. The results need to land in an Excel workbook in a specific format — sender, receiver, token symbol, amount USD, and transaction hash — so the legal team can cross-reference against their watchlists.
This is not a recurring workflow yet. It's a one-off review request that arrived this morning. The deadline is end of day.
The bad version:
- Write a Bitquery V2 GraphQL query for Ethereum transfers, realize the Polygon query uses a different chain parameter and needs a separate call
- Execute both queries via the IDE, export two separate JSON files, try to import both into Excel using Power Query, discover the timestamp format differs between chains and the merge step fails
- Realize 4 of the 30 wallet addresses are checksummed differently than what Bitquery expects, update the query, re-run those 4 separately, paste the results into the right rows
Thirty addresses times two chains is 60 query runs if done naively. You have other cases open. The legal team's clock is running.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the wallet addresses from your workbook, runs the multi-chain Bitquery V2 queries, and writes a flat transfer history into your workbook — normalized timestamps, both chains, no manual merging.
Open the SheetXAI sidebar and paste this prompt:
For each wallet address in column A, query Bitquery V2 for all ERC-20 transfers above $10,000 on Ethereum in the last 30 days. Write sender, receiver, token symbol, amount USD, and tx hash into columns B through F.
What You Get
- Column B: sender address
- Column C: receiver address
- Column D: token symbol (USDT, USDC, WETH, etc.)
- Column E: transfer amount in USD, numeric
- Column F: transaction hash
- Each qualifying transfer is its own row — multiple transfers per wallet address are all included
- Wallet addresses with no qualifying transfers in the window are noted rather than silently omitted
What If the Data Is Not Quite Ready
You need Polygon transfers as well, not just Ethereum
For each wallet in column A, query Bitquery V2 for all ERC-20 transfers above $10,000 on both Ethereum and Polygon in the last 30 days. Add a "chain" column. Write sender, receiver, token symbol, amount USD, tx hash, and chain into columns B–G.
The wallet addresses have inconsistent checksum formatting
For each address in column A, normalize to lowercase checksummed format before querying Bitquery V2. Pull all ERC-20 transfers above $10,000 on Ethereum in the last 30 days and write sender, receiver, token symbol, amount USD, and tx hash into columns B–F.
You need to cross-reference results against a sanctions list in a second worksheet
Query Bitquery V2 for all ERC-20 transfers above $10,000 on Ethereum in the last 30 days for each wallet in column A. Cross-reference sender and receiver addresses against the watchlist in worksheet "Sanctions" column A. Flag any row where sender or receiver appears on the watchlist in column G. Write all transfers into columns B–F.
You need to pull the data, flag high-risk patterns, de-duplicate, and sort — all in one go
For each wallet in column A, query Bitquery V2 for ERC-20 transfers above $10,000 on Ethereum and Polygon in the last 30 days. Remove duplicate transaction hashes. Flag transfers where the same wallet appears as both sender and receiver of transfers within the same block in a "self-loop" column. Sort by amount USD descending. Write sender, receiver, token, amount, tx hash, chain, and flag to columns B–H.
The pattern: the compliance analysis — deduplication, cross-referencing, flagging — and the data pull happen in a single instruction.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook with your wallet addresses in column A, then ask SheetXAI to pull all large ERC-20 transfers from Bitquery V2 for your screening review. For related tasks, see how to pull DEX trade data for a token list or explore the full Bitquery integration overview.