pipesで擬似的にopmlを利用する方法

現在のところ、opmlをサポートしていないyahoo! pipesgoogle spreadsheetのはき出すrssを利用して擬似的にopmlとして取り込むハック。spreadsheetの一列にフィードurlを書き連ねていき、rsspipesのfetchモジュールに読み込ませればいい。

The RSS generated by the Google Spreadsheet will contain a single item per row, with the content of the cell as the item title. My pipe extracts that title using the For/Replace operator, plugs it into a Fetch URL, and then replaces the spreadsheet item with all the items in the corresponding feed. I added a sort by publication date (which really only matters in an HTML viewer), and voila! You now have a master feed from several different sites without OPML. If you auto-publish changes to your spreadsheet, the resulting master feed will be updated accordingly.

http://techbrew.net/articles/200702/google-spreadsheet-as-pseudo-opml-for-yahoo-pipes/
http://pipes.yahoo.com/pipes/LO6ikKXA2xGwKACE00qv4w/