Google Suite activity Service account key


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:
Google.GoogleApiException: Google.Apis.Requests.RequestError
The caller does not have permission [403]
Errors [
Message[The caller does not have permission] Location[ - ] Reason[forbidden] Domain[global]

Are you working from inside a larger company?
Cause the server blocks the communication, i believe.
I had a similair problem with google text to speech. The API key keps giving the same issue.
But out servers here block the PULL actions from google.

Kind Regards

Thank you @Joeri_Rethy

Found a workaround. I shared the file with the email generated by the service account key. I thought it was enough to just share the sheet on the regular email address of the google account. I’m very new to google api and know no better. hehe.

Thanks for the reply though. Really appreciate it.


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.