The Scenario
You're a DeFi analyst at a crypto research firm. Every Monday you send a "breakout watch" list to the team — the top DeFi tokens by 24-hour percent change with meaningful volume behind them. You've been building it by hand: go to CoinMarketCap, filter by the "defi" tag, sort by change, scan the volume column, export, paste into the sheet, reformat.
This week someone on the investment team asked for it on Thursday too. And Friday. Now it's not a Monday ritual — it's a recurring ask that lands whenever the market moves, and you're the one expected to produce it fast.
The bad version:
- Open CoinMarketCap's site, navigate to the categories page, select DeFi, and eyeball the volume column to filter out tokens with thin liquidity — there's no volume floor filter in the UI.
- Export the page to CSV, open it next to your sheet, delete the columns you don't need, reformat the percent-change column from a string to a number, paste the result starting at row 2.
- Two hours later someone asks for the same list sorted differently, and you're back at the export screen.
The time isn't the only problem. This is supposed to be analysis work — identifying patterns, making calls. Running manual exports is not that. And the team has started treating you as the person who maintains the list rather than the one who reads it.
The Easy Way: One Prompt in SheetXAI
SheetXAI lives inside your Google Sheet and talks directly to CoinMarketCap through its built-in integration. You describe the screen you want in plain language and it returns the results into your sheet.
Fetch all CoinMarketCap listings tagged "defi" with 24h volume above 5 million USD, sort by 24h percent change descending, and paste the top 50 results — symbol, name, price, 24h percent change, and market cap — into columns A through E starting at row 2
What You Get
- Rows 2 through 51 fill with the top 50 DeFi tokens by 24h gain, filtered to those with at least $5M daily volume.
- Column A: ticker symbol. Column B: full name. Column C: current USD price. Column D: 24h percent change (numeric). Column E: market cap in USD.
- Tokens below the volume floor are excluded before ranking — you're not sorting the full list and trimming after the fact.
What If the Data Is Not Quite Ready
The volume threshold needs to be dynamic — pulled from a cell, not hardcoded
Fetch all CoinMarketCap listings tagged "defi" with 24h volume above the value in cell B1 of this sheet, sort by 24h percent change descending, and paste the top 50 — symbol, name, price, 24h change, market cap — into columns A through E starting at row 2
I want to exclude stablecoins from the results
Fetch all CoinMarketCap listings tagged "defi" with 24h volume above 5 million USD, exclude any token also tagged as "stablecoin," sort by 24h percent change descending, and paste the top 50 results into columns A through E starting at row 2
I also want the bottom 25 (biggest losers) in a second tab
Fetch all CoinMarketCap listings tagged "defi" with 24h volume above 5 million USD; paste the top 25 gainers by 24h percent change into the "Gainers" tab starting at A2 and the 25 biggest losers into the "Losers" tab starting at A2, using the columns symbol, name, price, 24h change, market cap in both tabs
Run the full screen, flag anomalies, and write a one-line summary at the top
Fetch all CoinMarketCap listings tagged "defi" with 24h volume above 5 million USD, sort by 24h percent change descending, paste the top 50 into columns A through E starting at row 3, flag any token where 24h change exceeds 30% with a note in column F, and write a one-sentence market summary in cell A1 describing what the screen shows
The screen, the flags, and the summary land in one pass — ready to forward to the investment team without a second look.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet where you're tracking DeFi markets, then describe the screen you want and let it pull from CoinMarketCap. Also worth reading: Bulk Pull Live Crypto Prices Into a Google Sheet and the CoinMarketCap integration hub.