Web Page Monitor using Google Docs
My guest post on monitoring web page changes using google docs is posted in Digital Inspiration – one of the most popular technology blogs. Do read it to learn a little bit about using XPATH, RSS Feeds, Google Spreadsheet import() functions.
Here is a summary of the technique:
- First go to the web page which you are planning to track using spreadsheets
- For each item on the web page that needs to be tracked, findout its XPATH (learn more about XPATH)
- Create a
importXML()formulas for each of this elements in your Google spreadsheets.
- Finally, save the spreadsheet and subscribe to its RSS Feed to keep track of the web page you are aiming to monitor.
If you are looking for a way to access RSS feeds from your Excel sheet, read this.
|Power Outage & 99 Excel Tips to keep you Busy||Calculating Paydays in a calendar year using Excel|