The Scenario
It's Sunday afternoon and you're preparing a weekly market review for a group of investors. You need a snapshot of the top 50 tokens by market cap — name, symbol, current price, and market cap in one clean table — to anchor the presentation.
You've been to the Token Metrics leaderboard. The data is there. Getting it into Google Sheets in a structured, presentation-ready format is the part that takes longer than it should.
The bad version:
- Export whatever Token Metrics makes available, open the CSV, discover it has 30 columns you don't need
- Strip the irrelevant columns, reformat the header row, fix the number formatting so market cap reads as a number and not scientific notation
- Realize the export only goes to rank 25 and you need 50, so you pull a second export and stack them
You're 45 minutes into prep work that was supposed to take five. The review content hasn't been written yet.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet, understands what you're trying to build, and pulls the leaderboard data from Token Metrics directly — structured the way you asked, not the way the export defaulted to.
Fetch the top 50 tokens by market cap from Token Metrics and write each one into my sheet with columns for rank, name, symbol, price, and market cap
What You Get
- 50 rows starting at row 2, with rank in column A, token name in column B, symbol in column C, price in column D, and market cap in column E
- Headers written automatically in row 1
- Numbers formatted as numbers, not text — ready for sorting and conditional formatting
What If the Data Is Not Quite Ready
You want the top 100, not 50, and you want to include 24h volume
Fetch the top 100 tokens by market cap from Token Metrics and write each one into my sheet with columns for rank, name, symbol, price, market cap, and 24h volume — put headers in row 1
You want to filter out stablecoins before writing to the sheet
Fetch the top 100 tokens by market cap from Token Metrics, remove any token where the name or symbol contains 'USD', 'USDT', 'USDC', 'DAI', 'BUSD', or 'TUSD', then write the remaining tokens to my sheet with rank, name, symbol, price, and market cap columns
The sheet already has last week's data and you want to overwrite it cleanly
Clear the data in columns A through E starting from row 2, then fetch the current top 50 tokens by market cap from Token Metrics and write rank, name, symbol, price, and market cap into those columns with headers in row 1
You want a full pipeline: fetch the top 50, flag any token down more than 10% over 24h, and sort by market cap descending
Fetch the top 50 tokens by market cap from Token Metrics with rank, name, symbol, price, 24h change, and market cap — write to my sheet, add a 'WATCH' flag in column G for any token where 24h change is below -10%, then sort the table by market cap descending
One prompt to pull, flag, and sort. The analysis layer and the data fetch don't need to be separate steps.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, then ask it to snapshot the current top 50 tokens from Token Metrics. See also: Bulk Fetch Live Crypto Prices and the Token Metrics overview.