# Moralis

{% hint style="success" %}
Moralis Google Sheets template and tutorial video coming soon!
{% endhint %}

| Formulas                                                                                                                                                                                                                                                                                                                                                   |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| <p><strong>=Moralis(</strong> <a href="/pages/-Mj_8hkrybUtkpITWTcT"><strong>"options"</strong></a><strong>)</strong></p><p>Interact with the <a href="https://moralis.io/">Moralis</a> API using only the SheetLink <a href="/pages/-Mj_8hkrybUtkpITWTcT">"options"</a></p>                                                                                |
| <p><strong>=Moralis\_GetBlock( "chain", "block\_number\_or\_hash", "options")</strong><br>Gets the contents of a block by block hash</p>                                                                                                                                                                                                                   |
| <p><strong>=Moralis\_GetBlockDate( "chain", "date", "options")</strong><br>Gets the closest block of the provided date</p>                                                                                                                                                                                                                                 |
| <p><strong>=Moralis\_GetAddressLogs( "chain", "address", "options")</strong><br>Gets the logs from an address</p>                                                                                                                                                                                                                                          |
| <p><strong>=Moralis\_GetHashTransactions( "chain", "transaction\_hash", "options")</strong><br>Gets NFT transfers by block number or block hash</p>                                                                                                                                                                                                        |
| <p><strong>=Moralis\_GetBlockNFTTransactions( "chain", "block\_number\_or\_hash", "options")</strong><br>Gets the contents of a block transaction by hash</p>                                                                                                                                                                                              |
| <p><strong>=Moralis\_GetAddressNFTsFormatDecimal( "chain", "address", "options")</strong><br>Gets native transactions in descending order based on block number</p>                                                                                                                                                                                        |
| <p><strong>=Moralis\_GetAddressTransactions( "chain", "address", "options")</strong><br>Gets native balance for a specific address</p>                                                                                                                                                                                                                     |
| <p><strong>=Moralis\_GetAddressNativeBalance( "chain", "address", "options")</strong><br>Gets token balances for a specific address</p>                                                                                                                                                                                                                    |
| <p><strong>=Moralis\_GetAddressTokenBalance( "chain", "address", "options")</strong><br>Gets ERC20 token transactions in descending order based on block number</p>                                                                                                                                                                                        |
| <p><strong>=Moralis\_GetAddressTokenTransactions( "chain", "address", "options")</strong><br>Gets NFTs owned by the given address</p>                                                                                                                                                                                                                      |
| <p><strong>=Moralis\_GetAddressNFTTransactions( "chain", "address", "options")</strong><br>Gets the transfers of the tokens matching the given parameters</p>                                                                                                                                                                                              |
| <p><strong>=Moralis\_GetTokenMetadata( "chain", "token\_address", "options")</strong><br>Returns metadata (name, symbol, decimals, logo) for a given token contract address.</p>                                                                                                                                                                           |
| <p><strong>=Moralis\_GetTokenSymbolMetadata( "chain", "symbol", "options")</strong><br>Returns metadata (name, symbol, decimals, logo) for a given symbol</p>                                                                                                                                                                                              |
| <p><strong>=Moralis\_GetTokenAddressPrice( "chain", "token\_address", "options")</strong><br>Returns the price nominated in the native token and usd for a given token contract address.</p>                                                                                                                                                               |
| <p><strong>=Moralis\_GetTokenAddressTransactions( "chain", "token\_address", "options")</strong><br>Gets ERC20 token contract transactions in descending order based on block number</p>                                                                                                                                                                   |
| <p><strong>=Moralis\_GetTokenAddressAllowance( "chain", "token\_address", "owner\_address", "spender\_address", "options")</strong><br>Gets the amount which the spender is allowed to withdraw from the spender</p>                                                                                                                                       |
| <p><strong>=Moralis\_GetNFTSearch( "chain", "query", "options")</strong><br>Gets NFTs that match a given metadata search.</p>                                                                                                                                                                                                                              |
| <p><strong>=Moralis\_GetContractNFTs( "chain", "contract\_address", "options")</strong><br>Gets data, including metadata (where available), for all token ids for the given contract address.</p>                                                                                                                                                          |
| <p><strong>=Moralis\_GetContractNFTTransfers( "chain", "contract\_address", "options")</strong><br>Gets the transfers of the tokens matching the given parameters</p>                                                                                                                                                                                      |
| <p><strong>=Moralis\_GetContractNFTOwners( "chain", "contract\_address", "options")</strong><br>Gets all owners of NFT items within a given contract collection</p>                                                                                                                                                                                        |
| <p><strong>=Moralis\_GetContractNFTMetadata( "chain", "contract\_address", "options")</strong><br>Gets the contract level metadata (name, symbol, base token uri) for the given contract</p>                                                                                                                                                               |
| <p><strong>=Moralis\_GetContractNFTToken( "chain", "contract\_address", "token\_id", "options")</strong><br>Gets data, including metadata (where available), for the given token id of the given contract address.</p>                                                                                                                                     |
| <p><strong>=Moralis\_GetContractNFTTokenOwners( "chain", "contract\_address", "token\_id", "options")</strong><br>Gets all owners of NFT items within a given contract collection</p>                                                                                                                                                                      |
| <p><strong>=Moralis\_GetContractNFTTokenTransfers( "chain", "contract\_address", "token\_id", "options")</strong><br>Gets the transfers of the tokens matching the given parameters</p>                                                                                                                                                                    |
| <p><strong>=Moralis\_GetDomainResolved( "currency", "domain", "options")</strong><br>Resolves an Unstoppable domain and returns the address</p>                                                                                                                                                                                                            |
| <p><strong>=Moralis\_GetLiquidityReserves( "chain", "pair\_address", "options")</strong><br>Get the liquidity reserves for a given pair address</p>                                                                                                                                                                                                        |
| <p><strong>=Moralis\_GetPairAddress( "chain", "exchange", "token0\_address", "token1\_address", "options")</strong><br>Fetches and returns pair data of the provided token0+token1 combination. The token0 and token1 options are interchangable (ie. there is no different outcome in "token0=WETH and token1=USDT" or "token0=USDT and token1=WETH")</p> |

Developers can review the official[ Moralis Documentation](https://docs.moralis.io/moralis-server/web3-sdk/moralis-web3-api-rest) 📖

{% hint style="success" %}
Missing a formula? [Suggest one here](https://www.sheet.link/suggest) 💡
{% endhint %}

{% hint style="info" %}
Note that ["options"](/formulas/options.md) are optional, other variables are required 👍
{% endhint %}

### Navigation <a href="#where-to" id="where-to"></a>

| Page                                                                                                                                                               |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| <p>🚀 <a href="/pages/-MjtZY-40yRn97o3WpS0"><strong>Quick Start</strong></a>​</p><p>60 second getting started guide.</p>                                           |
| <p><strong>​</strong><a href="/pages/-MjtX5XgEZMTHrXWxuJv"><strong>❓ FAQ</strong></a><strong>​</strong></p><p>Answers to frequently asked SheetLink questions.</p> |
| <p>🛠️ <a href="/pages/-MjdlTO1gwme--tVTlRW"><strong>Functions</strong></a><strong>​</strong></p><p>Powerful functions unique to SheetLink.</p>                    |
| <p>💪 <a href="/pages/-Mj_8hkrybUtkpITWTcT"><strong>"options"</strong></a><strong>​</strong></p><p>Control the request to and response from any application.</p>   |

## 🚑 Need Help?

You can always contact us via <support@sheet.link> or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.sheet.link/formulas/apps/moralis.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
