Recently, I helped build GPTs to assist colleagues in quickly gaining insights into daily operations. Here’s a record of the process and the pitfalls encountered.
Go to the Google Cloud Console.
Create OAuth credentials.

Obtain the Client ID and Client Secret.

Create a new GPT and a new action.

Add **OAuth Authentication (**paste the Client ID and Client Secret from step 1).
https://accounts.google.com/o/oauth2/authhttps://oauth2.googleapis.com/tokenhttps://www.googleapis.com/auth/bigquery (For additional scopes, refer to Google OAuth Scopes).
Enter the OpenAPI Schema (ActionGPT can help to generate it).


Paste the Callback URL into the Credentials.


Test API.



