Skip to main content
Solved

Google Sheet Unable to Open Spreadsheet


Forum|alt.badge.img+1

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? 

Best answer by Aaron.Gleason

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.

View original
Did this topic help answer your question?

4 replies

Aaron.Gleason
Automation Anywhere Team
Forum|alt.badge.img+10
  • Automation Anywhere Team
  • 502 replies
  • October 2, 2024

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.


Forum|alt.badge.img+1
  • Author
  • Cadet | Tier 2
  • 2 replies
  • October 2, 2024

@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? 


Aaron.Gleason
Automation Anywhere Team
Forum|alt.badge.img+10
  • Automation Anywhere Team
  • 502 replies
  • Answer
  • October 2, 2024

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.


Aaron.Gleason
Automation Anywhere Team
Forum|alt.badge.img+10
  • Automation Anywhere Team
  • 502 replies
  • October 2, 2024

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings