"A series of videos on web crawling and scraping using RapidMiner, and GDocs"

el_chief

Part 1 begins here, with google spreadsheets and xpath:

http://vancouverdata.blogspot.com/2011/02/how-to-web-scraping-xpath-html-google.html