Import Live Weather Data to Google Sheets - Spreadsheet & API Tutorial

#weather #spreadsheet

[ΣυμεώνΠαπαδόπουλος-λο]

Every time i see new tutorial of you in my notifications i get excited!

[ksardari]

Awesome, I've been waiting for it for almost 6 years, thx a lot

[ДмитрийПаравин]

прекрасный урок по работе с api в google sheets! огромное спасибо от вашего фаната из России :-)

[AdamEfrati]

I have been looking for this specific video in your channel for awhile now, and subscribed with the bell for awhile now, THANK YOU!

[jefferyreber]

This is an incredible tutorial, and exactly what I was looking for. Thank you!

[siddharthjain]

Nice work Sirji. I learned something new today. I really appreciate your work. Keep working like this.

[HaniIbrahim]

i have no code background at all, However i was able to follow along with your explanation and even fetched the "Feels like" and "Humidity" too. Honestly, Thank you

[gregoryunderwood]

Awesome! This is really great!!! Thank you!!!

[richardmhain]

This is very useful script, thanks for sharing...

[peterkeyse]

Thank you for this. A really useful solution and very well explained

[augustomigliori]

this was for me the first WOW result about what I could do with my own hands in coding, and I owe it all to you! What about getting the forecasts? I saw that there are a lot of nested objects

[Lordblanca]

Awesome. Is there a way to get data from multiple locations on the spread sheet

[saysanasb]

Thank you much, but pls how can we add Rainfall also?

[JohnDeir]

Way over my abilities but I learn much by watching...Thanks. Note: I notice that now in my Google Sheets in Tools their is now AppSheet. Would you be doing a tutorial on creating a simple App? I've watched and read up on this but you have a very detailed way of teaching and I'm curious and do need to make a simple phone timesheet app for employees and volunteers where I help at. Again, Great teaching and learning much. Thank You!

[asosat]

Hi, My script has worked until last month, but from June 2021 I did not temp array in JSON it return [object] only, the api works well via browser, I think openweathermap has blocked google sheets for temp arrays . Is there any solution ?

[trcackett]

Very impressive, but not that easy to understand.
Probably one could do implent it by copy/paste.
Wish you will continue with with your great google sheets series.

Greetings from Switzerland
Terence

[sparagnino]

The most interesting info (the real weather) is inside an array. How do I extract that info, like "clody" or "sunny"? :(

[MehdiAbbas]

Wonderfull, I want to make the same thing with Currency Converter, any idea where to start and where to get Data / API?

[maxweber]

Please share this code. I'm facing issue.
Thanks in Advance.

[ColumbcilleDougherty]

Is it possible to get a premade code to copy and paste into our script? Then add our API code?