Google search console data

Hi

Just a quick question because I’m out of options after a long time of investigation and testing.
Did someone manages to pull data from google search console? they offer an oauth2 way and api key to connect to they API (link) but everytime I get the unauthorized or not found error.

I think as far as I read it, HA does not support oauth2 when using a rest sensor, is this correct?

I also looked at other possible solutions. you can write google search console data to google sheets. I read that HA can only write data there but not retrieve it yet?

If you know of other solutions, I would like to hear them, even if this is a work qround
thanks