I am trying to fetch url using =importxml in Google Sheets, but getting error message, could not connect to url.

He is the formula which I am using:


Ultimately I want to fetch "Status" from this URL.

Any idea how to correct this?


IMPORTXML only is able to access public web resources but he URL in the formula requires user and password so it couldn't be reached.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.