I believe you are on Google’s Gsuite Business account and in that under security settings with Admin account, can you check if there is OAuth Refresh Token policy set? you can update that policy in order to have this connector working for longer duration.
Do have. a look at below documentation if it is relevant -
I will quickly explain how this Google connector (Or any OAuth based connector) works Under the hood -
- When you connect your oauth account, you get a consent screen where you accept the request and grant permission
- Google in turn provides an access token and refresh token to Us. Access token has shorter duration - typically 30 mins / 60 mins where as refresh token is of larger duration
- Once we get this 2 tokens, we are able to consume Google resources using access token.
- Once the access token expires, we attempt to re-generate access token from google using refresh token. If refresh token is valid, google re-issues access token and refresh token. Now, this access token can be used to consume google resources. However, if refresh token itself gets expired, there is no way to regenerate access token without end user explicitly accept that consent form again,
This is exactly what seems to be happening with your case, so will request you if you can check the admin policies for refresh token duration to be of longer timeframe so that you can use it smoothly.
Also, We do have a Google Sheet connected account which is working fine for more than 2 months now.
Additionally, for re-authenticating, you can simply click on the refresh icon and grant permission without making any change in your app and it will start working.
Hope this Helps!