Auto-refresh Crypto Coins in Google Sheets

Description

The Google Sheets integration allows users to get the Crypto Coins data completely without a maximum of 250 coins per page limited by Coingecko API.

The script is readily available to pull the price section for all your listed coins in Google Sheets. The script requires setting trigger to the function for 5 mins intervals.
The pricing and other info of the coins will be updated automatically. However, due to the free API limitation, the complete updated information for all the coins might take longer intervals than 5mins (10mins or more depending on API restriction).
Users will only need to use the VLOOKUP formula in Google Sheets to pull the data to any cell they wish. Users can use either formula (less recommended) or page update script (recommended) to pull the data.

You can refer to the FREE version of the App Script with steps to use it in Google Sheets: //github.com/Cre8tiveNow/sheets-crypto.

If you need our support to perform script installation, we’ll charge $50 per project. $100 will be charged if you require script customization and if it can be completed within a day.

Sample Spreadsheet that you can get:-

• Coin Pricing & History: //docs.google.com/spreadsheets/d/1Pmn_zZGuKOG3kUTxAXnChT94XiQ6mruhbaMOQDYGJzk/edit?usp=sharing

• Market Cap & OHCL: //docs.google.com/spreadsheets/d/12lVpziDj36LMY9w5xHyFkNlOqXId4jJ05lT_GXQxo7M/edit?usp=sharing