Skip to content

Instantly share code, notes, and snippets.

saibakatar / Coinmarketcap API
Created March 4, 2021 10:41 — forked from erajanraja24/Coinmarketcap API
Configure Coinmarketcap API on Google sheets
function getCryptoPrice() {
var sh1=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");
var sh2=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet2");
//Make sure that you got the API key from Coinmarketcap API dashboard and paste it in sheet_1 on cell B1
var apiKey=sh1.getRange(1, 2).getValue();
var url=""
var requestOptions = {
method: 'GET',