Pipes was _awesome_. I built many personal services with it - (and even a few low traffic production services!)
Really tragic they killed it, that's when I knew the Mayer era of Yahoo would be nothing more than a hatchet job.
I wish they made it F/OSS as part of the shutdown. Nothing has filled the void.
This one looks promising from an open source alternative that you can host locally: