Greetings everyone - I work at a skiing operation in the US, and they have asked me to set up a Google sheet that contains rows of daily weather observations (such as temperature, dewpoint, wind direction and speed, barometric pressure, etc. at several weather stations across the state on a daily basis for the rest of this winter.
I have built the spreadsheet, but copying and pasting on a daily basis is tedious. Is it possible to write a script or program within Google Sheets that can go to a suite of websites on a timed, regular basis, read the HTML, scrape the values out of the table, and deposit them into a Google Sheet? I did some research into DataMiner extension for Chrome, and while paying them to write a recipe would work, except they do not offer automation so it wouldn't be much different than cutting and pasting. I should say that I am not a computer programmer, but I have dabbled in C+ and PHP for Arduino programming and website customization, so I am somewhat familiar with very basic level coding, and I'm willing to learn what I need to complete this project. Here are a few of the weather sites I need to gather data from: http://mesowest.utah.edu/cgi-bin/droman/meso_base.cgi?stn=EYKA2&time=GMT http://mesowest.utah.edu/cgi-bin/droman/meso_table_mesowest.cgi?stn=PACV http://mesowest.utah.edu/cgi-bin/droman/meso_table_mesowest.cgi?stn=RHRA2 http://wcc.sc.egov.usda.gov/reportGenerator/view/customSingleStationReport/daily/1055:ak:SNTL/CurrentWY,0/WTEQ::value,SNWD::value,PREC::value,TOBS::value,TMAX::value,TMIN::value,TAVG::value Thanks in advance for any direction/advice. Grant -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
