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.
4 Responses to “Web Page Monitor using Google Docs”
Hi Chandoo,
The site is really interested with focus towards effective selected topics. All the Best.
Regards
Naga
@Naga .. thanks man 🙂
[...] Findout when that iPod is available for cheap. Learn xpath and track almost everything [...]
Hi,
I am trying to link excel and web. But when I go through the steps then I get an error, "File cannot be opened because:Use of default namespace declaration attribute in DTD not supported. Line 4, Position 7.
How can I fix this issue