This official add-on follows the principle of least privilege — it only accesses the sheet you currently have open. It does not request access to Google Drive or other spreadsheets.
Quick Start
1
Install
Visit CoinGecko for Sheets on Google Workspace Marketplace and click Install.
2
Authorize
Check Select all to grant the required permissions.The add-on needs these permissions to communicate with the CoinGecko API and write data to your sheet. CoinGecko does NOT have access to your email or personal data.
3
Set API key
Go to Extensions > CoinGecko > Settings & API Key.Enter your CoinGecko API key, select your plan (Demo or Pro), and click Save Settings.
Using =COINGECKO()
A single “Smart Routing” function that auto-detects whether you’re querying a ticker, coin ID, onchain token, or NFT.
Latest Price
| Syntax | Description | Example |
|---|---|---|
=COINGECKO("SYMBOL") | Price by ticker symbol. If multiple coins share the symbol, the largest by market cap is returned. Falls back to GeckoTerminal if not found on CoinGecko. | =COINGECKO("BTC") |
=COINGECKO("name:NAME") | Price by coin name. Prioritizes CoinGecko-listed tokens. | =COINGECKO("name:Ethereum") |
=COINGECKO("id:COIN_ID") | Price by coin ID. Most reliable — avoids ticker conflicts. | =COINGECKO("id:solana") |
=COINGECKO("NETWORK:ADDRESS") | Onchain DEX price by network ID and token address. | =COINGECKO("base:0x...") |
=COINGECKO("nft:NFT_ID") | NFT floor price by NFT ID. | =COINGECKO("nft:pudgy-penguins") |
Use the Coin ID (e.g.
id:bitcoin-cash instead of BCH) for the most reliable results — symbols can be shared by multiple tokens.Historical Price
| Syntax | Description | Example |
|---|---|---|
=COINGECKO("id:COIN_ID", "YYYY-MM-DD") | Historical price at a specific date (daily 00:00 UTC). View coin IDs. | =COINGECKO("id:bitcoin", "2025-12-31") |
Top Market Cap Rankings
Get up to 1,000 tokens with a single formula:| Syntax | Description | Example |
|---|---|---|
=COINGECKO("top:N") | Top N coins by market cap. | =COINGECKO("top:100") |
=COINGECKO("top:N:CATEGORY_ID") | Top N coins by market cap in a category. | =COINGECKO("top:10:meme-token") |
Other Features
Bulk Refresh
Google Sheets caches formulas for 1–2 hours. To force-update all=COINGECKO formulas:Open the CoinGecko Sidebar and click Refresh All Data.
Error Debugging
Go to Extensions > CoinGecko > View Error Logs:Opens a log sheet with exact API error responses (e.g.
429: Rate Limit Exceeded, 403: Invalid API Key).
FAQ
Share Feedback
Have questions or feedback? Let us know.