We are building a set of tools to support our operations. This repo is where we will release a collection of free scripts which will enable you to plug data into Google Sheets (using Apps Scripts) from common Web3 marketplace API endpoints using custom sheet functions, hopefully, to support your informed decision-making with respect to listed NFT collections:
- Return collection stats from the OpenSea API (without an API key) - makes use of eighteen custom functions to return everything from collection floor prices to 30-day volumes1.
- Return collection stats from the LooksRare API (without an API key) - this basic implementation only returns floor price by use of a custom function1.
- Return collection stats from the public M 5AFA agicEden API - implemented in four custom functions returning everything from floor price to collection listed count1.
- Return exchange rates for Eth, Matic, SCRT, and Sol vs USD and GBP using the public CoinGecko API - can easily be extended to support other currencies and tokens by changing the base URL1.