Yahoo Pipes script for retrieving all web pages titles of a google site, dump into Google spreadsheets

Do you have experience with Yahoo Pipes and Google sites? Can you make Yahoo Pipes update a google spreadsheet in realtime? I have a private wiki that has over a thousand pages and is growing every day. I need a Yahoo Pipe custom built that dumps page titles of all the private wiki pages into a google spreadsheet. Preferably the same google spreadsheet. 1. Expert knowledge of google sites, google wikis, google api's 2. Expert knowledge of yahoo pipes 3. Expert knowledge of google spreadsheets, specifically importing data Please note: 1. I want you to develop this not on the actual site but on one I will create for you for testing purposes. 2. I want the pipe to update itself every time I create a page or click "save". Google sites has an option to view revision history so that's the source I want you to focus on. If there's other methods for this, please let me know.