Google Sheets – ImportHtml() with Basic Auth

google sheetsimporthtml

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?

Best Answer

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

This applies to ImportXML & ImportFeed also.

Related Solutions

Google-sheets – Including option descriptions for a Google Docs Spreadsheet form

I'm afraid your only choice is rephrasing so that the right answer is obvious:

What would you like to get the game from?

This affects the way we reimburse you. If you'd like to get the game through Steam, we'll simply gift it to you. If you'd like to get the game through Amazon, we'll try and get you a gift card for the same amount of money. Otherwise, you'll need to send us a scan of the receipt and we'll reimburse you through PayPal and Moneybookers.

( ) Steam
( ) Amazon
( ) Other

Google-sheets – ImportHTML spreadsheet function to update every 5 mins

UNTESTED (because for example the Nairobi Stock Exchange is closed at present) but

& year(now()) & month(now()) & day(now()) & hour(now()) & MINUTE(),

& A1,

with =int(minute(now())/5) in A1 may be worth trying.

Best Answer

Related Solutions

Google-sheets – Including option descriptions for a Google Docs Spreadsheet form

What would you like to get the game from?

Google-sheets – ImportHTML spreadsheet function to update every 5 mins

Related Topic