I remember in college, one of our first programming projects was to create a "weather website" (this was before everything was an "app"). The project instructions suggested we use the Yahoo weather API, and it blew my mind that anyone could just make a http GET request and instantly get back some human-and-machine readable data, no scraping required.
An underlying assumption with Yahoo Pipes was that interesting places on the Internet would offer APIs which have a developer UX that matches or exceeds the quality of their official UI. A mixture of unprofitability and abuse lead to this no longer being the case. Tom Scott's essay here: https://www.youtube.com/watch?v=BxV14h0kFs0
It was back in the Web 2.0 days when there were more open data sources and interchangeable data was a priority — RSS/Atom feeds and JSON APIs.
I think that a lot of the "no code" tools we're seeing today are direct descendants of Yahoo Pipes. In addition to the tools others have mentioned that are more directly inspired by Yahoo Pipes, there's also Zapier and other automation services that connect data from different sources.
Edit: My memory has failed me, that would have been "Yoo-hoo"