M
M
madfather2020-03-25 10:20:52
Google Sheets
madfather, 2020-03-25 10:20:52

How to make the current temperature outside in a Google Sheets cell?

Good afternoon.

How to make the current temperature outside in a Google Sheets cell?
I'm interested in automatic updating, but I can't figure out where I can get this information from.
It is a number, because many cells will change their data depending on the temperature of the digit in the cell (outside temperature).

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexander Ivanov, 2020-03-25
@oshliaer

The minimum formula for Moscow, for example,

=IMPORTXML(
  "https://www.gismeteo.ru/weather-moscow-4368/";
  "//div[@class='tab-content']//span[contains(@class,'unit_temperature_c')]"
)

A similar question was already considered, then they talked about the history of the weather https://qna.habr.com/answer?answer_id=1535197#answ...
Example of a weather overview for Tables
5e7b4e3729c7e696377001.png
Example of a Table

M
madfather, 2020-04-29
@madfather

Good afternoon.
For reasons unknown to me, today Importxml stopped working with gismeteo, maybe you can tell me how to get weather information from other sites?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question