Overview

Google Sheets

Installation

Open the listing on Google Workspace Marketplace to install the add-on.

Setup

  1. Extensions → DefiLlama → Open Sidebar

  2. Click Sign In

  3. Authorize with your defillama account

Test

=DEFILLAMA("price", "Bitcoin")

Quick Examples

// Current data
=DEFILLAMA("tvl", "Ethereum")
=DEFILLAMA("fees", "Uniswap", "24h")
=DEFILLAMA("price", "Bitcoin")

// Historical
=DEFILLAMA_HISTORICAL("tvl", "Aave", "2024-01-01")

// Yields
=DEFILLAMA_YIELD("Arbitrum", "USDC", "apy", 10)
=DEFILLAMA_YIELD_TOP_POOLS(20)

// Stablecoins
=DEFILLAMA_STABLECOIN_MCAP()  // Total market cap
=DEFILLAMA_STABLECOIN_MCAP("USDC", "Ethereum")

Next Steps

PreviousOracles TVSNextFunction Reference

Last updated

Was this helpful?