I am trying to use google suite custom activity but I am having an issue with the Service account key role. I do not know what is the correct role to give to it. I am trying to only access google sheet that is shared with the robot.
I tried the project owner, admin, service account user and viewer with no avail. Does the activity only work if the sheet is owned by the google account that is tied by the robot?
This is the error that I am encountering when I try to read the google sheet that is shared to the robot:
An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:
The caller does not have permission 
Message[The caller does not have permission] Location[ - ] Reason[forbidden] Domain[global]