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]
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;