Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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

2 Answers 2

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

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.