Google Sheets Apps Script function to get the current price of Gold from goldapi.io

gistfile1.txt

function getGoldPrice() {
  const accessToken = 'goldapi-XXXXXXXXXXXXXXX-io';

  const headers = {
    'x-access-token': accessToken,
    'Content-Type': 'application/json'
  };

  const options = {
    'method' : 'get',
    'headers': headers,
    'muteHttpExceptions': true
  };

  const response = UrlFetchApp.fetch("https://www.goldapi.io/api/XAU/USD", options);
  const json = JSON.parse(response.getContentText());

  const price = json.price || "Price not found";

  Logger.log("Current Gold Price: " + price);

  return price;
}