Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Within a Google Docs spreadsheet, I need to access external data that requires basic authentication. Usually I would include external data by putting this in a cell:

=ImportHtml("http://somedomain.com/somepath", "table", 0)

For basic auth, I have tried a standard URL with credentials:

=ImportHtml("http://user:pass@somedomain.com/somepath", "table", 0)

Google responds with the following:

error: Data temporarily unavailable

Is there any way to use basic auth-protected resources in a Google spreadsheet?

share|improve this question
up vote 1 down vote accepted

ImportHTML does not support authentication. The data has to be publicly available for you to use this function.

This applies to ImportXML & ImportFeed also.

share|improve this answer

You can use import.io. They have a feature called authenticated extractor. It creates an API from the page and provides you the code to ping it from the sheet.

share|improve this answer
Could you point to documentation on this? I installed the import.io app, accessed an authenticated page, but I got the error "The API failed to publish." Either way it's not clear to me where the Google sheets code is provided. – glenviewjeff Aug 2 '15 at 2:14

I'm looking for some solution here too. Have yet to investigate this enough but perhaps: https://developers.google.com/secure-data-connector/docs/1.3/tutorials/spreadsheets

share|improve this answer
The secure data connector is only useful for documents you have behind a firewall. That won't get you around a normal HTTP request with basic auth. – Brad Nov 5 '13 at 1:05

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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