I'm pretty sure that refresh tokens are used with service accounts (the
account has its own authorization so that it can do things, but it does not
have its own storage or documents). Authentication is more involved,
including, for instance, generating a JWT which has to be built and sent to
Googl
Back in 2018 when I was originally working with Google sheets, the OAuth
authorisation once granted seemed to refresh automatically.
That is, if a call returned the 'unauthorised' error, calling OAuth with the
same parameters would briefly display a sheet dialog, but it would go away
automatic