Steps to Create GPT Custom Actions with BigQuery and Google Drive

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...T^T

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).
• Google OAuth Scopes

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.

3. Challenges:

1. The training environment is unstable.
2. Although the format is provided in the instructions, it is often forgotten.
3. Knowledge files are missing.
4. Prompts are overwritten instead of being appended.
5. Prompt rollback issues.
6. Usage issue: If you’re using a shared account, please be aware of this.
7. API limitations from OpenAI.
8. Strange errors: Try restarting your computer = =.