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

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 … Read more

Difference between two dates expressed as years, months, days (in one column)

=IF(DATEDIF(A1, B1, “D”)>365, QUOTIENT(DATEDIF(A1, B1, “D”), 365)&” year(s) “& QUOTIENT(MOD(DATEDIF(A1, B1, “D”), 365), 30)&” month(s) “& MOD(QUOTIENT(MOD(DATEDIF(A1, B1, “D”), 365), 30), 30)&” day(s)”, IF(DATEDIF(A1, B1, “D”)>30, QUOTIENT(DATEDIF(A1, B1, “D”), 30)&” month(s) “& MOD(DATEDIF(A1, B1, “D”), 30)&” day(s)”, DATEDIF(A1, B1, “D”)&” day(s)”))

Protect ranges with google apps script

Yes, you can accomplish this using the Protection class. You would first protect the whole sheet using var protection = sheet.protect(), then unprotect the ranges you want people to be able to edit using protection.setUnprotectedRanges([ranges]), where [ranges] is an array of range objects. You can read more about it in the Google Apps Script Class … Read more

How to evaluate a spreadsheet formula within a custom function?

Spreadsheet functions from Apps-Script Not possible – This has been asked many times. Suggest you check the google-apps-script issue list to see if anything has changed. But last I checked, there is no way to do it, and they have no plan to add it. https://code.google.com/p/google-apps-script-issues/issues/list Ethercalc – java script spreadsheet formulas If you need … Read more

To exceed the ImportXML limit on Google Spreadsheet

I created a custom import function that overcomes all limits of IMPORTXML I have a sheet using this in about 800 cells and it works great. It makes use of Google Sheet’s custom scripts (Tools > Script editor…) and searches through content using regex instead of xpath. function importRegex(url, regexInput) { var output=””; var fetchedUrl … Read more

Create Spreadsheet using Google Spreadsheet API in Google drive in Java

I finally with help from here managed to create such connection. Everything is working as before. Steps You have to do is: Register at https://console.developers.google.com Create new project Under APIs & Auth -> Credential -> Create New Client ID for Service Account When the Client ID is generated You have to generate P12 key. Client … Read more

SUMIFS function in Google Spreadsheet

The simplest way to easily make SumIFS-like functions in my opinion is to combine the FILTER and SUM function. SUM(FILTER(sourceArray, arrayCondition_1, arrayCondition_2, …, arrayCondition_30)) For example: SUM(FILTER(A1:A10;A1:A10>5;B1:B10=1) Explanation: the FILTER() filters the rows in A1:A10 where A1:A10 > 5 and B1:B10 = 1. Then SUM() sums the values of those cells. This approach is very … Read more