> ## Documentation Index
> Fetch the complete documentation index at: https://docs.coingecko.com/llms.txt
> Use this file to discover all available pages before exploring further.

# CoinGecko for Google Sheets (Official)

> The CoinGecko Official Google Sheets Add-on brings the world's most comprehensive crypto data directly into your workflow. Bypass manual data entry and use the =COINGECKO() custom function to pull live prices, historical prices, NFT floors, and on-chain data of 20 million tokens across 250+ networks and 1,800+ exchanges.

<img src="https://mintcdn.com/coingecko/vAHnSy8v4Jvp_lTE/images/docs/d366a52-image.png?fit=max&auto=format&n=vAHnSy8v4Jvp_lTE&q=85&s=f861d40769b7263085d38e5633f64a54" alt="screenshot" width="1230" height="800" data-path="images/docs/d366a52-image.png" />

<Check>
  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**](https://forms.gle/Ndm7qRC3QVE4YYhB7).
</Check>

## 1. Quick Start

<Steps>
  <Step title="Install Addon">
    Visit '[CoinGecko for Sheets: Live Crypto Prices](https://workspace.google.com/marketplace/app/coingecko_for_sheets_live_crypto_prices/429190203358)' on Google Workspace Marketplace, and click **Install**.
  </Step>

  <Step title="Authorize">
    Check **Select all** to grant the required permissions.

    <img src="https://mintcdn.com/coingecko/vAHnSy8v4Jvp_lTE/images/docs/b15ffca-image.png?fit=max&auto=format&n=vAHnSy8v4Jvp_lTE&q=85&s=2f497dad47f05a737c5446aa909415f8" alt="screenshot" title="screenshot" className="mx-auto" style={{ width:"66%" }} width="2138" height="1896" data-path="images/docs/b15ffca-image.png" />

    * 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.
  </Step>

  <Step title="Set API Key">
    * Go to **Extensions** > **CoinGecko** > **Settings & API Key**
          <img src="https://mintcdn.com/coingecko/vAHnSy8v4Jvp_lTE/images/docs/2252ec1-image.png?fit=max&auto=format&n=vAHnSy8v4Jvp_lTE&q=85&s=588c9aff60b682ac79ef9cee290439a3" alt="screenshot" width="2677" height="1321" data-path="images/docs/2252ec1-image.png" />
    * Enter your [CoinGecko API Key](https://www.coingecko.com/en/api/pricing) in the Settings sidebar.
    * Select your plan (Demo or Pro) and click **Save Settings**.

    *You're now ready to use the =COINGECKO() function!*
  </Step>
</Steps>

## 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**<br />`=COINGECKO("[symbol]")`                         | Insert ticker symbol like 'BTC' or 'ETH' to get the current price. <br /><br />If 2 or more coins share the same ticker symbol, the coin with the largest market cap will be prioritized. <br /><br />Smart Routing: if a token symbol is not found on [www.CoinGecko.com](https://www.coingecko.com), it will search for the token symbol on [www.GeckoTerminal.com](https://www.geckoterminal.com) that has the most liquid pool. | `=COINGECKO("BTC")`<br />`=COINGECKO("ETH")`<br />`=COINGECKO("SOL")`<br />`=COINGECKO("CRYPTOVC")`<br />`=COINGECKO("人生K线")` |
| **Price by Coin Name**<br />`=COINGECKO("name:[coin_name]")`                     | Lookup crypto price by a token name. This prioritizes tokens that are listed on [www.CoinGecko.com](https://www.coingecko.com)                                                                                                                                                                                                                                                                                                      | `=COINGECKO("name:Ethereum")`<br />`=COINGECKO("name:leo token")`                                                             |
| **Price by Coin ID**<br />`=COINGECKO("id:[coin_id]")`                           | Lookup crypto price by a unique coin id.<br /><br />View full [Coin IDs](https://docs.google.com/spreadsheets/d/1wTTuxXt8n9q7C4NDXqQpI3wpKu1_5bGVmP9Xz0XGSyU/edit?gid=0#gid=0).                                                                                                                                                                                                                                                     | `=COINGECKO("id:solana")`<br />`=COINGECKO("id:usd-coin")`                                                                    |
| **On-chain DEX Price**<br />`=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](https://www.geckoterminal.com)<br /><br />Get full [Onchain network IDs](https://docs.google.com/spreadsheets/d/1wTTuxXt8n9q7C4NDXqQpI3wpKu1_5bGVmP9Xz0XGSyU/edit?gid=1120233236#gid=1120233236).                                                                                                   | `=COINGECKO("base:0x...")`<br />`=COINGECKO("solana:2zM...")`                                                                 |
| **NFT Floor Price**<br />`=COINGECKO("nft:[nft_id]")`                            | Lookup NFT floor price by a unique NFT ID.<br /><br />View full [NFT IDs](https://docs.google.com/spreadsheets/d/1wTTuxXt8n9q7C4NDXqQpI3wpKu1_5bGVmP9Xz0XGSyU/edit?gid=207968092#gid=207968092).                                                                                                                                                                                                                                    | `=COINGECKO("nft:pudgy-penguins")`                                                                                            |

> **Pro Tip:** Use the **Coin ID** (e.g., `bitcoin-cash` instead of `BCH`) 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**<br />`=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. <br /><br />View full [Coin IDs](https://docs.google.com/spreadsheets/d/1wTTuxXt8n9q7C4NDXqQpI3wpKu1_5bGVmP9Xz0XGSyU/edit?gid=0#gid=0). | `=COINGECKO("id:bitcoin", "2025-12-31")`<br /><br />`=COINGECKO("id:ethereum", "2025-11-30")` |

### c. Get List of Top Market Cap Ranked Tokens on [CoinGecko.com](https://www.coingecko.com)

<img src="https://mintcdn.com/coingecko/vAHnSy8v4Jvp_lTE/images/docs/71d64bd-image.png?fit=max&auto=format&n=vAHnSy8v4Jvp_lTE&q=85&s=5fd0faf9005891e57930eb4942a5a104" alt="screenshot" width="1230" height="800" data-path="images/docs/71d64bd-image.png" />

Get up to 1,000 token price & market data with just 1 single formula input

| **Data Type**                                                                    | Description                                                                                                                                                                                                                  | **Syntax & Formula Example**                                                           |
| :------------------------------------------------------------------------------- | :--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | :------------------------------------------------------------------------------------- |
| **Top Mcap Coins**<br />`=COINGECKO("top:[number]")`                             | Get Price and Market data of Top N Mcap coins on CoinGecko                                                                                                                                                                   | `=COINGECKO("top:10")`<br />`=COINGECKO("top:100")`                                    |
| **Top Mcap Coins of a Category**<br />`=COINGECKO("top:[number]:[category_id]")` | Get Price and Market data of Top Mcap coins of a specific category<br /><br />Get [Category IDs](https://docs.google.com/spreadsheets/d/1wTTuxXt8n9q7C4NDXqQpI3wpKu1_5bGVmP9Xz0XGSyU/edit?gid=214581757#gid=214581757) here. | `=COINGECKO("top:10:meme-token")`<br />`=COINGECKO("top:100:artificial-intelligence")` |

<Frame caption="Output Example">
  <img src="https://mintcdn.com/coingecko/vAHnSy8v4Jvp_lTE/images/docs/48a3f86-image.png?fit=max&auto=format&n=vAHnSy8v4Jvp_lTE&q=85&s=396f18445e469f34069afd52c9d84e7f" noZoom width="2868" height="1022" data-path="images/docs/48a3f86-image.png" />
</Frame>

***

## 3. Other Features

<img src="https://mintcdn.com/coingecko/vAHnSy8v4Jvp_lTE/images/docs/2815c28-image.png?fit=max&auto=format&n=vAHnSy8v4Jvp_lTE&q=85&s=c72651940cc0aa0ebb86b29447394d56" alt="screenshot" width="1230" height="800" data-path="images/docs/2815c28-image.png" />

### 🔄 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 `=COINGECKO` formula 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 Exceeded` or `403: 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.

**How do I find a Coin ID or NFT ID?**

* You can get the full list of supported CoinGecko API IDs [here](https://docs.google.com/spreadsheets/d/1wTTuxXt8n9q7C4NDXqQpI3wpKu1_5bGVmP9Xz0XGSyU/edit?gid=0#gid=0), or visit [CoinGecko.com](https://www.coingecko.com) and [GeckoTerminal.com](https://www.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.

**Is my API Key safe?**

* 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.

**Why do I need to "Allow" all these permissions to use the add-on?**

* 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.

**What is your privacy policy?**

* Please view the full details of our privacy policy [here](https://docs.coingecko.com/docs/google-sheet-privacy-policy).

**How do I share feedback or request to support more features?**

* If you have any questions or feedback, please share with us [here](https://forms.gle/Ndm7qRC3QVE4YYhB7).