Connecting BigQuery API to Bubble API connector Auth

Hi I have been trying to do this all day by asking chatgpt but no luck.

I am trying to connect to BigQuery by using OAUTH 2. Custom Token

ChatGPT says to fill out as I have below

(private key is very long)

The url’s are right as far as I can tell, Idk if the ‘grant-type’ part in the first image is correct though

Has anyone done this before? If so how do you connect to BigQuery

Also I would love to use the SQL database connector but they dont have bigquery yet :frowning: (unless someone knows a way around it)