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.

1. Set Up Google Cloud Credentials:

• Go to the Google Cloud Console.

• Create OAuth credentials.

  

• Obtain the Client ID and Client Secret.

  

2. Set Up GPTs:

• Create a new GPT and a new action.

  

• Add **OAuth Authentication (**paste the Client ID and Client Secret from step 1).

  • Authorization URL: https://accounts.google.com/o/oauth2/auth
  • Token URL: https://oauth2.googleapis.com/token
  • Scope: https://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.

  • google sheet

  

  

  • google drive and google doc

  

  

3. Challenges:

1. The training environment is unstable.
2. Although the format is provided in the instructions, it is often forgotten.