You can, but you're getting outside of the realms of what the nice UI-based point-and-click solutions can support, and you're going to need to start writing some code to be able to do this. I would recommend looking at the following libraries that are designed to build this sort of thing:
You could also look at Microsoft Copilot Studio, which allows you to build connectors to various sources and bring them together.