I have written the scripting to download meteorological information from the Spanish Meteorological Agency and load it into BigQuery. Data is transformed to make it easy to use for reporting, calculating distances, and representing it in Google Maps [1] and BigQuery Geo Viz.

You can find this scripting in this GitHub repository, along with the documentation.

[1] Data Studio is a free BI tool that works very well on BigQuery. You can analyse and visualise your geographical data with Google Maps in Data Studio.