Cross referencing one board from another

I’ve been reading through and not finding any solutions for this so far.
I’m adding leads to a deals board. I wanted to find a way to cross reference this lead against an existing client list on a different board.

Is there a way to create an automation on one board that runs a simple query for information from another board?

Use the Mirror column

Have you used this as a solution within an automation?