The Scenario
You have a client review in two hours. Your crypto portfolio tracker in Google Sheets has 15 pairs in column A — BTCUSD, ETHUSD, SOLUSD, and a dozen others. The price, 24-hour change, volume, and market cap columns are all empty because you haven't updated them since last week. Your client is going to ask about performance. You need current numbers, not last Tuesday's numbers.
The bad version:
- Open Finage's crypto snapshot endpoint, call each pair individually, copy the response, paste the values into the correct row.
- Realize the 24-hour change is returned as a decimal and your sheet is formatted as a percentage, so the numbers display wrong until you reformat the column.
- Finish the data entry with 20 minutes to spare, then spend that time checking that nothing is misaligned before the call starts.
You were supposed to spend that time reviewing the portfolio, not populating it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet and connects to Finage directly. It reads the crypto pairs in your sheet, calls the Finage snapshot endpoint, and writes price, 24-hour change, volume, and market cap into the columns you specify — formatted, aligned, and ready.
For each crypto pair in column A of my Google Sheet (e.g., BTCUSD, ETHUSD), fetch the detailed Finage crypto snapshot and write current price, 24h change %, volume, and market cap into columns B through E
What You Get
- Column B: current trade price
- Column C: 24-hour change expressed as a percentage
- Column D: 24-hour volume
- Column E: market cap
- Pairs that Finage cannot resolve get an empty row with a note so nothing silently drops
What If the Data Is Not Quite Ready
Some pairs in your list use a different quote currency — not USD
For each crypto pair in column A (including pairs quoted in EUR or BTC), fetch the Finage snapshot for the correct quote currency and write current price, 24h change %, volume, and market cap into columns B through E
You also want the 7-day high and low for each pair
For each crypto pair in column A, fetch the current snapshot from Finage including current price, 24h change, 7-day high, 7-day low, volume, and market cap, and write each into columns B through G
Your portfolio spans two tabs — DeFi tokens on one sheet, large-cap on another
Read all crypto pairs from column A on both the Large-Cap Crypto and DeFi Tokens sheets, fetch the current Finage snapshot for each, and write price, 24h change %, volume, and market cap into columns B through E on each respective sheet
You want to refresh prices, flag any pair that moved more than 10% in 24 hours, and write a summary note in one pass
Clear columns B through E on my Crypto Portfolio sheet, fetch fresh snapshots from Finage for every pair in column A, write current price, 24h change %, volume, and market cap, and in column F flag any pair where the absolute 24h change exceeds 10%
One prompt handles the data refresh, the conditional logic, and the alert column in a single operation.
Try It
Open a Google Sheet with your crypto pairs in column A. Get the 7-day free trial of SheetXAI and ask it to populate the current Finage snapshot data into the adjacent columns before your next client call. You can also ask it to add historical bars for those same pairs, or head to the Finage hub to see everything the integration covers.