Grant, One thought is that you might be able to use the function 'importHTML' in a Google Spreadsheet ... but this doesn't always work...
I wanted to scrape some data from a web site recently and ended up going to www.fiverr.com ad found someone who could write PHP code to abstract the dat I needed and he set up a 'cronjob' to run the code at set intervals. Hope that helps! Allan Allan Thompson On 21 January 2016 at 11:17, <[email protected]> wrote: > [email protected] > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email#!forum/google-spreadsheets-api/topics> > Google > Groups > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email/#!overview> > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email/#!overview> > Topic digest > View all topics > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email#!forum/google-spreadsheets-api/topics> > > - Automated Gathering of Weather Info into a Google Sheet > <#-1836180042_group_thread_0> - 1 Update > > Automated Gathering of Weather Info into a Google Sheet > <http://groups.google.com/group/google-spreadsheets-api/t/dbbe03f94c83f953?utm_source=digest&utm_medium=email> > Grant Kaye <[email protected]>: Jan 21 07:33AM -0800 > > 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 > Back to top <#-1836180042_digest_top> > You received this digest because you're subscribed to updates for this > group. You can change your settings on the group membership page > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email#!forum/google-spreadsheets-api/join> > . > To unsubscribe from this group and stop receiving emails from it send an > email to [email protected]. > -- 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.
