Hi Guys, I have installed the Gsuite and GoogleSheet packages, got my keypath and read over the following link many times.
The link is great but when I run my workflow it comes back with “Google sheet application scope: Cannot find the requested object”
I’m using the service account that’s linked to my main email (where the sheet is) and the string listed under “service account keys” at console.developers.google.com for my password in the Google sheet application scope.
I have tried the url from the google sheet page, a shareable link and the name of the sheet in the “input” of my google application scope but it still won’t find the google sheet.
The file i’m using for my KeyPath is a .json but i’ve also heard of P12. but I have no idea on which one I would need or how to change it.
I just don’t know what i’m doing wrong or what else to try. Any help would be very much appreciated.