[Google Sheets] Connector failing with "Error reading entity from input stream"

Edit on GitHub

Suguna Fivetranner

Question

Connector is failing on the following error and throwing a reconnect task on Fivetran dashboard

 Error reading entity from input stream.

How can this be resolved?

Google Sheets connector

Authorize the connector using Service Account method.

Google has a limit of 50 refresh tokens per Google Account per OAuth 2.0 client ID.