CoinGecko for Sheets brings the official CoinGecko API directly into Google Sheets™, giving you access to the same cryptocurrency market data trusted by over 100 million monthly users worldwide.

Built by the world's largest independent crypto data aggregator, the CoinGecko for Sheets add-on offers direct access to trusted market data via a single formula. It provides comprehensive coverage of 20M+ tokens across 250+ networks, strict privacy (only accessing your current spreadsheet), real-time updates for long-tail assets and new DEX listings, and official support from the CoinGecko team.

⚡️ Core Features:
📈 Live Price & Market Data
Fetch real-time prices using simple syntax. Our Smart Routing formula automatically detects whether you're searching by ticker, name, or coin ID:
=COINGECKO("BTC") — Bitcoin price (auto-prioritizes highest market cap)
=COINGECKO("id:solana") — Solana by CoinGecko ID (most reliable)
=COINGECKO("name:Ethereum") — Ethereum by name
Metrics available: Price (USD), Market Cap, Fully Diluted Valuation (FDV), 24h Volume, 24h Change %, All-Time High (ATH), All-Time Low (ATL), and more.

🔗 On-Chain & DEX Data
Track decentralized exchange prices for any token with a contract address—powered by GeckoTerminal:
=COINGECKO("base:0x...") — Base network token
=COINGECKO("solana:2zM...") — Solana SPL token
Perfect for: Meme coin hunters, DeFi researchers, and long-tail altcoin portfolio trackers.

🖼️ NFT Floor Prices
Monitor NFT collections directly in your spreadsheet—no third-party tools needed:
=COINGECKO("nft:pudgy-penguins") — Pudgy Penguins floor price

📅 Historical Data
Build backtesting models, analyze price trends, or power your crypto trading journal template:
=COINGECKO("id:bitcoin", "2025-12-31") — Bitcoin price on a specific date (UTC 00:00)

🏆 Market Cap Rankings
Import up to 1,000 tokens in a single formula:
=COINGECKO("top:100") — Top 100 cryptocurrencies by market cap
=COINGECKO("top:10:meme-token") — Top 10 meme coins

🔒 Built for Privacy & Security
CoinGecko for Sheets follows the "Least Privilege" principle:
✔️ Only accesses the current spreadsheet—never your Drive or other files
✔️ API keys encrypted using Google's secure PropertiesService
✔️ No data stored on CoinGecko servers—your spreadsheet stays yours


👥 Who Is This For?
Crypto Traders – Build live crypto price trackers and portfolio dashboards
Financial Analysts – Research market cap rankings and historical price trends
DeFi Researchers – Track DEX token prices and on-chain data
NFT Collectors – Monitor floor prices
Developers – Prototype with CoinGecko API data without writing code


💡 Getting Started
1. Install the add-on from Google Workspace Marketplace
2. Open any Google Sheets™ document
3. Get your API Key (free Demo plan or a paid API plan) at https://coingecko.com/api/pricing
4. Enter your key via Extensions → CoinGecko → Settings
5. Start tracking: Type =COINGECKO("BTC") and press Enter!


💵 Pricing
The add-on itself is free to install. API usage is billed through your CoinGecko API plan:
- Demo API (Free): Perfect for personal portfolio tracking
- Pro API (Paid): Higher rate limits for power users and professionals

📖 Support & Resources
For full documentation and advanced guides, visit: https://docs.coingecko.com/docs/google-sheet