This repo is built to create a collection of Google Apps Scripts using Spreadsheet that help you with Cryptocurrencies.
This is script let you update the current price column of your sheet.
How to use it?
-
You need a API key to get coinmarketcap data, get it here: https://coinmarketcap.com/api/
-
Add the key in the script file. Go to the Spreadsheet menu: Extensions > App Script, copy and paste the script here and update the APIKey
-
Remeber to have in your Spreadsheet the following columns: Column A from row 2: token symbol (BTC, ETH, DOT, ...) Column B is for the price
...and enjoy! any suggestions send me an email: diego@infinitelabs.co