How to filter using values from big querry?

[LukaDaks]

Hello, 

we are trying to build a report in Looker Studio that would include a table with keyword statistics pulled from Search Console. We want to filter these keywords to only specific ones.

A note: Our report is dynamic - so multiple clients can use the same Looker studio report. But the data is filtered by their emails that are stored in Bigquerry. They can only select the Search Console, they have access to.

What we want to know is there a way to filter using the data from Big Querry? We would connect the selected keywords to the emails of the clients in big querry. So each client would only see the performance of their keywords in the Data Studio report.

Thank you!