# 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:** 19\ **Page:** 3
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [July 5, 2020, 1:50am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/41 "2020-07-05T01:50:30Z")
Hey @ThinhDinh I changed it and it gives me a different error. Thanks, ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/53263a238789de0230ab11d8a6b5a0b81f3513bc.png) ---
**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:** [July 5, 2020, 1:57am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/42 "2020-07-05T01:57:17Z")
It should be “var url = …” instead of “var url ;” ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [July 5, 2020, 1:59am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/43 "2020-07-05T01:59:27Z")
I am sorry @ThinhDinh, I am not a formula or code kinda guy. It’s giving me another error: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1e17150ef1dad50ebabb6a49bdedb7859208c974.png) ---
**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:** [July 5, 2020, 2:05am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/44 "2020-07-05T02:05:15Z")
You missed that equal sign, make it the same as the below rows. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/7764e2fc5b78392e2c4036fe9c99c5d8606bb814.png) ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [July 5, 2020, 2:07am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/45 "2020-07-05T02:07:11Z")
Santiago, It should be: `var url = “http........”` ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [July 5, 2020, 2:09am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/46 "2020-07-05T02:09:08Z")
Thanks to you both @ThinhDinh @gvalero It is working now but I don’t think it’s actually showing anything weather related. ---
**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:** [July 5, 2020, 2:10am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/47 "2020-07-05T02:10:51Z")
I think there’s a further typo in that URL. It should be “encodeURL” instead of “encodeURI” isn’t it? What is it returning? ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [July 5, 2020, 2:12am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/48 "2020-07-05T02:12:43Z")
It’s showing an error in the workbook saying that I did not enter the API which I did input. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/e0ac9c244642dd2a98572afe55d7a6360b2477c1.png) ---
**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:** [July 5, 2020, 2:14am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/49 "2020-07-05T02:14:34Z")
Did you provide the right details in the right cells for the “weather” sheet? Did you run the script while you are opening the “weather” sheet? ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [July 5, 2020, 2:15am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/50 "2020-07-05T02:15:56Z")
Yes, to both. I have checked it several times and it seems that I have everything where it needs to go. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/0a3f70ced3dbb5c29dbf3393cd5f20ebe7f35e78.png) ---
**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:** [July 5, 2020, 2:19am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/51 "2020-07-05T02:19:25Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/0e187631b8ec1a9a8e80a977b426bfcdba7c54c7.png) From the image they have on the site, it seems that your code has not been put the right way in the URL. That encodeURI (or URL, whatever) should be showed as black text. ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [July 5, 2020, 2:32am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/52 "2020-07-05T02:32:43Z")
I am hitting a Big wall here. According to the directions they have, I am supposed to put the API in Cell A5. I have not idea where or how to add the URL/URI. ---
**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:** [July 5, 2020, 2:38am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/53 "2020-07-05T02:38:25Z")
I don’t think there are any other wrong things except your format of the URL. See what they did with the “encodeURI” part, it’s not inside quotation marks. Do just like them and I think you’ll be fine. ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [July 5, 2020, 2:42am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/54 "2020-07-05T02:42:11Z")
Thank you @ThinhDinh, It is working now. I really appreciate it! ---
**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:** [July 5, 2020, 2:42am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/55 "2020-07-05T02:42:34Z")
Ha, finally it works 😅 ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 5, 2020, 3:56am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/56 "2020-07-05T03:56:44Z")
![programming-is-like-writing-a-book-except-when-you-miss-61415328](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f4665700b10527b76b7e1c831a20c8a37dddac7c.png) ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [July 5, 2020, 4:08am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/57 "2020-07-05T04:08:12Z")
Totally I agree! 😂 ---
**Author:** ![Fashion\_Forecast](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fashion_forecast/32/7692_2.png) [@Fashion\_Forecast](https://community.glideapps.com/u/Fashion_Forecast)\ **Post date:** [January 29, 2021, 7:08pm UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/58 "2021-01-29T19:08:55Z")
I would appreciate if you all would UPLIKE this daily weather widget request I submitted to Glide! The more votes the more likely they’ll put it on as a feature! THANKS! [GLIDE WEATHER FEATURE REQUEST LINK](https://features.staging.glideapp.io/dl/ewAiAHQAIgA6ADMALAAiAHMAIgA6ACIAYwBsAGEAcwBzAC0ARgBlAGEAdAB1AHIAZQBzACIALAAiAHIAIgA6ACIAVABuAC4AeQBZAHIAZABVAFMAQQB1AHQARABEAEMANABwAE8AcAA3AGUAUQAiACwAIgBuACIAOgAiAEQAYQBpAGwAeQAgAFcAZQBhAHQAaABlAHIAIABXAGkAZABnAGUAdAAiAH0A) ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:53pm UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/59 "2024-01-17T16:53:39Z")
[Previous page](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444.md?page=2)