lcw-api-google-sheets.js

function run() {
  var response = UrlFetchApp.fetch('https://api.livecoinwatch.com/coins/single', {
    'method': 'post',
    'headers': {
      'Content-type': 'application/json; charset=UTF-8',
      'x-api-key': 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx',
    },
    'payload': JSON.stringify({
      "currency": 'USD',
      "code": 'ETH',
      "meta": true,
    }),
  });

  var json = JSON.parse(response.getContentText());
  SpreadsheetApp.getActiveSheet().getRange('A1').setValue(json.name);
  SpreadsheetApp.getActiveSheet().getRange('B1').setValue(json.rate);
}