# Weather app with just Google Sheet Formula! **URL:** \ **Category:** Ask for Help\ **Created:** [June 25, 2020, 7:45pm UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444 "2020-06-25T19:45:03Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Erni\_D](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erni_d/32/9023_2.png) [@Erni\_D](https://community.glideapps.com/u/Erni_D)\ **Post date:** [June 25, 2020, 7:45pm UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/1 "2020-06-25T19:45:03Z")
So I came across here various topics about a weather app, but all of the cases use the script magic or Zapier, I been searching the web and found a way to make it work fetching the info from a website using pure formulas . I’m new to glide, so im reaching to you to make it work in any place, country, city. Hope it help’s others in then community. All you need its the city and the date and it will give you weather, temperature, comfort feels, wind and humidity. > =Query(IMPORTHTML(“[https://www.timeanddate.com/weather/usa/“&If(Counta(split(A1,”](https://www.timeanddate.com/weather/usa/%22&If(Counta(split(A1,%22) “))=2,lower(split(A1,” “))&”-”&index(lower(split(A1," “)),1,2),lower(split(A1,” “)))&”/ext",“table”,1)," select Col3,Col4,Col5,Col6,Col8 where Col1=‘“&text(A2,“DDD”)&Char(10)&text(A2,“MMM”)&” “&INDEX(split(A2,”/“),1,2)&”’ ",2) result: ![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/ce93af57d57ae2aee8f99002726e6dc389f740ca.jpeg) ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [June 25, 2020, 8:00pm UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/2 "2020-06-25T20:00:46Z")
Wow! Thank you for sharing this with us! 😀 ---
**Author:** ![Erni\_D](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erni_d/32/9023_2.png) [@Erni\_D](https://community.glideapps.com/u/Erni_D)\ **Post date:** [June 25, 2020, 8:05pm UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/3 "2020-06-25T20:05:59Z")
Just trying to create one for my self but this surpasses my knowledge. Looking forward to see how this works for your multiple feature apps! 😉 ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [June 25, 2020, 8:08pm UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/4 "2020-06-25T20:08:05Z")
Actually, this I could just paste in a column next to the addresses…You have given me ideas! 😀 🙃 ---
**Author:** ![Glider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glider/32/9699_2.png) [@Glider](https://community.glideapps.com/u/Glider)\ **Post date:** [June 25, 2020, 8:24pm UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/5 "2020-06-25T20:24:57Z")
the formula is missing a bracket ---
**Author:** ![Erni\_D](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erni_d/32/9023_2.png) [@Erni\_D](https://community.glideapps.com/u/Erni_D)\ **Post date:** [June 25, 2020, 8:41pm UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/6 "2020-06-25T20:41:03Z")
It work it for me. Let me check and edit! ---
**Author:** ![Ed\_Pietrzak](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ed_pietrzak/32/9216_2.png) [@Ed\_Pietrzak](https://community.glideapps.com/u/Ed_Pietrzak)\ **Post date:** [June 25, 2020, 8:48pm UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/7 "2020-06-25T20:48:11Z")
> [@Erni\_D](#): > > =Query(IMPORTHTML(“[[https://www.timeanddate.com/weather/usa/“&If(Counta(split(A1,”](https://www.timeanddate.com/weather/usa/%22&If(Counta(split(A1,%22) ]([https://www.timeanddate.com/weather/usa/“&If(Counta(split(A1,”)](https://www.timeanddate.com/weather/usa/%22&If(Counta(split(A1,%22)) “))=2,lower(split(A1,” “))&”-”&index(lower(split(A1," “)),1,2),lower(split(A1,” “)))&”/ext",“table”,1)," select Col3,Col4,Col5,Col6,Col8 where Col1=’“&text(A2,“DDD”)&Char(10)&text(A2,“MMM”)&” “&INDEX(split(A2,”/“),1,2)&”’ ",2) I also received an error regarding number of arguments… Where do you put the location in the above formula? ---
**Author:** ![Erni\_D](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erni_d/32/9023_2.png) [@Erni\_D](https://community.glideapps.com/u/Erni_D)\ **Post date:** [June 25, 2020, 9:11pm UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/8 "2020-06-25T21:11:49Z")
check the picture, You put in A1 city and A2 the date, it works for me but need it for other country! the formula is in A3 as in the picture ---
**Author:** ![Ed\_Pietrzak](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ed_pietrzak/32/9216_2.png) [@Ed\_Pietrzak](https://community.glideapps.com/u/Ed_Pietrzak)\ **Post date:** [June 25, 2020, 9:15pm UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/9 "2020-06-25T21:15:56Z")
> [@Erni\_D](#): > > =Query(IMPORTHTML(“[[https://www.timeanddate.com/weather/usa/“&If(Counta(split(A1,”](https://www.timeanddate.com/weather/usa/%22&If(Counta(split(A1,%22) ]([https://www.timeanddate.com/weather/usa/“&If(Counta(split(A1,”)](https://www.timeanddate.com/weather/usa/%22&If(Counta(split(A1,%22)) “))=2,lower(split(A1,” “))&”-”&index(lower(split(A1," “)),1,2),lower(split(A1,” “)))&”/ext",“table”,1)," select Col3,Col4,Col5,Col6,Col8 where Col1=’“&text(A2,“DDD”)&Char(10)&text(A2,“MMM”)&” “&INDEX(split(A2,”/“),1,2)&”’ ",2) Thanks. It’s giving me a parse error for some reason. I even put your City and Date in. I’ll look more at it later. Have some ideas! ---
**Author:** ![Erni\_D](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erni_d/32/9023_2.png) [@Erni\_D](https://community.glideapps.com/u/Erni_D)\ **Post date:** [June 25, 2020, 9:21pm UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/10 "2020-06-25T21:21:54Z")
I’ll make a public copy later to everyone check it out! Maybe somebody can make it work for what I’m aiming for! ---
**Author:** ![Glider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glider/32/9699_2.png) [@Glider](https://community.glideapps.com/u/Glider)\ **Post date:** [June 25, 2020, 9:23pm UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/11 "2020-06-25T21:23:12Z")
problem solved ---
**Author:** ![Erni\_D](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erni_d/32/9023_2.png) [@Erni\_D](https://community.glideapps.com/u/Erni_D)\ **Post date:** [June 25, 2020, 9:28pm UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/12 "2020-06-25T21:28:10Z")
As I’m reading if you need to fetch info from another city you need to first check in the webpage if it does exist and how the page get it. I’ll be working on this for today! Hopefully some body can give a hand! Cheers mate ---
**Author:** ![Erni\_D](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erni_d/32/9023_2.png) [@Erni\_D](https://community.glideapps.com/u/Erni_D)\ **Post date:** [June 26, 2020, 12:40am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/13 "2020-06-26T00:40:13Z")
found a way to fetch from a zip code, same rows in the sheet as in first way I shared! > =Query(IMPORTHTML(“[https://www.timeanddate.com/weather/@z-us-“&A1&”/ext",“table”,1),"](https://www.timeanddate.com/weather/@z-us-%22&A1&%22/ext%22,%22table%22,1),%22) select Col3,Col4,Col5,Col6,Col8 where Col1='”&text(A2,“DDD”)&Char(10)&text(A2,“MMM”)&" “&INDEX(split(A2,”/“),1,2)&”’ ",2) ---
**Author:** ![Erni\_D](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erni_d/32/9023_2.png) [@Erni\_D](https://community.glideapps.com/u/Erni_D)\ **Post date:** [June 26, 2020, 12:50am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/14 "2020-06-26T00:50:29Z")
found a way to change from Celsius to Fahrenheit or kelvin! at the end of the URL higligthed **like this** you need to change it for the unit you need > ?fut=1 for C > ?fut=2 for F > ?fut=3 for kelvin =Query(IMPORTHTML(“[https://www.timeanddate.com/weather/canada/“&If(Counta(split(A1,”](https://www.timeanddate.com/weather/canada/%22&If(Counta(split(A1,%22) “))=2,lower(split(A1,” “))&”-”&index(lower(split(A1," “)),1,2),lower(split(A1,” “)))&”/ext **?fut=1** “,“table”,1),” select Col3,Col4,Col5,Col6,Col8 where Col1=‘“&text(A2,“DDD”)&Char(10)&text(A2,“MMM”)&” “&index(split(A2,”/“),1,2)&”’ ",2) ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [June 26, 2020, 12:52am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/15 "2020-06-26T00:52:27Z")
I tried your formula…couldn’t get it to work…Im sure I messed it up somewhere when I did the copy/paste…Im going to try it again later. ---
**Author:** ![Ed\_Pietrzak](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ed_pietrzak/32/9216_2.png) [@Ed\_Pietrzak](https://community.glideapps.com/u/Ed_Pietrzak)\ **Post date:** [June 26, 2020, 1:07am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/16 "2020-06-26T01:07:12Z")
I am still getting the PARSE error. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/67d1477c08ea6d27c08c9e1a1ce0bf9941a1230b.png) And this is the formula I put in. =Query(IMPORTHTML(“[https://www.timeanddate.com/weather/usa/"&If(Counta(split(A1,"](https://www.timeanddate.com/weather/usa/%22&If(Counta(split(A1,%22) 2 “))=2,lower(split(A1,” “))&”-”&index(lower(split(A1," “)),1,2),lower(split(A1,” “)))&”/ext",“table”,1)," select Col3,Col4,Col5,Col6,Col8 where Col1=’"&text(A2,“DDD”)&Char(10)&text(A2,“MMM”)&" “&INDEX(split(A2,”/"),1,2)&"’ ",2) Thoughts? ---
**Author:** ![Erni\_D](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erni_d/32/9023_2.png) [@Erni\_D](https://community.glideapps.com/u/Erni_D)\ **Post date:** [June 26, 2020, 1:19am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/17 "2020-06-26T01:19:24Z")
Sorry!, here is the shared sheet to copy I will add the other examples 2 > [weather app shared - Google Sheets](https://docs.google.com/spreadsheets/d/1XaMqf-KJWvXi5Oijdbqz-qV5XuXHlaa_cDWm8YPPeKk/edit?usp=sharing) ---
**Author:** ![Erni\_D](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erni_d/32/9023_2.png) [@Erni\_D](https://community.glideapps.com/u/Erni_D)\ **Post date:** [June 26, 2020, 1:27am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/18 "2020-06-26T01:27:53Z")
Here its the shared sheet to see it in action! errors fixed > [@Erni\_D](#): > > Sorry!, here is the shared sheet to copy I will add the other examples 2 > > > [weather app shared - Google Sheets](https://docs.google.com/spreadsheets/d/1XaMqf-KJWvXi5Oijdbqz-qV5XuXHlaa_cDWm8YPPeKk/edit?usp=sharing) ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [June 26, 2020, 1:30am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/19 "2020-06-26T01:30:03Z")
Thank you!!! 😀 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 26, 2020, 1:31am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/20 "2020-06-26T01:31:48Z")
Thank you for the share, I see you have solved the problem. However I had so many problems using Google Sheet’s import functions whether it be HTML, Feed or XML. It can break down any time and the update time is slow as well, especially for feeds so I don’t use them anymore. [Next page](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444.md?page=2)