The Scenario
Your crypto portfolio tracking sheet has 40 token symbols in column A. Every morning you need columns B through E filled with current price, 24h volume, market cap, and holder count — before you review positions for the day.
You did this manually last week. You know exactly how it went.
The bad version:
- Open Token Metrics, search the first symbol, screenshot the numbers, switch to your sheet, type them in
- Repeat for 39 more rows while prices tick against you in real time
- Realize the price you entered in row 4 is already 2% stale by the time you reach row 25
By row 30, you're not updating a live dashboard — you're building a historical artifact of your own typing speed. The data you needed for the morning review is already yesterday's news.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your sheet and talks to Token Metrics for you — pulling data for every row in one pass, not one API call per 20 minutes of your morning.
For each token symbol in column A of my sheet, fetch the current price, 24h volume, and market cap from Token Metrics and write the results into columns B, C, and D
What You Get
- Column B: current price in USD, as a number (not a string)
- Column C: 24h trading volume in USD
- Column D: market cap in USD
- Any symbol Token Metrics doesn't recognize gets an error note in the cell rather than a silent blank
What If the Data Is Not Quite Ready
The symbols in column A are mixed case and some have trailing spaces
Normalize every symbol in column A to uppercase and trim whitespace, then fetch current price, 24h volume, and market cap from Token Metrics and write the results into columns B, C, and D
You want to add a 24h price change percentage column and flag tokens down more than 5%
For each token symbol in column A, fetch the current price, 24h volume, market cap, and 24h price change percentage from Token Metrics — write into columns B through E, and add 'FLAG' in column F for any token where the 24h change is below -5%
Your symbols live across two tabs and you want a combined view
Pull token symbols from both my 'Core' tab column A and my 'Watchlist' tab column A, fetch current price and market cap from Token Metrics for each, and write a combined results table starting at cell A2 of a new 'Live Data' tab
You want a full refresh: clean stale data, fetch new values, and flag anything missing holders data
Clear columns B through E in my sheet, then for each symbol in column A fetch the current price, 24h volume, market cap, and holder count from Token Metrics — write the results, and mark 'N/A — no holder data' in column E for any token where Token Metrics doesn't return a holder count
When the data isn't clean, ask for the cleanup and the pull in the same prompt. SheetXAI handles both steps without requiring you to fix the sheet first and run the query second.
Try It
Get the 7-day free trial of SheetXAI and open any sheet with a column of crypto token symbols, then ask it to bulk-fetch live prices and market data from Token Metrics. See also: Import the Top Tokens by Market Cap and the Token Metrics overview.