The Scenario
It's 7:45 AM and you manage a crypto portfolio tracker for a small family office. Column A of your "Watchlist" sheet has 50 token symbols — BTC, ETH, SOL, and 47 others. Columns B through D are supposed to hold live price, market cap, and 24-hour change. They're currently showing data from three days ago, because the last person who refreshed it manually got halfway through and gave up.
The bad version:
- Open CoinMarketCap's website, search each symbol one at a time, copy the price, switch back to the sheet, find the right row, paste it.
- Download the full listing CSV, open it next to the sheet, run a VLOOKUP to match symbols, drag the formula down 50 rows, fix the three tokens where the symbol casing doesn't match.
- Notice that columns B and C are misaligned for stablecoins because the CSV includes them but your watchlist doesn't. Spend twenty minutes cleaning up the rows that landed wrong.
The fund's morning brief goes to the partners at 8:30 AM. Running through this manually is not an option you have — not because of the clock, but because you've already done it eleven times this month and your actual job is analysis, not data entry.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives directly inside your Google Sheet. It reads the spreadsheet, understands the structure, and through its CoinMarketCap integration pulls live market data and writes it back into the right cells. No CSV exports. No formula acrobatics.
For each token symbol in column A of the "Watchlist" tab, fetch the current USD price, market cap, and 24h percent change from CoinMarketCap and fill in columns B, C, and D
What You Get
- Column B fills with the current USD price for each token, formatted as a number.
- Column C fills with market cap in USD — full integer, no rounding unless your cell format is already set to truncate.
- Column D fills with the 24-hour percent change — positive values for gainers, negative for losers.
- Any symbol that CoinMarketCap can't resolve returns a clear error note in the cell rather than a silent blank.
What If the Data Is Not Quite Ready
The symbols in column A use different casing than CoinMarketCap expects
For each symbol in column A of "Watchlist," normalize the casing to uppercase, then fetch the current USD price, market cap, and 24h percent change from CoinMarketCap and write them into columns B, C, and D
Some rows have token names instead of ticker symbols
For each cell in column A of "Watchlist" that contains a full token name rather than a ticker symbol, look up the correct CoinMarketCap ticker, then fetch the USD price, market cap, and 24h change and fill columns B, C, and D accordingly
The watchlist spans two tabs and I need both refreshed
For each symbol in column A of the "Watchlist-Core" tab and the "Watchlist-Alt" tab, fetch current USD price, market cap, and 24h percent change from CoinMarketCap and write the results into columns B, C, and D of each respective tab
The data's stale, there are duplicates, and I need a summary alongside it
Remove any duplicate symbols in column A of "Watchlist," then fetch current USD price, market cap, and 24h percent change from CoinMarketCap for each unique symbol, write the results into columns B through D, and add a summary row at the bottom of the sheet showing total portfolio market cap and the three top gainers by 24h change
Cleanup and data pull in one instruction — the sheet comes back ready for the morning brief.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet with your token watchlist, then ask it to refresh the market data from CoinMarketCap. You might also find these useful: Build a DeFi Token Screener in a Google Sheet and the CoinMarketCap integration overview.