# Building a Weather Forecast Widget/Tab in Glide via Spreadsheets **URL:** \ **Category:** Ask for Help\ **Created:** [November 9, 2019, 2:37am UTC](https://community.glideapps.com/t/building-a-weather-forecast-widget-tab-in-glide-via-spreadsheets/1812 "2019-11-09T02:37:25Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Paul](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paul/32/1345_2.png) [@Paul](https://community.glideapps.com/u/Paul)\ **Post date:** [November 9, 2019, 2:37am UTC](https://community.glideapps.com/t/building-a-weather-forecast-widget-tab-in-glide-via-spreadsheets/1812/1 "2019-11-09T02:37:25Z")
It’s the weekend here in Australia and I’m pondering a clean way to implement an up-to-date weather tab for my app… but thought we could work through it and share for everyone’s future use. Really just a nice to have solution etc. This looks tidy, but ultimately requires a paid API connector (not completely disqualifies) ultimately. > **[Import OpenWeatherMap API Data to Google Sheets \[2023\] | API Connector](https://mixedanalytics.com/knowledge-base/access-open-weather-api-data-in-google-sheets/)** > > In this guide, we’ll walk through how to pull data from the OpenWeatherMap API directly into Google Sheets, using the API Connector add-on for Sheets. We'll first get an API key from OpenWeatherMap… Anyone already gone down this path? Ultimately I’d like to create a weather section that can be either Fahrenheit or Celcius, include some forecast for 3-5 days… flexible on that. Would love to have an interchangeable icon visual too to polish it all up. All doable. Going to start the process, wondering if anyone wants to join me on the ride? 😉 ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [November 9, 2019, 3:35am UTC](https://community.glideapps.com/t/building-a-weather-forecast-widget-tab-in-glide-via-spreadsheets/1812/2 "2019-11-09T03:35:33Z")
If you wanted to include US weather, the gov has a free service at [https://www.weather.gov/documentation/services-web-api](https://www.weather.gov/documentation/services-web-api) . I used that data once when I was writing an Amazon Alexa app. I was kind of reinventing the wheel but learned a bunch while doing it. Getting the weather data for a given lat and long was dead simple returning JSON data that would be easily parsable in Google Script. ---
**Author:** ![anak](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/anak/32/1401_2.png) [@anak](https://community.glideapps.com/u/anak)\ **Post date:** [November 9, 2019, 6:01am UTC](https://community.glideapps.com/t/building-a-weather-forecast-widget-tab-in-glide-via-spreadsheets/1812/3 "2019-11-09T06:01:13Z")
Hey @Paul this is Ana, the creator of API Connector. I’m glad you came across my add-on and article! It looks like this would be a really cool example of an end-to-end, no-code project. I’m a fan of Glide and would love to see this work, so if you’d like, feel free to shoot me a message and I’ll hook you up with a free subscription. @George_B’s suggestion also makes sense (I actually didn’t even know about the service from [weather.gov](http://weather.gov)), and can be done without any add-on at all, so either way looking forward to seeing what you come up with. ---
**Author:** ![Paul](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paul/32/1345_2.png) [@Paul](https://community.glideapps.com/u/Paul)\ **Post date:** [November 9, 2019, 6:21am UTC](https://community.glideapps.com/t/building-a-weather-forecast-widget-tab-in-glide-via-spreadsheets/1812/4 "2019-11-09T06:21:41Z")
Heya cool! Ok then, I’ll go all the way down the path I’d already tested via your nice and tidy article. 😊 Will reach out separately and if I create something that leverages the API at a larger scale than this test case / what I have in mind I’ll certainly make sure to contribute via a paid plan. I’m a firm believer in people getting paid for their time / talents / creations. 👍 ---
**Author:** ![anak](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/anak/32/1401_2.png) [@anak](https://community.glideapps.com/u/anak)\ **Post date:** [November 9, 2019, 7:22am UTC](https://community.glideapps.com/t/building-a-weather-forecast-widget-tab-in-glide-via-spreadsheets/1812/5 "2019-11-09T07:22:21Z")
Sounds good, thank you! Please keep us updated and feel free to reach out with questions. ---
**Author:** ![thebepps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thebepps/32/2956_2.png) [@thebepps](https://community.glideapps.com/u/thebepps)\ **Post date:** [November 9, 2019, 10:33am UTC](https://community.glideapps.com/t/building-a-weather-forecast-widget-tab-in-glide-via-spreadsheets/1812/6 "2019-11-09T10:33:08Z")
Hi Paul, this is the [sheet](https://docs.google.com/spreadsheets/d/1N5oZL-lG7JLZ0KG_Eye0hy57zVq-erqwNdWrQPZowTI/edit?usp=sharing)I was using as a test, you can find a script to get data from OpenWeatherMap. [Glide test app](https://gwtgl.glideapp.io) for 3 hour forecast. Feel free to copy the sheet if you (or anybody) want. ---
**Author:** ![Paul](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paul/32/1345_2.png) [@Paul](https://community.glideapps.com/u/Paul)\ **Post date:** [November 10, 2019, 1:17am UTC](https://community.glideapps.com/t/building-a-weather-forecast-widget-tab-in-glide-via-spreadsheets/1812/7 "2019-11-10T01:17:51Z")
I knew there would be someone ingenious around who’d already tackled it. I’ll dive in. Thx also! 👍 ---
**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:07pm UTC](https://community.glideapps.com/t/building-a-weather-forecast-widget-tab-in-glide-via-spreadsheets/1812/8 "2021-01-29T19:07:35Z")
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:** ![ehdubya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ehdubya/32/24087_2.png) [@ehdubya](https://community.glideapps.com/u/ehdubya)\ **Post date:** [January 29, 2021, 7:11pm UTC](https://community.glideapps.com/t/building-a-weather-forecast-widget-tab-in-glide-via-spreadsheets/1812/9 "2021-01-29T19:11:57Z")
What a cool app/concept! Was your app built using Glide?? ---
**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:** [February 16, 2021, 6:40pm UTC](https://community.glideapps.com/t/building-a-weather-forecast-widget-tab-in-glide-via-spreadsheets/1812/10 "2021-02-16T18:40:07Z")
Thank you so much for the encouragement and yes it was built on Glide! If you’re interested, you can download the app here: [app.fashionforecastapp.com](http://app.fashionforecastapp.com) or You can find it on the app stores under Fashion Forecast! Thank you for your support!