# Daily weather forecast - Created one **URL:** \ **Category:** Project Showcase\ **Created:** [November 10, 2019, 10:58pm UTC](https://community.glideapps.com/t/daily-weather-forecast-created-one/1867 "2019-11-10T22:58:58Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [November 10, 2019, 10:58pm UTC](https://community.glideapps.com/t/daily-weather-forecast-created-one/1867/1 "2019-11-10T22:58:58Z")
Pleased I got a local daily weather forecast into my app. Achieved by some spreadsheet magic and Zapier - looks great! Now onto the next challenge 🙂 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a6621545f2b1cf6f62b48f82a839eb319a74f0ce.jpeg) ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [November 11, 2019, 12:09am UTC](https://community.glideapps.com/t/daily-weather-forecast-created-one/1867/2 "2019-11-11T00:09:18Z")
Can you share the sheet/process used for this? Pretty cool and would help to enhance my Health & Wellness app for my staff. ---
**Author:** ![Carlos\_DeSilva](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos_desilva/32/19965_2.png) [@Carlos\_DeSilva](https://community.glideapps.com/u/Carlos_DeSilva)\ **Post date:** [November 11, 2019, 3:39pm UTC](https://community.glideapps.com/t/daily-weather-forecast-created-one/1867/3 "2019-11-11T15:39:36Z")
Yes, I would love to see how you accomplished this as well. Please share? ---
**Author:** ![Dave\_McManus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dave_mcmanus/32/352_2.png) [@Dave\_McManus](https://community.glideapps.com/u/Dave_McManus)\ **Post date:** [November 11, 2019, 6:20pm UTC](https://community.glideapps.com/t/daily-weather-forecast-created-one/1867/4 "2019-11-11T18:20:12Z")
Great work! I’ve been using this tool to hook into API’s: > **[Parabola - Make your computer work for you.](https://parabola.io/)** > > Hand off your routine data tasks by describing them in Parabola. Build once, reuse infinitely. Sign up for free. ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [November 12, 2019, 7:19am UTC](https://community.glideapps.com/t/daily-weather-forecast-created-one/1867/5 "2019-11-12T07:19:55Z")
Even got it to send me an email when the data has been updated. Pleased 🙂 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/153fa638a862812851111a5eff55304b1df8b885.jpeg) ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [November 12, 2019, 5:35pm UTC](https://community.glideapps.com/t/daily-weather-forecast-created-one/1867/6 "2019-11-12T17:35:05Z")
I figured out the Zapier part of it and getting it connected to my spreadsheet, but how do you get the icon to display? I tried Rick Text and Image and neither worked as component types. ---
**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:** [November 12, 2019, 5:35pm UTC](https://community.glideapps.com/t/daily-weather-forecast-created-one/1867/7 "2019-11-12T17:35:56Z")
Looks like an inline list item to me. ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [November 12, 2019, 5:37pm UTC](https://community.glideapps.com/t/daily-weather-forecast-created-one/1867/8 "2019-11-12T17:37:29Z")
From what I can see, Zapier adds the icon as text into the spreadsheet. I’m not sure how @Rosewebstudio was able to get the icon to display as an image (unless a lookup is done for each possibility, but I doubt it since Zapier provides the icons and there’s likely a way to get them to display properly). ---
**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:** [November 12, 2019, 5:40pm UTC](https://community.glideapps.com/t/daily-weather-forecast-created-one/1867/9 "2019-11-12T17:40:15Z")
When you say text, do you mean an image URL, or just text like cloudy, raining, sunny, etc.? ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [November 12, 2019, 5:42pm UTC](https://community.glideapps.com/t/daily-weather-forecast-created-one/1867/10 "2019-11-12T17:42:13Z")
Just text, but it’s green… which may mean something that I’m not aware of in Sheets. Column 4 is the “icon” for “Today’s forecast” from Zapier. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/3da3adb40937943192c78f213ef5f7e51f50f1e3.png) ---
**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:** [November 12, 2019, 6:10pm UTC](https://community.glideapps.com/t/daily-weather-forecast-created-one/1867/11 "2019-11-12T18:10:56Z")
Not sure about the green unless Zapier is doing some don’t formatting on their end, but I would assume that you use it as as lookup value to a set of images you already have set up on another sheet. Just throwing out guesses. I haven’t actually tried it. ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [November 12, 2019, 6:13pm UTC](https://community.glideapps.com/t/daily-weather-forecast-created-one/1867/12 "2019-11-12T18:13:29Z")
Yeah that’s what I was thinking too, but the fact that Zapier is meant to be this automation machine that’s so great, it seems like that process should be handled by their “icon” field automatically (ideally it should just point to a URL for the image). Hopefully @Rosewebstudio can confirm if they used a Lookup to get the image. ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [November 12, 2019, 7:10pm UTC](https://community.glideapps.com/t/daily-weather-forecast-created-one/1867/13 "2019-11-12T19:10:44Z")
Created and used a look up ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a3baf065d95ddadaf25191fcbd8fecb587d26d84.jpeg) ---
**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:02pm UTC](https://community.glideapps.com/t/daily-weather-forecast-created-one/1867/14 "2021-01-29T19:02:38Z")
I would appreciate if you all would unlike 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)