Skip to main content

I’m using the community edition and I’ve set up the authentication for google and the connect action is working, but when I try to open spreadsheet or use any other gsheets actions it throws an error. 

Similar to this post: 

Also is the oauth tab under manange only available to the enterprise edition users? 

Are you using the Connect action from the Google Sheets package? The G-Suite Apps package is deprecated and probably won’t work for you.


@Aaron.Gleason Thanks for your quick reply!

I used the connect action under google sheets action and I’m getting a successful connection. I also tried using the deprecated connect action and even that one seems to work, because it’s creating the oauth file under local. I also tried deleting that file and updating the client id/ secret and still no luck beyond connect action. The actions other than connect are are the ones failing. Like “Open spreadsheet” , “Get Cell value” etc… Any ideas on how to fix this or possible workarounds?

 

Also do you know if the oauth connection tab under manage is only visible to enterprise edition or is there a way an admin can enable that option for me? 


The Google Sheets: Connect action appears to be the same in both Enterprise (left) and CE (right).

I don’t have a Google office account to test this with, but it appears CE and Enterprise have the same level of connectivity. The version of the packages is the same too, so very likely the same packages.

I’m not sure what you mean by connection tab under manage.


Looks like the other thread where you responded might have not been giving the correct ID for the file, per our docs portal:

https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/google-sheets-open-spreadsheet.html


Reply