Google OAuth Issues with tools

[mattlindsey]

Google OAuth authentication is working fine for me to create an account and log in, but I've had several issues getting the Google Email and Tasks tools working.
This is not urgent, but I'll list the issues here in case there are suggestions on how to resolve them.

• I was unable to delete credentials as suggested in the UI without going to the rails console (after having deleted the connections at myaccount.google.com) and doing GmailCredential.delete and GmailTasksCredential.delete, which then re-enables the buttons. There should be a 'Remove' button, shouldn't there? Otherwise there is no way to re-add the app permissions at myaccount.google.com.
  And even after deleting the connections at myaccount.google.com and the credentials in the database several times I could still not get the tools to work (see next issue).
• I believe OAuth is configured correctly on the Google console and permissions are granted at myaccount.google.com, but I still get errors such as An unexpected error occurred (Missing permissions. Tell the user to: Add your Google Tasks permissions again in your account settings.. I have gotten less helpful errors too (such as 'credentials variable undefined', especially when not using OAutho to log in), so maybe some better logging can be added to the rails log?

worker   | ### Calling tools
worker   | [ActiveJob] [GetNextAIMessageJob] [bfec9ab9-87da-4650-86f6-d2a15873b01c] ## Handled error calling tools: Missing permissions. Tell the user to: Add your Gmail permissions again in your account settings.
worker   | [ActiveJob] [GetNextAIMessageJob] [bfec9ab9-87da-4650-86f6-d2a15873b01c] /Users/mattlindsey/github/hostedgpt/app/services/toolbox/google_app.rb:13:in `block in refresh_token_if_needed'
worker   | <internal:numeric>:237:in `times'
worker   | /Users/mattlindsey/github/hostedgpt/app/services/toolbox/google_app.rb:9:in `refresh_token_if_needed'
worker   | /Users/mattlindsey/github/hostedgpt/app/services/toolbox/gmail.rb:82:in `create_draft'
worker   | /Users/mattlindsey/github/hostedgpt/app/services/toolbox/gmail.rb:16:in `email_myself'

[krschacht]

Hmm, dang, this Google auth stuff has been tricky. We probably should add a remove button. Originally, the way I wrote it was that if an API call was ever made which received certain error code responses from google then the authentication (or maybe it’s the credential) would be instantly deactivated. So it was supposed to “self correct” in this way if you disconnected it on the google side. However, I too have gotten it into a state once or twice where I had to go into console and manually delete it. It’s probably worth us just having a remove button, as you suggest.

Regarding the unexpected error with Google Tasks, what about Gmail? If Gmail is working for you (it can send emails for you) then I have a hunch as to what’s wrong with Google Tasks. I have my Google Task list set up in a specific way and since this whole thing was pretty experimental I made it assume that certain lists would exist. So if Gmail is working for you and this is only an error with Google Tasks, then that’s my hunch. I can document my set up. But note that there are some annoying limitations with the Google Tasks API that I could not work around (and google support acknowledged the limitations exist). I’m convinced that Zapier has access to an undocumented Google Tasks API which they won’t give me access to and that’s why it can do more than I was able to.

Anyway, let me know about Gmail.

[mattlindsey]

These Google tools look like a cool feature, so I hope I get them working. I think everything is set up correctly, so it's hard to figure out why it's not working. Gmail now gives the error message below about undefined method reauthenticate_credential for module Google which I was getting earlier but I thought had gone away. Notice that the error message in my last comment above is for the Gmail tool also but from yesterday. I think Google Tasks gives the same error.

worker   | ### Calling tools
worker   | [ActiveJob] [GetNextAIMessageJob] [abbbbc58-bc1f-47ee-a62a-fa69e08c1482] ## Handled error calling tools: undefined method `reauthenticate_credential' for module Google
worker   | [ActiveJob] [GetNextAIMessageJob] [abbbbc58-bc1f-47ee-a62a-fa69e08c1482] /Users/mattlindsey/github/hostedgpt/app/services/toolbox/google_app.rb:22:in `refresh_token!'
worker   | /Users/mattlindsey/github/hostedgpt/app/services/toolbox/google_app.rb:16:in `block in refresh_token_if_needed'
worker   | <internal:numeric>:237:in `times'
worker   | /Users/mattlindsey/github/hostedgpt/app/services/toolbox/google_app.rb:9:in `refresh_token_if_needed'
worker   | /Users/mattlindsey/github/hostedgpt/app/services/toolbox/gmail.rb:82:in `create_draft'
worker   | /Users/mattlindsey/github/hostedgpt/app/services/toolbox/gmail.rb:16:in `email_myself'
worker   | /Users/mattlindsey/github/hostedgpt/app/services/toolbox.rb:29:in `public_send'

Actually I just re-enabled Google Tasks tool and it give this Missing permissions error:

] [GetNextAIMessageJob] [297ead53-3c9c-43ba-88e7-65ba3ecdf19f] ## Handled error calling tools: Missing permissions. Tell the user to: Add your Google Tasks permissions again in your account settings.
worker   | [ActiveJob] [GetNextAIMessageJob] [297ead53-3c9c-43ba-88e7-65ba3ecdf19f] /Users/mattlindsey/github/hostedgpt/app/services/toolbox/google_app.rb:13:in `block in refresh_token_if_needed'
worker   | <internal:numeric>:237:in `times'
worker   | /Users/mattlindsey/github/hostedgpt/app/services/toolbox/google_app.rb:9:in `refresh_token_if_needed'
worker   | /Users/mattlindsey/github/hostedgpt/app/services/toolbox/google_tasks/api_helpers.rb:9:in `get_lists'
worker   | /Users/mattlindsey/github/hostedgpt/app/services/toolbox/google_tasks.rb:43:in `create_task_on_list'