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?

CodePudding user response：

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