CODEWITHSUNDEEP
google-sheetsformulaweather
Patchhr33
Patchhr33

Reputation: 3

Have a cell report weather for specific date in google sheets

Hello trying to create a sheet where A1 contains a date B1 Contains a zipcode and C1 reports the temp for said zipcode on the date in A1. I have tried the following

=Query(IMPORTHTML("https://www.timeanddate.com/weather/@z-us-"&A1&"/ext","table",1),"SELECT Col3, Col4, Col5, Col6, Col8 WHERE Col1='"&TEXT(B1,"ddd MMM DD YYYY")&"'", 2)

But sadly I cant get it to work. Would greatly appreciate any help

Upvotes: 0

Views: 147

Answers (1)

horanimal
horanimal

Reputation: 434

Looks like TimeAndDate.com does not allow programmatic access via the IMPORTHTML() function.

As you can see below, even attempting to pull a hard-coded URL that we’ve confirmed is valid we still get the “Could not fetch url:… error.

enter image description here

Upvotes: 0

Related Questions