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

Comments

Popular posts from this blog

Maven Crash Course - Learn Power Query, Power Pivot & DAX in 15 Minutes

"Data Prep & Exploratory Data Analysis" course by Maven Analytics

Oracle Cloud Infrastructure 2024 Generative AI Professional Course & Certification Exam (1Z0-1127-24)