Through this website a water supply company called Aysa provides information on different meteorological variables in different areas of Buenos Aires. There are data from the last day but the historical data is lost, using a simple script I store this data and update this spreadsheet every hour in order to generate an extensive public dataset of the meteorological data of Buenos Aires.

Access to the public dataset: here

Provided variables

• Wind speed (km / h)
• Temperature (ºC)
• Wind Speed (gust) (km / h)
• Pressure (hPa)
• River level (m)
• Daily Accumulated Rain (mm)
• Humidity (%)
• Wind Direction (°)

Technical details

This program works from a simple Google Sheet spreadsheet to which a Script Editor with Google App Script was configured to run this script and a trigger was set to execute the update_google_sheet (function) every hour. )