Your privacy is our priority. This official add-on follows the principle of โleast privilege.โ Unlike other tools, it does not request permission to access your Google Drive or all of your spreadsheets. It is strictly limited to reading and updating only the specific sheet you have currently opened to fetch CoinGecko data.If you have any questions or feedback, please share with us here.
1. Quick Start
Install Addon
Visit โCoinGecko for Sheets: Live Crypto Pricesโ on Google Workspace Marketplace, and click Install.
Authorize
Check Select all to grant the required permissions.
- To provide a seamless experience, CoinGecko for Sheets needs these permissions to communicate with our API and write data to your sheet.
- We follow the principle of โleast privilegeโ and only access data necessary to run the tool. We DO NOT have access to your email address and personal data.
Set API Key
-
Go to Extensions > CoinGecko > Settings & API Key
- Enter your CoinGecko API Key in the Settings sidebar.
- Select your plan (Demo or Pro) and click Save Settings.
2. Using the =COINGECKO() Function
The add-on uses a single โSmart Routingโ function. It automatically detects if you are looking for a market ticker, a specific coin ID, an on-chain contract, or an NFT.
a. Get Latest Price of a Token or NFT
| Data Type & Syntax | Description | Formula Example |
|---|---|---|
Price by Ticker Symbol=COINGECKO("[symbol]") | Insert ticker symbol like โBTCโ or โETHโ to get the current price. If 2 or more coins share the same ticker symbol, the coin with the largest market cap will be prioritized. Smart Routing: if a token symbol is not found on www.CoinGecko.com, it will search for the token symbol on www.GeckoTerminal.com that has the most liquid pool. | =COINGECKO("BTC")=COINGECKO("ETH")=COINGECKO("SOL")=COINGECKO("CRYPTOVC")=COINGECKO("ไบบ็K็บฟ") |
Price by Coin Name=COINGECKO("name:[coin_name]") | Lookup crypto price by a token name. This prioritizes tokens that are listed on www.CoinGecko.com | =COINGECKO("name:Ethereum")=COINGECKO("name:leo token") |
Price by Coin ID=COINGECKO("id:[coin_id]") | Lookup crypto price by a unique coin id. View full Coin IDs. | =COINGECKO("id:solana")=COINGECKO("id:usd-coin") |
On-chain DEX Price=COINGECKO("[onchain_network_id]:[token_address]") | Lookup onchain DEX token price by network and token address. This prioritizes tokens that are listed on www.geckoterminal.com Get full Onchain network IDs. | =COINGECKO("base:0x...")=COINGECKO("solana:2zM...") |
NFT Floor Price=COINGECKO("nft:[nft_id]") | Lookup NFT floor price by a unique NFT ID. View full NFT IDs. | =COINGECKO("nft:pudgy-penguins") |
Pro Tip: Use the Coin ID (e.g.,bitcoin-cashinstead ofBCH) for the most reliable results, as symbols can sometimes be shared by multiple tokens.
b. Get Historical Price of a Token
| Data Type | Description | Syntax & Formula Example |
|---|---|---|
Get Historical Coin Price=COINGECKO("id:[coin_id]", "[YYYY-MM-DD]") | Get historical price of a specific date (daily 00:00 UTC) of a coin on CoinGecko, based on unique Coin ID. View full Coin IDs. | =COINGECKO("id:bitcoin", "2025-12-31")=COINGECKO("id:ethereum", "2025-11-30") |
c. Get List of Top Market Cap Ranked Tokens on CoinGecko.com
| Data Type | Description | Syntax & Formula Example |
|---|---|---|
Top Mcap Coins=COINGECKO("top:[number]") | Get Price and Market data of Top N Mcap coins on CoinGecko | =COINGECKO("top:10")=COINGECKO("top:100") |
Top Mcap Coins of a Category=COINGECKO("top:[number]:[category_id]") | Get Price and Market data of Top Mcap coins of a specific category Get Category IDs here. | =COINGECKO("top:10:meme-token")=COINGECKO("top:100:artificial-intelligence") |
3. Other Features
๐ Bulk Refresh
Google Sheets typically caches formulas for 1-2 hours. To get โright nowโ prices for your entire sheet:- Open the CoinGecko Sidebar.
- Click Refresh All Data. This will force-update every
=COINGECKOformula in your active tab.
๐ Error Debugging
If a formula returns an error, donโt guess why.- Go to Extensions > CoinGecko > View Error Logs.
- This opens a dedicated log sheet showing the exact API response error (e.g.,
429: Rate Limit Exceededor403: Invalid API Key).
4. Troubleshooting & FAQ
Why is my formula showing #NAME?- Ensure the add-on is installed and โCoinGeckoโ appears under the Extensions menu. If itโs missing, try refreshing your browser.
- You can get the full list of supported CoinGecko API IDs here, or visit CoinGecko.com and GeckoTerminal.com. The Coin ID can also be found in the โAPI IDโ section on the right sidebar of the coin or NFTโs page.
- Yes. Your API key is stored securely using Googleโs PropertiesService, meaning it is encrypted and unique to your Google user account. CoinGecko does not see or store your key on its own servers.
- We highly recommend checking โSelect allโ during the authorization flow. If a specific box is unchecked (such as โConnect to an external serviceโ), the add-on will be unable to fetch price data, leading to errors in your formulas.
- To provide a seamless experience, CoinGecko for Sheets requires specific authorizations to interact with your data and our API servers. We follow the principle of โLeast Privilege,โ meaning we only request the absolute minimum access needed to run our tools.
- View and manage spreadsheets: Required to populate your cells with market data and create the โError Logsโ sheet if something goes wrong.
- Connect to an external service: This allows the add-on to securely fetch real-time cryptocurrency prices directly from CoinGeckoโs API servers.
- Allow this application to run when you are not present: Essential for keeping your custom formulas active and responsive without requiring you to have the sidebar open at all times.
- Display third-party web content: Needed to show the user interface in the Sidebar, where you manage your API Key, plan settings, and troubleshooting tools.
- Please view the full details of our privacy policy here.
- If you have any questions or feedback, please share with us here.