I have started getting this error from today when I do any write operation on my googlesheets... while till a few days back everything was working fine.
> gs4_create()
✔ Creating new Sheet: petalless-spider.
Auto-refreshing stale OAuth token.
Error in `gargle::response_process()`:
! Client error: (403) PERMISSION_DENIED
• Client does not have sufficient permission. This can happen because the OAuth token does not have the
right scopes, the client doesn't have permission, or the API has not been enabled for the client
project.
• Request had insufficient authentication scopes.
Error details:
• reason: ACCESS_TOKEN_SCOPE_INSUFFICIENT
• domain: googleapis.com
• metadata.method: google.apps.sheets.v4.SpreadsheetsService.CreateSpreadsheet
• metadata.service: sheets.googleapis.com
Following is my gs4_oauth_app:
gs4_oauth_app()
<gargle_oauth_client>
name: planar-unity-23xxxxxxx3ae35c6
id: 26xxxxxxx50sk26li1edt07gscl.apps.googleusercontent.com
secret: <REDACTED>
type: installed
redirect_uris: http://localhost
the secrets matches with the downloaded json from google cloud console (screenshot attached):
The only changes I did in last few days is open a new google workspace account. However I am logged into the old gmail account and also confirm the account whenever being prompted by googlesheets4 package.
