Skip to main content
Question

Google Sheets Sessions and Child Bots

  • March 19, 2026
  • 3 replies
  • 24 views
G

I am using the Community Edition.  I need to use Google Sheets.  I have successfully connected to Google Sheets, opened a sheets, and pulled data.  I am doing this successfully in a child bot (A) (I do not need to access it in the parent). 

In Bot (A), I connect, open, do stuff, close, and disconnect.

However, as soon as I try to go to another child bot (B), it says I already have the session open even though I am using a completely different session name in Bot B (the error says I have session B opened).  Again, in Bot B I am Connecting, Opening, doing stuff, closing, and disconnecting.  

I am not sure how the 2 sessions would be connected.

I have tried alternative methods like connecting and opening in the parent and passing a string with the session name to the children but then it says I don’t have a session open.

How can I do this???

 

3 replies

Aaron.Gleason
Automation Anywhere Team
Forum|alt.badge.img+6
  • Aaron.Gleason
  • Automation Anywhere Team
  • March 20, 2026

​@Gregg 3454 Like this:

https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/cloud-share-session-between-tasks.html

    G
    • Gregg 3454
    • Author
    • Cadet | Tier 2
    • March 20, 2026

    Thank you for the response.  Unfortunately, I am sorry, but I am having difficulty translating that to the Google Sheets package.  Google Sheets package does not seem to have a Shared Session function.  I tried to hand off the session between main and child bot by passing the session name as a string, but that didn’t work either.  I didn’t have much issue with Excel sessions, but there is a specific Excel Session variable type - not true for Google Sheets apparently.  Let me know if I am missing something.

      Aaron.Gleason
      Automation Anywhere Team
      Forum|alt.badge.img+6
      • Aaron.Gleason
      • Automation Anywhere Team
      • March 20, 2026

      ​@Gregg 3454 It does not appear Google Sheets can use a shared session. I might recommend having a single Task Bot for interacting with Google Sheets that other Task Bots can send information to. This could be very inefficient as Google Sheets would have to connect and disconnect for every action.

      If there is a way you can download the file as an Excel and use one of the Excel packages, that would give the best way of sharing sessions.

        Terms & ConditionsCookie settingsAccessibility statement