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.
Do you want to be awesome in Excel?
Here is a smart way to become awesome in Excel. Just signup for my Excel newsletter. Every week you will receive an Excel tip, tutorial, template or example delivered to your inbox. What more, as a joining bonus, I am giving away a 25 page eBook containing 95 Excel tips & tricks. Please sign-up below:
Your email address is safe with us. Our policies
More awesome tips for you:
Leave a Reply
|Power Outage & 99 Excel Tips to keep you Busy||Calculating Paydays in a calendar year using Excel|