HOW TO copy values from one sheet in a specified Google Spreadsheet & archive into another sheet
Google App Script is to Google products what Office Macros are to the Microsoft Office suite. I'm a fan of the ImportXML function that can used within Google Spreadsheet to scrape values from a web page given a URL and a XPath query representing a HTML segment to extract.
Now if you wish to maintain historical values, you'd have to archive the values dynamically fetched by ImportXML function each day. This process can be automated by setting up a trigger for a script to copy values between sheets of a Google Spreadsheet within the Google App Script editor to run at any interval that you can choose.
This snippet from a StackOverflow answer accomplishes that.
Also see: HOW TO prevent screen scraping
Now if you wish to maintain historical values, you'd have to archive the values dynamically fetched by ImportXML function each day. This process can be automated by setting up a trigger for a script to copy values between sheets of a Google Spreadsheet within the Google App Script editor to run at any interval that you can choose.
This snippet from a StackOverflow answer accomplishes that.
Also see: HOW TO prevent screen scraping
Comments
Post a Comment