The Scenario
You're a DeFi analytics researcher building a token reference database. Your reports pull contract addresses constantly — VLOOKUP against a master list to find the right ERC-20 for a given symbol on a given network. The problem is that master list lives in your head and a dozen browser bookmarks, not in a sheet. A new analyst joined the team last week and has already asked you for contract addresses four times. You need the full Poof supported token list in a Google Sheet so anyone on the team can use it.
The bad version:
- Open the Poof documentation or API explorer, manually copy contract addresses and token names for Ethereum one by one.
- Repeat for Polygon. Repeat for Avalanche.
- Realize mid-way through that the formatting is inconsistent across networks and you need to normalize it before the sheet is usable as a VLOOKUP reference.
- Finish three hours later with a list that's already slightly out of date because new tokens were added while you were doing this.
A token reference database built by hand is a database that's wrong the moment it's finished.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It understands your request, connects to Poof through its built-in integration, and pulls the complete supported token list across all networks into a structured sheet — with the columns you need for VLOOKUP queries.
Fetch all supported ERC-20 smart contracts from Poof across all networks and import them into a sheet called 'Token Contracts' with columns for token name, symbol, contract address, and network.
What You Get
- A 'Token Contracts' tab created (or cleared and repopulated) with one row per supported token.
- Columns for token name, symbol, contract address, and network — ready for VLOOKUP or XLOOKUP queries.
- Tokens from Ethereum, Polygon, Avalanche, and any other supported networks all in one place.
- If Poof returns a partial list for a network, that network's rows are flagged so you know coverage is incomplete.
What If the Data Is Not Quite Ready
You need the tokens split into separate tabs by network for cleaner report referencing
One giant tab is hard to VLOOKUP against when your reports reference network-specific addresses.
Pull the complete list of supported Poof tokens into my workbook, then split them into three separate tabs — one each for Ethereum, Polygon, and Avalanche — with columns for token name, symbol, and contract address in each tab.
Some token symbols appear on multiple networks and you need a dedup view
The same symbol like USDC appears on Ethereum, Polygon, and Avalanche with different contract addresses, which breaks a naive VLOOKUP.
Fetch all supported tokens from Poof and import them into a 'Token Contracts' tab. Then create a second tab called 'Symbol Index' that lists each unique symbol once, with one column per network showing the contract address for that network (or blank if the token isn't on that network).
You need to cross-reference against your existing position data
Your 'Portfolio' tab has token symbols in column A and you want a VLOOKUP formula populated that pulls the contract address from the token reference sheet.
Fetch all supported Poof tokens and import them into a 'Token Contracts' tab with columns for symbol, contract address, and network. Then in my 'Portfolio' tab, add a VLOOKUP formula in column E that pulls the Ethereum contract address from 'Token Contracts' for each symbol in column A.
The full import-plus-validate kill chain
You want the full token list imported, duplicates across networks normalized into a single symbol index, and any symbols in your 'Portfolio' tab that aren't in the Poof list flagged.
Fetch all supported Poof tokens across all networks and import them into a 'Token Contracts' tab with columns for name, symbol, address, and network. Create a 'Symbol Index' tab that deduplicates by symbol with one column per network. Then check every symbol in column A of my 'Portfolio' tab against the Symbol Index and write 'Not in Poof' into column F for any symbol that doesn't appear in the index.
Running the import, the dedup, and the validation in one prompt gives you a complete reference database with gap analysis in one step.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet where you need a structured token reference table — whether you want a single flat list or network-split tabs with a dedup index — and ask it to pull the Poof supported contract list in one pass. You can also see how SheetXAI handles refreshing live crypto prices in a portfolio tracker or return to the full Poof integration overview.