Credentials for Google Sheets connector

Hi Varian ,

The situation you mentioned does exist. This is a known issue, ICM is 274490819. While doing OAuth2 authentication, GoogleSheets connector was not receiving refresh token due to which once Access token expires(after one hour), there is no way for for GoogleSheets report to refresh and get new access token. This makes report fail after one hour. I will follow up on this issue in this post.

Also, based on my testing, you can currently try the Web connector to connect Google Sheets, please refer to https://www.youtube.com/watch?v=Z9V221eNbi0. 

Then use standard gateway to connect to the data source and it will not have invalid credentials as frequently as the google sheet connector.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.