Pipes was way ahead of the curve but is also targeted at a moderately more sophisticated audience than the task triggers IFTTT and Zapier. Pipes focus is more about data collection, filtering and transformation -- like Unix pipes vs cron.

BTW, both Pipes and YQL are powered by the same engine and serve billions of requests per day (for both O&O and 3rd parties).