Skip to content

Latest commit

 

History

History
19 lines (13 loc) · 608 Bytes

README.md

File metadata and controls

19 lines (13 loc) · 608 Bytes
Raw

CoinMarketCap to Google Sheet

Script for loading data from https://coinmarketcap.com to google sheet.

How to set-up:

  1. Create new Google sheet file.
  2. Rename the sheet for data to cryptodata.
  3. Run Tools - Script editor...

Script Editor

  1. Insert the code from cmc.gs file.
  2. Change the line: 'X-CMC_PRO_API_KEY': 'INSERT-YOUR-FREE-API-KEY-HERE' (get free API key here: https://coinmarketcap.com/api )
  3. Select getCoinData function and test run.

getCoinData function

  1. Check your cryptodata sheet.

Use within your sheet by creating button with script.