ImportXML

function PICto()
{
 var sheet = SpreadsheetApp.openById("1PcaHAZIcHlnC_IY4EjNOPo-3lrDV5zMcHOzmSDsVQaE");
 var namesheet = sheet.getSheetByName("coffe");
 namesheet.getRange("B2").copyTo(namesheet.getRange("B3"), {contentsOnly: true}); //valor anterior
 namesheet.getRange("B2").clearContent().getValues();
 namesheet.getRange("B4").clearContent().getValues();
  namesheet.getRange("B2").setValue('TEXTO');
 Utilities.sleep(2000);
namesheet.getRange("B2")
.setFormula('=importxml("https://www.investing.com/commodities/us-coffee-c","//*[@id=""last_last""]")');
Utilities.sleep(2000);
namesheet.getRange("B2").copyTo(namesheet.getRange("B4"));
//copia y luego salva los cambios
var id1 = '2';
var id2 = '3';
var info1 = coffextrac(id1, 2); //columna B3
var info2 = coffextrac(id2, 2); //columna B4


 if(info2 > info1)
  {
    namesheet.getRange("C9").setValue('ES MAYOR');
     namesheet.getRange("C10").setValue(new Date());
     var prices = "🔺 Price US Coffe$ : "+info2;
     var url1 = telegramUrl + "/sendMessage?chat_id=" + "@pricecafenotify" + "&text="+ prices ; //funcion escribe en un canal.
     var response = UrlFetchApp.fetch(url1);
     namesheet.getRange("B3").clearContent().getValues(); //limpia valor anterior
}else if(info2 < info1) {
 namesheet.getRange("C9").setValue('ES MENOR');
 namesheet.getRange("C10").setValue(new Date());
var prices = "🔻 Price US Coffe$ : "+info2;

var dataextr = "Fuente: " +"https://www.investing.com/commodities/us-coffee-c";

var url1 = telegramUrl + "/sendMessage?chat_id=" + "@pricecafenotify" + "&text="+ prices ; //funcion escribe en un canal.

var response = UrlFetchApp.fetch(url1);
namesheet.getRange("B3").clearContent().getValues(); //limpia valor anterior
} else if(info2 == info1) {
 namesheet.getRange("C9").setValue('ES IGUAL');
 namesheet.getRange("C10").setValue(new Date());
namesheet.getRange("B3").clearContent().getValues(); //limpia valor anterior

//pricecafenotify
//esetests
}else if(info2=='#N/A'){
 namesheet.getRange("C9").setValue('ES DIFERENTE');
 namesheet.getRange("C10").setValue(new Date());

namesheet.getRange("B3").clearContent().getValues(); //limpia valor anterior
}

}