Trouble with Integration Service and Google Sheets Connector

[kevinpscott (Kevin Scott)]

For a long time I have been operating with the legacy method of interacting with Gsuite, which was using a Gsuite Application Scope, passing credentials and doing the operations there. This process is working 100% fine for me.

We now have access to the Integration Service Connectors, so I thought I’d modernize my processes to take advantage of this new feature.

The error I’m receiving is:

Authentication attempt took longer than 90 seconds to complete, and was cancelled

I have seen this message or very similar messages in other threads, but those were not using the integration service, so I’m starting this thread.

I recreated the connections today in an attempt to solve the problem, but that didn’t fix it.

When I try to access the connections from my Development machine, everything works fine, but when I run it from my unattended robot, it fails with the error message I mentioned.

I am using the Community Edition of Studio (2024.2.1) with the following packages:

Here is the activity that is throwing the error:

Do I need to add an OAuth Client ID and ClientSecret? If so, what’s the point of the integration service? I don’t think this is the case because the activity works fine on one machine, but not on the other.

[kevinpscott (Kevin Scott)]

DUH, I see it now. Leaving the thread up for others to benefit from in the future.