Answer the question
In order to leave comments, you need to log in
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
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')]"
)
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question