SheetLink
Search…
Moralis
The Web3 Operating System: Build & scale their dApps without the cost & complexity.
Moralis Google Sheets template and tutorial video coming soon!
Formulas
=Moralis( "options")
Interact with the Moralis API using only the SheetLink "options"​
=Moralis_GetBlock( "chain", "block_number_or_hash", "options") Gets the contents of a block by block hash
=Moralis_GetBlockDate( "chain", "date", "options") Gets the closest block of the provided date
=Moralis_GetAddressLogs( "chain", "address", "options") Gets the logs from an address
=Moralis_GetHashTransactions( "chain", "transaction_hash", "options") Gets NFT transfers by block number or block hash
=Moralis_GetBlockNFTTransactions( "chain", "block_number_or_hash", "options") Gets the contents of a block transaction by hash
=Moralis_GetAddressNFTsFormatDecimal( "chain", "address", "options") Gets native transactions in descending order based on block number
=Moralis_GetAddressTransactions( "chain", "address", "options") Gets native balance for a specific address
=Moralis_GetAddressNativeBalance( "chain", "address", "options") Gets token balances for a specific address
=Moralis_GetAddressTokenBalance( "chain", "address", "options") Gets ERC20 token transactions in descending order based on block number
=Moralis_GetAddressTokenTransactions( "chain", "address", "options") Gets NFTs owned by the given address
=Moralis_GetAddressNFTTransactions( "chain", "address", "options") Gets the transfers of the tokens matching the given parameters
=Moralis_GetTokenMetadata( "chain", "token_address", "options") Returns metadata (name, symbol, decimals, logo) for a given token contract address.
=Moralis_GetTokenSymbolMetadata( "chain", "symbol", "options") Returns metadata (name, symbol, decimals, logo) for a given symbol
=Moralis_GetTokenAddressPrice( "chain", "token_address", "options") Returns the price nominated in the native token and usd for a given token contract address.
=Moralis_GetTokenAddressTransactions( "chain", "token_address", "options") Gets ERC20 token contract transactions in descending order based on block number
=Moralis_GetTokenAddressAllowance( "chain", "token_address", "owner_address", "spender_address", "options") Gets the amount which the spender is allowed to withdraw from the spender
=Moralis_GetNFTSearch( "chain", "query", "options") Gets NFTs that match a given metadata search.
=Moralis_GetContractNFTs( "chain", "contract_address", "options") Gets data, including metadata (where available), for all token ids for the given contract address.
=Moralis_GetContractNFTTransfers( "chain", "contract_address", "options") Gets the transfers of the tokens matching the given parameters
Developers can review the official Moralis Documentation πŸ“–
Missing a formula? Suggest one here πŸ’‘
Note that "options" are optional, other variables are required πŸ‘

Navigation

Page
πŸš€ Quick Start​
60 second getting started guide.
​❓ FAQ​
Answers to frequently asked SheetLink questions.
πŸ› οΈ Functions​
Powerful functions unique to SheetLink.
πŸ’ͺ "options"​
Control the request to and response from any application.

πŸš‘ Need Help?

You can always contact us via [email protected] or by messaging us on Twitter @SheetLink​