Google Sheet use Importxml error could not fetch url [duplicate]

by
  • You want to retrieve the price like 55,500₽ from the URL of https://tarkov-market.com/item/Pack_of_sugar and put to a cell on Google Spreadsheet.

I could understand like this. If my understanding is correct, how about this answer?

Issue and workaround:

Unfortunately, IMPORTXML cannot be used for this situation. Because IMPORTXML is used like =IMPORTXML("https://tarkov-market.com/item/Pack_of_sugar","//*"), an error like the value cannot be retrieved from the URL occurs. So in this case, as a workaround, I would like to propose to use Google Apps Script as a custom function. When Google Apps Script is used, the value can be retrieved.

Sample script:

Please copy and paste the following script to the container-bound script of the Spreadsheet. And please put =sampleFormula() to a cell. By this, the value can be put to the cell.

function sampleFormula() {
  const url = "https://tarkov-market.com/item/Pack_of_sugar";
  const html = UrlFetchApp.fetch(url).getContentText();
  return html.match(/price:(.+?)<\/title>/)[1].trim();
}

Result:

enter image description here

Note:

  • This script is for your question. So when this script is used for other URL and scenes, an error might occur. Please be careful this.

References:

More Related Contents:

  1. Is there a way to evaluate a formula that is stored in a cell?
  2. No permission to call msgBox in Google Apps Scripting
  3. Apps Script: how to get hyperlink from a cell where there is no formula
  4. Periodically refresh IMPORTXML() spreadsheet function
  5. Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
  6. Selecting the last value of a column
  7. Using built-in spreadsheet functions in a script
  8. TypeError: Cannot read property ‘getRange’ of null (line 6, file “Code”) in google sheet script [duplicate]
  9. How to create INDIRECT array string of multiple sheet references in Google Sheets?
  10. How to protect the Apps Script code in a Google spreadsheet?
  11. Automatic timestamp when a cell is filled out
  12. Script to Change Row Color when a cell changes text
  13. Sheet.getRange(1,1,1,12) what does the numbers in bracket specify?
  14. You do not have permission to call openById
  15. Google Apps Script, copy one spreadsheet to another spreadsheet with formatting
  16. Single Google Form for multiple Sheets [duplicate]
  17. How do I communicate a page(modal dialog) with its sibling (sidebar)?
  18. How to replace text in Google Spreadsheet using App Scripts?
  19. copy data from one sheet to another in google app script and append a row, one small issue
  20. Google App Scripts cannot be given Authorization or Permission
  21. Google Apps Script: Dynamically creating spreadsheet menu items
  22. Increment Cell value by one by clicking
  23. Apply multiple font colors to the text in a single Google Sheets cell
  24. How to evaluate a spreadsheet formula within a custom function?
  25. Determine current user in Apps Script
  26. How to ignore empty cell values for getRange().getValues()
  27. Use script in all spreadsheets
  28. Custom Functions and Recalculation
  29. Can the google spreadsheet ‘query’ function be used in google apps script?
  30. google script openById : You do not have permission to perform that action

Leave a Comment