> DEX Aggregator achieving the best rates by splitting orders among multiple DEXes in one single transaction Find examples for accessing every **1inch** endpoint using **Cryptosheets** through: - `side panel console` - `custom functions` (Excel & Googlesheets) - `templates` ## Excel

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | --------------------------------------------------- | -------- | ----------- | | Try It | [Docs](/providers/1inch/quote) | **Quote** | =CS.QUERY("1inch","Quote") | =CS.PARAMETERS("1inch","Quote") | 4 | | Try It | [Docs](/providers/1inch/tokens) | **Tokens** | =CS.QUERY("1inch","Tokens") | =CS.PARAMETERS("1inch","Tokens") | 0 | | Try It | [Docs](/providers/1inch/exchanges) | **Exchanges** | =CS.QUERY("1inch","Exchanges") | =CS.PARAMETERS("1inch","Exchanges") | 0 | | Try It | [Docs](/providers/1inch/healthcheck) | **Healthcheck** | =CS.QUERY("1inch","Healthcheck") | =CS.PARAMETERS("1inch","Healthcheck") | 0 | | Try It | [Docs](/providers/1inch/quote-v2) | **Quote v2** | =CS.QUERY("1inch","Quote v2") | =CS.PARAMETERS("1inch","Quote v2") | 11 | | Try It | [Docs](/providers/1inch/swap) | **Swap** | =CS.QUERY("1inch","Swap") | =CS.PARAMETERS("1inch","Swap") | 18 | | Try It | [Docs](/providers/1inch/protocols) | **Protocols** | =CS.QUERY("1inch","Protocols") | =CS.PARAMETERS("1inch","Protocols") | 0 | | Try It | [Docs](/providers/1inch/tokens-v2) | **Tokens v2** | =CS.QUERY("1inch","Tokens v2") | =CS.PARAMETERS("1inch","Tokens v2") | 0 | | Try It | [Docs](/providers/1inch/approve-factory-controller-get-spender-v3-eth) | **Approve Factory Controller Get Spender v3 ETH** | =CS.QUERY("1inch","Approve Factory Controller Get Spender v3 ETH") | =CS.PARAMETERS("1inch","Approve Factory Controller Get Spender v3 ETH") | 0 | | Try It | [Docs](/providers/1inch/approve-factory-controller-get-call-data-v3-eth) | **Approve Factory Controller Get Call Data v3 ETH** | =CS.QUERY("1inch","Approve Factory Controller Get Call Data v3 ETH") | =CS.PARAMETERS("1inch","Approve Factory Controller Get Call Data v3 ETH") | 2 | | Try It | [Docs](/providers/1inch/swap-factory-controller-get-quote-v3-eth) | **Swap Factory Controller Get Quote v3 ETH** | =CS.QUERY("1inch","Swap Factory Controller Get Quote v3 ETH") | =CS.PARAMETERS("1inch","Swap Factory Controller Get Quote v3 ETH") | 12 | | Try It | [Docs](/providers/1inch/swap-factory-controller-get-swap-v3-eth) | **Swap Factory Controller Get Swap v3 ETH** | =CS.QUERY("1inch","Swap Factory Controller Get Swap v3 ETH") | =CS.PARAMETERS("1inch","Swap Factory Controller Get Swap v3 ETH") | 19 | | Try It | [Docs](/providers/1inch/chain-protocol-controller-get-protocols-v3-eth) | **Chain Protocol Controller Get Protocols v3 ETH** | =CS.QUERY("1inch","Chain Protocol Controller Get Protocols v3 ETH") | =CS.PARAMETERS("1inch","Chain Protocol Controller Get Protocols v3 ETH") | 0 | | Try It | [Docs](/providers/1inch/chain-protocol-controller-get-protocols-images-v3-eth) | **Chain Protocol Controller Get Protocols Images v3 ETH** | =CS.QUERY("1inch","Chain Protocol Controller Get Protocols Images v3 ETH") | =CS.PARAMETERS("1inch","Chain Protocol Controller Get Protocols Images v3 ETH") | 0 | | Try It | [Docs](/providers/1inch/chain-tokens-controller-get-tokens-v3-eth) | **Chain Tokens Controller Get Tokens v3 ETH** | =CS.QUERY("1inch","Chain Tokens Controller Get Tokens v3 ETH") | =CS.PARAMETERS("1inch","Chain Tokens Controller Get Tokens v3 ETH") | 0 | | Try It | [Docs](/providers/1inch/chain-presets-controller-get-presets-v3-eth) | **Chain Presets Controller Get Presets v3 ETH** | =CS.QUERY("1inch","Chain Presets Controller Get Presets v3 ETH") | =CS.PARAMETERS("1inch","Chain Presets Controller Get Presets v3 ETH") | 0 | | Try It | [Docs](/providers/1inch/approve-factory-controller-get-spender-v3-bsc) | **Approve Factory Controller Get Spender v3 BSC** | =CS.QUERY("1inch","Approve Factory Controller Get Spender v3 BSC") | =CS.PARAMETERS("1inch","Approve Factory Controller Get Spender v3 BSC") | 0 | | Try It | [Docs](/providers/1inch/approve-factory-controller-get-call-data-v3-bsc) | **Approve Factory Controller Get Call Data v3 BSC** | =CS.QUERY("1inch","Approve Factory Controller Get Call Data v3 BSC") | =CS.PARAMETERS("1inch","Approve Factory Controller Get Call Data v3 BSC") | 2 | | Try It | [Docs](/providers/1inch/swap-factory-controller-get-quote-v3-bsc) | **Swap Factory Controller Get Quote v3 BSC** | =CS.QUERY("1inch","Swap Factory Controller Get Quote v3 BSC") | =CS.PARAMETERS("1inch","Swap Factory Controller Get Quote v3 BSC") | 12 | | Try It | [Docs](/providers/1inch/swap-factory-controller-get-swap-v3-bsc) | **Swap Factory Controller Get Swap v3 BSC** | =CS.QUERY("1inch","Swap Factory Controller Get Swap v3 BSC") | =CS.PARAMETERS("1inch","Swap Factory Controller Get Swap v3 BSC") | 19 | | Try It | [Docs](/providers/1inch/chain-protocol-controller-get-protocols-v3-bsc) | **Chain Protocol Controller Get Protocols v3 BSC** | =CS.QUERY("1inch","Chain Protocol Controller Get Protocols v3 BSC") | =CS.PARAMETERS("1inch","Chain Protocol Controller Get Protocols v3 BSC") | 0 | | Try It | [Docs](/providers/1inch/chain-protocol-controller-get-protocols-images-v3-bsc) | **Chain Protocol Controller Get Protocols Images v3 BSC** | =CS.QUERY("1inch","Chain Protocol Controller Get Protocols Images v3 BSC") | =CS.PARAMETERS("1inch","Chain Protocol Controller Get Protocols Images v3 BSC") | 0 | | Try It | [Docs](/providers/1inch/chain-tokens-controller-get-tokens-v3-bsc) | **Chain Tokens Controller Get Tokens v3 BSC** | =CS.QUERY("1inch","Chain Tokens Controller Get Tokens v3 BSC") | =CS.PARAMETERS("1inch","Chain Tokens Controller Get Tokens v3 BSC") | 0 | | Try It | [Docs](/providers/1inch/chain-presets-controller-get-presets-v3-bsc) | **Chain Presets Controller Get Presets v3 BSC** | =CS.QUERY("1inch","Chain Presets Controller Get Presets v3 BSC") | =CS.PARAMETERS("1inch","Chain Presets Controller Get Presets v3 BSC") | 0 | | Try It | [Docs](/providers/1inch/factory-healthcheck-controller-is-life-v3-bsc) | **Factory Healthcheck Controller Is Life v3 BSC** | =CS.QUERY("1inch","Factory Healthcheck Controller Is Life v3 BSC") | =CS.PARAMETERS("1inch","Factory Healthcheck Controller Is Life v3 BSC") | 0 | | Try It | [Docs](/providers/1inch/approve-factory-controller-get-spender-v3-polygon) | **Approve Factory Controller Get Spender v3 Polygon** | =CS.QUERY("1inch","Approve Factory Controller Get Spender v3 Polygon") | =CS.PARAMETERS("1inch","Approve Factory Controller Get Spender v3 Polygon") | 0 | | Try It | [Docs](/providers/1inch/approve-factory-controller-get-call-data-v3-polygon) | **Approve Factory Controller Get Call Data v3 Polygon** | =CS.QUERY("1inch","Approve Factory Controller Get Call Data v3 Polygon") | =CS.PARAMETERS("1inch","Approve Factory Controller Get Call Data v3 Polygon") | 2 | | Try It | [Docs](/providers/1inch/factory-healthcheck-controller-is-life-v3-polygon) | **Factory Healthcheck Controller Is Life v3 Polygon** | =CS.QUERY("1inch","Factory Healthcheck Controller Is Life v3 Polygon") | =CS.PARAMETERS("1inch","Factory Healthcheck Controller Is Life v3 Polygon") | 0 | | Try It | [Docs](/providers/1inch/chain-protocol-controller-get-protocols-v3-polygon) | **Chain Protocol Controller Get Protocols v3 Polygon** | =CS.QUERY("1inch","Chain Protocol Controller Get Protocols v3 Polygon") | =CS.PARAMETERS("1inch","Chain Protocol Controller Get Protocols v3 Polygon") | 0 | | Try It | [Docs](/providers/1inch/chain-protocol-controller-get-protocols-images-v3-polygon) | **Chain Protocol Controller Get Protocols Images v3 Polygon** | =CS.QUERY("1inch","Chain Protocol Controller Get Protocols Images v3 Polygon") | =CS.PARAMETERS("1inch","Chain Protocol Controller Get Protocols Images v3 Polygon") | 0 | | Try It | [Docs](/providers/1inch/chain-tokens-controller-get-tokens-v3-polygon) | **Chain Tokens Controller Get Tokens v3 Polygon** | =CS.QUERY("1inch","Chain Tokens Controller Get Tokens v3 Polygon") | =CS.PARAMETERS("1inch","Chain Tokens Controller Get Tokens v3 Polygon") | 0 | | Try It | [Docs](/providers/1inch/chain-presets-controller-get-presets-v3-polygon) | **Chain Presets Controller Get Presets v3 Polygon** | =CS.QUERY("1inch","Chain Presets Controller Get Presets v3 Polygon") | =CS.PARAMETERS("1inch","Chain Presets Controller Get Presets v3 Polygon") | 0 | | Try It | [Docs](/providers/1inch/swap-factory-controller-get-quote-v3-polygon) | **Swap Factory Controller Get Quote v3 Polygon** | =CS.QUERY("1inch","Swap Factory Controller Get Quote v3 Polygon") | =CS.PARAMETERS("1inch","Swap Factory Controller Get Quote v3 Polygon") | 12 | | Try It | [Docs](/providers/1inch/swap-factory-controller-get-swap-v3-polygon) | **Swap Factory Controller Get Swap v3 Polygon** | =CS.QUERY("1inch","Swap Factory Controller Get Swap v3 Polygon") | =CS.PARAMETERS("1inch","Swap Factory Controller Get Swap v3 Polygon") | 19 |

## Google Sheets

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- | | Try It | [Docs](/providers/1inch/quote) | **Quote** | =CSQUERY("1inch","Quote") | =CSPARAMETERS("1inch","Quote") | 4 | | Try It | [Docs](/providers/1inch/tokens) | **Tokens** | =CSQUERY("1inch","Tokens") | =CSPARAMETERS("1inch","Tokens") | 0 | | Try It | [Docs](/providers/1inch/exchanges) | **Exchanges** | =CSQUERY("1inch","Exchanges") | =CSPARAMETERS("1inch","Exchanges") | 0 | | Try It | [Docs](/providers/1inch/healthcheck) | **Healthcheck** | =CSQUERY("1inch","Healthcheck") | =CSPARAMETERS("1inch","Healthcheck") | 0 | | Try It | [Docs](/providers/1inch/quote-v2) | **Quote v2** | =CSQUERY("1inch","Quote v2") | =CSPARAMETERS("1inch","Quote v2") | 11 | | Try It | [Docs](/providers/1inch/swap) | **Swap** | =CSQUERY("1inch","Swap") | =CSPARAMETERS("1inch","Swap") | 18 | | Try It | [Docs](/providers/1inch/protocols) | **Protocols** | =CSQUERY("1inch","Protocols") | =CSPARAMETERS("1inch","Protocols") | 0 | | Try It | [Docs](/providers/1inch/tokens-v2) | **Tokens v2** | =CSQUERY("1inch","Tokens v2") | =CSPARAMETERS("1inch","Tokens v2") | 0 | | Try It | [Docs](/providers/1inch/approve-factory-controller-get-spender-v3-eth) | **Approve Factory Controller Get Spender v3 ETH** | =CSQUERY("1inch","Approve Factory Controller Get Spender v3 ETH") | =CSPARAMETERS("1inch","Approve Factory Controller Get Spender v3 ETH") | 0 | | Try It | [Docs](/providers/1inch/approve-factory-controller-get-call-data-v3-eth) | **Approve Factory Controller Get Call Data v3 ETH** | =CSQUERY("1inch","Approve Factory Controller Get Call Data v3 ETH") | =CSPARAMETERS("1inch","Approve Factory Controller Get Call Data v3 ETH") | 2 | | Try It | [Docs](/providers/1inch/swap-factory-controller-get-quote-v3-eth) | **Swap Factory Controller Get Quote v3 ETH** | =CSQUERY("1inch","Swap Factory Controller Get Quote v3 ETH") | =CSPARAMETERS("1inch","Swap Factory Controller Get Quote v3 ETH") | 12 | | Try It | [Docs](/providers/1inch/swap-factory-controller-get-swap-v3-eth) | **Swap Factory Controller Get Swap v3 ETH** | =CSQUERY("1inch","Swap Factory Controller Get Swap v3 ETH") | =CSPARAMETERS("1inch","Swap Factory Controller Get Swap v3 ETH") | 19 | | Try It | [Docs](/providers/1inch/chain-protocol-controller-get-protocols-v3-eth) | **Chain Protocol Controller Get Protocols v3 ETH** | =CSQUERY("1inch","Chain Protocol Controller Get Protocols v3 ETH") | =CSPARAMETERS("1inch","Chain Protocol Controller Get Protocols v3 ETH") | 0 | | Try It | [Docs](/providers/1inch/chain-protocol-controller-get-protocols-images-v3-eth) | **Chain Protocol Controller Get Protocols Images v3 ETH** | =CSQUERY("1inch","Chain Protocol Controller Get Protocols Images v3 ETH") | =CSPARAMETERS("1inch","Chain Protocol Controller Get Protocols Images v3 ETH") | 0 | | Try It | [Docs](/providers/1inch/chain-tokens-controller-get-tokens-v3-eth) | **Chain Tokens Controller Get Tokens v3 ETH** | =CSQUERY("1inch","Chain Tokens Controller Get Tokens v3 ETH") | =CSPARAMETERS("1inch","Chain Tokens Controller Get Tokens v3 ETH") | 0 | | Try It | [Docs](/providers/1inch/chain-presets-controller-get-presets-v3-eth) | **Chain Presets Controller Get Presets v3 ETH** | =CSQUERY("1inch","Chain Presets Controller Get Presets v3 ETH") | =CSPARAMETERS("1inch","Chain Presets Controller Get Presets v3 ETH") | 0 | | Try It | [Docs](/providers/1inch/approve-factory-controller-get-spender-v3-bsc) | **Approve Factory Controller Get Spender v3 BSC** | =CSQUERY("1inch","Approve Factory Controller Get Spender v3 BSC") | =CSPARAMETERS("1inch","Approve Factory Controller Get Spender v3 BSC") | 0 | | Try It | [Docs](/providers/1inch/approve-factory-controller-get-call-data-v3-bsc) | **Approve Factory Controller Get Call Data v3 BSC** | =CSQUERY("1inch","Approve Factory Controller Get Call Data v3 BSC") | =CSPARAMETERS("1inch","Approve Factory Controller Get Call Data v3 BSC") | 2 | | Try It | [Docs](/providers/1inch/swap-factory-controller-get-quote-v3-bsc) | **Swap Factory Controller Get Quote v3 BSC** | =CSQUERY("1inch","Swap Factory Controller Get Quote v3 BSC") | =CSPARAMETERS("1inch","Swap Factory Controller Get Quote v3 BSC") | 12 | | Try It | [Docs](/providers/1inch/swap-factory-controller-get-swap-v3-bsc) | **Swap Factory Controller Get Swap v3 BSC** | =CSQUERY("1inch","Swap Factory Controller Get Swap v3 BSC") | =CSPARAMETERS("1inch","Swap Factory Controller Get Swap v3 BSC") | 19 | | Try It | [Docs](/providers/1inch/chain-protocol-controller-get-protocols-v3-bsc) | **Chain Protocol Controller Get Protocols v3 BSC** | =CSQUERY("1inch","Chain Protocol Controller Get Protocols v3 BSC") | =CSPARAMETERS("1inch","Chain Protocol Controller Get Protocols v3 BSC") | 0 | | Try It | [Docs](/providers/1inch/chain-protocol-controller-get-protocols-images-v3-bsc) | **Chain Protocol Controller Get Protocols Images v3 BSC** | =CSQUERY("1inch","Chain Protocol Controller Get Protocols Images v3 BSC") | =CSPARAMETERS("1inch","Chain Protocol Controller Get Protocols Images v3 BSC") | 0 | | Try It | [Docs](/providers/1inch/chain-tokens-controller-get-tokens-v3-bsc) | **Chain Tokens Controller Get Tokens v3 BSC** | =CSQUERY("1inch","Chain Tokens Controller Get Tokens v3 BSC") | =CSPARAMETERS("1inch","Chain Tokens Controller Get Tokens v3 BSC") | 0 | | Try It | [Docs](/providers/1inch/chain-presets-controller-get-presets-v3-bsc) | **Chain Presets Controller Get Presets v3 BSC** | =CSQUERY("1inch","Chain Presets Controller Get Presets v3 BSC") | =CSPARAMETERS("1inch","Chain Presets Controller Get Presets v3 BSC") | 0 | | Try It | [Docs](/providers/1inch/factory-healthcheck-controller-is-life-v3-bsc) | **Factory Healthcheck Controller Is Life v3 BSC** | =CSQUERY("1inch","Factory Healthcheck Controller Is Life v3 BSC") | =CSPARAMETERS("1inch","Factory Healthcheck Controller Is Life v3 BSC") | 0 | | Try It | [Docs](/providers/1inch/approve-factory-controller-get-spender-v3-polygon) | **Approve Factory Controller Get Spender v3 Polygon** | =CSQUERY("1inch","Approve Factory Controller Get Spender v3 Polygon") | =CSPARAMETERS("1inch","Approve Factory Controller Get Spender v3 Polygon") | 0 | | Try It | [Docs](/providers/1inch/approve-factory-controller-get-call-data-v3-polygon) | **Approve Factory Controller Get Call Data v3 Polygon** | =CSQUERY("1inch","Approve Factory Controller Get Call Data v3 Polygon") | =CSPARAMETERS("1inch","Approve Factory Controller Get Call Data v3 Polygon") | 2 | | Try It | [Docs](/providers/1inch/factory-healthcheck-controller-is-life-v3-polygon) | **Factory Healthcheck Controller Is Life v3 Polygon** | =CSQUERY("1inch","Factory Healthcheck Controller Is Life v3 Polygon") | =CSPARAMETERS("1inch","Factory Healthcheck Controller Is Life v3 Polygon") | 0 | | Try It | [Docs](/providers/1inch/chain-protocol-controller-get-protocols-v3-polygon) | **Chain Protocol Controller Get Protocols v3 Polygon** | =CSQUERY("1inch","Chain Protocol Controller Get Protocols v3 Polygon") | =CSPARAMETERS("1inch","Chain Protocol Controller Get Protocols v3 Polygon") | 0 | | Try It | [Docs](/providers/1inch/chain-protocol-controller-get-protocols-images-v3-polygon) | **Chain Protocol Controller Get Protocols Images v3 Polygon** | =CSQUERY("1inch","Chain Protocol Controller Get Protocols Images v3 Polygon") | =CSPARAMETERS("1inch","Chain Protocol Controller Get Protocols Images v3 Polygon") | 0 | | Try It | [Docs](/providers/1inch/chain-tokens-controller-get-tokens-v3-polygon) | **Chain Tokens Controller Get Tokens v3 Polygon** | =CSQUERY("1inch","Chain Tokens Controller Get Tokens v3 Polygon") | =CSPARAMETERS("1inch","Chain Tokens Controller Get Tokens v3 Polygon") | 0 | | Try It | [Docs](/providers/1inch/chain-presets-controller-get-presets-v3-polygon) | **Chain Presets Controller Get Presets v3 Polygon** | =CSQUERY("1inch","Chain Presets Controller Get Presets v3 Polygon") | =CSPARAMETERS("1inch","Chain Presets Controller Get Presets v3 Polygon") | 0 | | Try It | [Docs](/providers/1inch/swap-factory-controller-get-quote-v3-polygon) | **Swap Factory Controller Get Quote v3 Polygon** | =CSQUERY("1inch","Swap Factory Controller Get Quote v3 Polygon") | =CSPARAMETERS("1inch","Swap Factory Controller Get Quote v3 Polygon") | 12 | | Try It | [Docs](/providers/1inch/swap-factory-controller-get-swap-v3-polygon) | **Swap Factory Controller Get Swap v3 Polygon** | =CSQUERY("1inch","Swap Factory Controller Get Swap v3 Polygon") | =CSPARAMETERS("1inch","Swap Factory Controller Get Swap v3 Polygon") | 19 |

[Signing up for Cryptosheets is free](https://app.cryptosheets.com/#/register) get crypto data in 30 seconds or less **Get Cryptosheets for Microsoft Excel** **Get Cryptosheets for Googlesheets** \*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 **Click here** for additional documentation from 1inch Learn more [here](https://intercom.help/cryptosheets/en/) --- Tags: `1inch` `provider`