Home > front end >  Returning value of an item price in google sheets
Returning value of an item price in google sheets

Time:02-21

I'm trying add easy updating prices into a google sheet. I need the market price from

//*[@id="app"]/div/section[2]/section/div[1]/section[3]/div/section[1]/ul/li[1]/span[2]

enter image description here

Note:

  • The value from the URL is JSON data. In this case, the following custom function can be also used. In this case, please copy and paste the following script to the script editor of Spreadsheet and save the script. And please put a custom function of =SAMPLE("url") to a cell.

      const SAMPLE = url => JSON.parse(UrlFetchApp.fetch(url).getContentText()).marketPrice;
    

References:

  • enter image description here

  • Related