Excel

Google Sheets

> Get detailed defi data on the AAVE protocol &amp; ecosystem including TVL, metrics, staking, liquidity pools, historical data, address pools and much more

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/AAVE%20Protocol%20API">AAVE Protocol API</a>** endpoint using **Cryptosheets** through:

- `side panel console`
- `custom functions` (Excel & Googlesheets)
- `templates`

## Excel

<div class="markdown">

| App Url                                                                                 | Docs Url                                                                                 | Name                        | Example                                             | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | --------------------------------------------------- | --------   | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/AAVE%20Protocol%20API/Addresses%20Status%20Address" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/aave-protocol-api/addresses-status-address) | **Addresses Status Address** | <inline-code functionvalue='=CS.QUERY("AAVE Protocol API","Addresses Status Address",{"address","0x24a42fd28c976a61df5d00d0599c34c4f90748c8"})'>=CS.QUERY("AAVE Protocol API","Addresses Status Address")</inline-code> | <inline-code>=CS.PARAMETERS("AAVE Protocol API","Addresses Status Address")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/AAVE%20Protocol%20API/Data%20Tvl" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/aave-protocol-api/data-tvl) | **Data Tvl** | <inline-code functionvalue='=CS.QUERY("AAVE Protocol API","Data Tvl")'>=CS.QUERY("AAVE Protocol API","Data Tvl")</inline-code> | <inline-code>=CS.PARAMETERS("AAVE Protocol API","Data Tvl")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/AAVE%20Protocol%20API/Data%20Daily%20Volume%2024%20Hours" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/aave-protocol-api/data-daily-volume-24-hours) | **Data Daily Volume 24 Hours** | <inline-code functionvalue='=CS.QUERY("AAVE Protocol API","Data Daily Volume 24 Hours")'>=CS.QUERY("AAVE Protocol API","Data Daily Volume 24 Hours")</inline-code> | <inline-code>=CS.PARAMETERS("AAVE Protocol API","Data Daily Volume 24 Hours")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/AAVE%20Protocol%20API/Data%20Liquidity%20V1" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/aave-protocol-api/data-liquidity-v1) | **Data Liquidity V1** | <inline-code functionvalue='=CS.QUERY("AAVE Protocol API","Data Liquidity V1",{"poolId","0x24a42fd28c976a61df5d00d0599c34c4f90748c8";"date","01-01-2020"})'>=CS.QUERY("AAVE Protocol API","Data Liquidity V1")</inline-code> | <inline-code>=CS.PARAMETERS("AAVE Protocol API","Data Liquidity V1")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/AAVE%20Protocol%20API/Data%20Liquidity%20V2" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/aave-protocol-api/data-liquidity-v2) | **Data Liquidity V2** | <inline-code functionvalue='=CS.QUERY("AAVE Protocol API","Data Liquidity V2",{"poolId","0xb53c1a33016b2dc2ff3653530bff1848a515c8c5";"date","01-01-2020"})'>=CS.QUERY("AAVE Protocol API","Data Liquidity V2")</inline-code> | <inline-code>=CS.PARAMETERS("AAVE Protocol API","Data Liquidity V2")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/AAVE%20Protocol%20API/Data%20Pools" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/aave-protocol-api/data-pools) | **Data Pools** | <inline-code functionvalue='=CS.QUERY("AAVE Protocol API","Data Pools")'>=CS.QUERY("AAVE Protocol API","Data Pools")</inline-code> | <inline-code>=CS.PARAMETERS("AAVE Protocol API","Data Pools")</inline-code> | 0 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/AAVE%20Protocol%20API/Addresses%20Status%20Address" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/aave-protocol-api/addresses-status-address) | **Addresses Status Address** | <inline-code functionvalue='=CSQUERY("AAVE Protocol API","Addresses Status Address",{"address","0x24a42fd28c976a61df5d00d0599c34c4f90748c8"})'>=CSQUERY("AAVE Protocol API","Addresses Status Address")</inline-code> | <inline-code>=CSPARAMETERS("AAVE Protocol API","Addresses Status Address")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/AAVE%20Protocol%20API/Data%20Tvl" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/aave-protocol-api/data-tvl) | **Data Tvl** | <inline-code functionvalue='=CSQUERY("AAVE Protocol API","Data Tvl")'>=CSQUERY("AAVE Protocol API","Data Tvl")</inline-code> | <inline-code>=CSPARAMETERS("AAVE Protocol API","Data Tvl")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/AAVE%20Protocol%20API/Data%20Daily%20Volume%2024%20Hours" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/aave-protocol-api/data-daily-volume-24-hours) | **Data Daily Volume 24 Hours** | <inline-code functionvalue='=CSQUERY("AAVE Protocol API","Data Daily Volume 24 Hours")'>=CSQUERY("AAVE Protocol API","Data Daily Volume 24 Hours")</inline-code> | <inline-code>=CSPARAMETERS("AAVE Protocol API","Data Daily Volume 24 Hours")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/AAVE%20Protocol%20API/Data%20Liquidity%20V1" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/aave-protocol-api/data-liquidity-v1) | **Data Liquidity V1** | <inline-code functionvalue='=CSQUERY("AAVE Protocol API","Data Liquidity V1",{"poolId","0x24a42fd28c976a61df5d00d0599c34c4f90748c8";"date","01-01-2020"})'>=CSQUERY("AAVE Protocol API","Data Liquidity V1")</inline-code> | <inline-code>=CSPARAMETERS("AAVE Protocol API","Data Liquidity V1")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/AAVE%20Protocol%20API/Data%20Liquidity%20V2" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/aave-protocol-api/data-liquidity-v2) | **Data Liquidity V2** | <inline-code functionvalue='=CSQUERY("AAVE Protocol API","Data Liquidity V2",{"poolId","0xb53c1a33016b2dc2ff3653530bff1848a515c8c5";"date","01-01-2020"})'>=CSQUERY("AAVE Protocol API","Data Liquidity V2")</inline-code> | <inline-code>=CSPARAMETERS("AAVE Protocol API","Data Liquidity V2")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/AAVE%20Protocol%20API/Data%20Pools" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/aave-protocol-api/data-pools) | **Data Pools** | <inline-code functionvalue='=CSQUERY("AAVE Protocol API","Data Pools")'>=CSQUERY("AAVE Protocol API","Data Pools")</inline-code> | <inline-code>=CSPARAMETERS("AAVE Protocol API","Data Pools")</inline-code> | 0 |

</div>

[Signing up for Cryptosheets is free](https://app.cryptosheets.com/#/register) get crypto data in 30 seconds or less

**<a href="https://appsource.microsoft.com/en-us/product/office/WA104381695?src=docs-AAVE Protocol API">Get Cryptosheets for Microsoft Excel</a>**

**<a href="https://gsuite.google.com/u/2/marketplace/app/cryptosheets/898843532532?hl=en&pann=sheets_addon_widget?src=docs-AAVE Protocol API">Get Cryptosheets for Googlesheets</a>**

\*Note: you must have one of the [supported versions](https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-architecture) of Microsoft Office or Excel for custom functions to work

**<a href="https://docs.aave.com/portal/">Click here</a>** for additional documentation from AAVE Protocol API

Learn more [here](https://intercom.help/cryptosheets/en/)

---

Tags: `AAVE Protocol API` `provider` 


How to pull AAVE Protocol API data into Excel and Google Sheets