# 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:** 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, 1:35am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/21 "2020-06-26T01:35:02Z")
The load time is very slow…and also showing as an error on the sheet. ---
**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:35am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/22 "2020-06-26T01:35:33Z")
what would be a better solution, @ThinhDinh ? all the scripts I have found requiere a lot of data in others sheet to function, can you point me to a better way? really need help in this one! ---
**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:36am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/23 "2020-06-26T01:36:01Z")
Lets see what we can do! ---
**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:36am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/24 "2020-06-26T01:36:45Z")
It’s not for your case, but if I need data from other sources I would rather use an API connector or if it constantly needs to be updated then my Python coding (disclaimer: doesn’t work with cases where you need to interact with user’s input). ---
**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:38am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/25 "2020-06-26T01:38:48Z")
its for places in a list, it doesn’t need user input, just for information purposes ---
**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:42am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/26 "2020-06-26T01:42:12Z")
Another tip might be to just pull Google weather and set it to web view. But I wouldn’t be very happy with that myself. Let me see if I can come up with something seeing as its important for Erni\_D. ---
**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:43am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/27 "2020-06-26T01:43:52Z")
Got it. The issue was when I pasted the code, the double and single quotes were different and not being recognized as part of the code. ---
**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:44am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/28 "2020-06-26T01:44:34Z")
Happy to see it worked for you! Cheers mate! ---
**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:47am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/29 "2020-06-26T01:47:03Z")
Maybe that’s what i didn’t check. ---
**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:49am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/30 "2020-06-26T01:49:37Z")
Diferentes language settings in Google Sheets have different ways to display de " double or single ’ the same goes for ; and , Sorry I didn’t clarify this. ---
**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:54am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/31 "2020-06-26T01:54:47Z")
Actually Jeff told me about this a long time ago. ---
**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, 2:56pm UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/32 "2020-06-26T14:56:55Z")
One of the ideas that I had for this was to pre-populate a form field. For example, the temperature was XX degrees when this was submitted. The issue that I am running into is that if I select the space where the current temp is, when I submit the form it wants to write back to that space. So I need it to pull from one cell and write to another. Any suggestions would be extremely helpful. ---
**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:** [June 26, 2020, 3:17pm UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/33 "2020-06-26T15:17:21Z")
A form shouldn’t be overwriting anything as it only writes new rows to any sheet you choose. Are you sure you are using a form? In a form you can use the column values to write values from the screen you are viewing. You can see these values under add components once you click on the form button. ---
**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, 4:18pm UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/34 "2020-06-26T16:18:50Z")
Thanks. I’ll play around with it more. I think I know what my issue was, but may reach out to you once I dig deeper. ---
**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, 8:27pm UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/35 "2020-06-26T20:27:01Z")
> **[Create a weather widget using Google Sheets](https://support.geckoboard.com/hc/en-us/articles/208314537-Create-a-weather-widget-using-Google-Sheets)** > > To create a weather widget using Google Sheets, follow these steps: > > > Sign up for a free weatherstack account > Make your own copy of this Google Sheet template. > On cell A2, enter your city as "... Hope this helps - Just create a free account copy/paste sheet. This is probably a better option than the one you’re using at the moment. ---
**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, 12:48am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/36 "2020-07-05T00:48:44Z")
Hey @Wiz.Wazeer, I just tried this. I followed all the steps as shown but the system says: ReferenceError: “url” is not defined. (line 7, file “Code”) Dismiss Do you know how to fix it? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/9f0cfdcf201e30030d1690d9d5a7c0e11301b652.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, 12:52am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/37 "2020-07-05T00:52:36Z")
Hey @Erni_D, I am using your GS with the City but I am not sure if it is actually referring to the city that I want. How can I make it to where it shows city, state as in Tyler, TX? Thanks, P.S. I am really new to these formulas so I am learning as fast as I can. ---
**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, 12:55am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/38 "2020-07-05T00:55:04Z")
Where did you get this script from? Can I get the original source? ---
**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, 12:56am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/39 "2020-07-05T00:56:53Z")
Hey @ThinhDinh I got it from here: [https://support.geckoboard.com/hc/en-us/articles/208314537-Create-a-weather-widget-using-Google-Sheets](https://support.geckoboard.com/hc/en-us/articles/208314537-Create-a-weather-widget-using-Google-Sheets). @Wiz.Wazeer Posted it here. ---
**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:44am UTC](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444/40 "2020-07-05T01:44:42Z")
The line 6 should be “var url…” [Previous page](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444.md?page=1) [Next page](https://community.glideapps.com/t/weather-app-with-just-google-sheet-formula/11444.md?page=3)