The Scenario
You're building a token comparison tool. It needs metadata for 50 specific tokens: token ID, contract address, chain, circulating supply, and creation date. The data lives in Token Metrics. Your sheet has the symbols in column A. You need the rest of the columns filled.
You inherited this project from someone who left the team three weeks ago. The documentation they left is a Notion page that says "pull from Token Metrics" with no further instructions.
The bad version:
- Try to find the Token Metrics API docs, locate the token search endpoint, figure out which fields map to which columns
- Realize the token IDs in Token Metrics are internal numeric IDs, not the symbols you have, and you need to resolve them first
- Spend an afternoon going token by token through the UI to copy contract addresses, then discover two of them changed chains since the last person did this
You're three hours in and you have 14 of 50 tokens. The tool still isn't built.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your symbol list, searches the Token Metrics catalog for each one, and populates the metadata columns in one pass — without you needing to know what the internal token ID is or which API endpoint serves contract addresses.
Search Token Metrics for the tokens listed in my sheet's 'Symbol' column and populate 'Token ID', 'Contract Address', 'Chain', and 'Circulating Supply' columns with the results
What You Get
- Token ID (Token Metrics' internal identifier) written into the designated column for each row
- Contract address and chain populated for tokens where Token Metrics has on-chain data
- Circulating supply as a number, not a formatted string
- Rows where the symbol doesn't resolve to a Token Metrics entry get a clear note rather than a blank
What If the Data Is Not Quite Ready
You also need creation date and total supply for the comparison tool
Search Token Metrics for each token symbol in column A and populate 'Token ID', 'Contract Address', 'Chain', 'Circulating Supply', 'Total Supply', and 'Creation Date' columns — use 'N/A' for any field Token Metrics doesn't return
Some of your symbols are ambiguous and could match multiple tokens — you want the highest market cap match
For each symbol in my sheet's 'Symbol' column, search Token Metrics and populate the token metadata for the result with the highest market cap — write Token ID, Contract Address, Chain, and Circulating Supply into the adjacent columns
You need to cross-reference your existing token IDs against the Token Metrics catalog to catch outdated entries
For each row in my sheet, compare the value in my 'Existing Token ID' column against what Token Metrics returns for that symbol — mark 'MISMATCH' in a new 'ID Check' column for any row where the IDs don't match, and write the correct Token Metrics ID in an adjacent column
Full pipeline: search catalog, populate metadata, flag missing contract addresses, and write a summary
Search Token Metrics for each symbol in column A. Populate Token ID in column B, Contract Address in column C, Chain in column D, and Circulating Supply in column E. In column F, write 'MISSING CONTRACT' for any row where Token Metrics doesn't return a contract address. In cell H1, write a count of how many tokens are missing contract data.
One prompt resolves the symbols, populates the metadata, applies the flags, and writes the summary. Nothing to run in sequence.
Try It
Get the 7-day free trial of SheetXAI and open any sheet with a column of token symbols, then ask it to pull full token metadata from Token Metrics including contract addresses and supply details. See also: Bulk Fetch Live Crypto Prices and the Token Metrics overview.