Looker: Connecting URLs from a sheet with GA4 to see analytics data?

[obtahir]

I'm trying to create a Looker report displaying views and conversions for a specific list of URLs of my site. I have a spreadsheet with a column of the URLs I need and I'm trying to blend the data by mixing the spreadsheet with GA4. But I've tried using all kinds of join configurations and the result is always "null" for all data from one or the other table, depending on the configuration I use. 

I've been trying to set this up for hours and I'm at my wits' end. Could someone please help? 

I'm basically just trying to use a specific set of URLs as a filter and obtain certain metrics for these URLs only and this seemed to be the most logical approach but I just can't get it to work. 

It'd mean a lot to me if someone could help me figure it out. 

Thank you!