You need to set an acceptable member role for the Google Workspace shared drive
Why I see this error?
Google API for Extensions accepts only two Google Workspace roles as editors. You need to set the role of Manager or Contributor for your account or ask the folder owner to do it
1. Open the Google Drive folder with the spreadsheet
2. Click on the Manage members button
3. Set the role as Manager or Contributor
For the user who encountered this error, set the role as Manager or Contributor