1

I am setting up a node script to interact with a google sheet, all the tutorials I have come across set up a service account with the Editor role, however I only want my service account to read and write to a google sheet so I don't want it to have all the permissions an editor role affords. Does anyone know the specific permissions needed for reading and writing to google sheets?

Nicholas O'Connell
  • 127
  • 1
  • 9
  • What are the permission that you don't want or be protected against? – guillaume blaquiere Jun 13 '22 at 09:40
  • Does this answer your question? https://stackoverflow.com/questions/27067825/how-to-access-google-spreadsheets-with-a-service-account-credentials – someRandomDev Jun 13 '22 at 11:31
  • @guillaumeblaquiere I don't want any of the excess that the general 'Editor' role provides. This is a quote from GCP on the permissions of the Editor role: "View, create, update, and delete most Google Cloud resources. See the list of included permissions." It has a lot of permissions but I only want those needed to reed and write on a google sheet. – Nicholas O'Connell Jun 13 '22 at 11:48
  • Ahhhh. No, the editor role in Cloud IAM, but editor in the sharing option on Google Sheet! – guillaume blaquiere Jun 13 '22 at 15:27

1 Answers1

0

Not possible.

Editor permission grants read and write access, which also allows the file to be deleted.

Commenter access grands only read access.

You have to choose between the two

Rafa Guillermo
  • 14,474
  • 3
  • 18
  • 54