What exact permissions are needed to read and write to Google Sheets for a service account?

Question

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?

Answer 1

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