Back to Home

How to Use DeFiSheets

Get started with tracking your crypto portfolio in minutes

Quick start: Install the add-on, get your DeBank API token, and start tracking your DeFi portfolio in Google Sheets™.

Getting Started

Step 1: Install DeFiSheets

DeFiSheets is available as a Google Sheets™ add-on. To install:

  1. Open any Google Sheet
  2. Click on Extensions in the menu
  3. Select Add-ons → Get add-ons
  4. Search for "DeFiSheets" in the Google Workspace Marketplace
  5. Click Install and grant the necessary permissions

Step 2: Get Your DeBank API Token

Important: DeBank API Token Required

DeFiSheets requires a DeBank API token to fetch your wallet balances and DeFi positions. This is a free token provided by DeBank.

To get your DeBank API token:

  1. Visit DeBank
  2. Sign up or log in to your DeBank account
  3. Navigate to the API section in your dashboard
  4. Create a new API key or copy your existing one
  5. Keep this token safe - you'll need it to configure DeFiSheets

Step 3: Configure DeFiSheets

After installation, confremigure DeFiSheets with your DeBank token:

  1. In Google Sheets™, go to Extensions → DeFiSheets → Open
  2. Click "Configure Token" to enter your DeBank API token
  3. Save your token to unlock the query features
  4. Create queries to specify which wallet addresses and data you want to track
  5. Choose where in your spreadsheet the data should appear

Once configured, you can create and manage multiple queries to track different wallets, protocols, and DeFi positions across your spreadsheets.

Common Questions

How do I install DeFiSheets?

DeFiSheets is available as a Google Sheets™ add-on. You can install it from the Google Workspace Marketplace or through Extensions > Add-ons > Get add-ons within Google Sheets™.

Do I need a DeBank token to use DeFiSheets?

Yes, a DeBank API token is required to use DeFiSheets. The token allows DeFiSheets to fetch your wallet data from DeBank's API. You can get a token by signing up at DeBank.

Is my portfolio data secure?

Yes! Your portfolio data stays entirely in your Google Sheets™ and benefits from Google's enterprise-grade security. We never store or access your specific holdings. Your DeBank API token is encrypted and stored securely. Learn more in our Privacy Policy.

Which cryptocurrencies and chains are supported?

DeFiSheets supports all cryptocurrencies and blockchain networks available through DeBank's API, including Ethereum, BSC, Polygon, Arbitrum, Optimism, Avalanche, and many more. If you can track it on DeBank, you can track it in DeFiSheets.

How often are prices and balances updated?

Data is fetched in real-time when you use DeFiSheets functions or refresh your spreadsheet. You can set up your spreadsheet to refresh automatically at your preferred intervals using Google Sheets™' built-in features.

Can I track multiple wallets?

Yes! You can add multiple wallet addresses to track in the DeFiSheets settings. All your wallets will be available to query in your spreadsheet.

What DeFi protocols are supported?

DeFiSheets supports hundreds of DeFi protocols through DeBank's integration, including Aave, Uniswap, Curve, Compound, Lido, and many more. If DeBank tracks it, DeFiSheets can display it.

Do I need to share my private keys?

No! DeFiSheets only needs your public wallet addresses (the same addresses you'd share publicly or use on block explorers). Never share your private keys or seed phrases with anyone.

Need More Help?

If you're still having issues or have questions not covered here, please visit our Contact page to get in touch with us.