I'm getting the error below:

enter image description here

Here is my script:

function getCoinData() {
  var queryString = Math.random();

  var getCoin = "/html/body/div[1]/div/div/div/div[2]/main/div/div[1]/div[2]/div[1]/span";
  var Dolar = '=IMPORTXML("'   'https://br.investing.com/currencies/usd-brl'   '?'   queryString   '";"'  getCoin   '")';
  var Euro = '=IMPORTXML("'   'https://br.investing.com/currencies/eur-brl'   '?'   queryString   '";"'  getCoin   '")';
  var Bitcoin = '=IMPORTXML("'   'https://br.investing.com/indices/investing.com-btc-brl'   '?'   queryString   '";"'  getCoin   '")';
  
  SpreadsheetApp.getActiveSheet().getRange('D2').setValue(Dolar);
  SpreadsheetApp.getActiveSheet().getRange('D3').setValue(Euro);
  SpreadsheetApp.getActiveSheet().getRange('D4').setValue(Bitcoin);
}

CodePudding user response：

Problem solved! The code I used was:

function GetCoinTriggers() {
ScriptApp.newTrigger('getCoinData')
  .timeBased()
  .everyHours(4)
  .create();
}

Thanks guys!