Google Sheets - user cannot configure "Shared with me" sheets from UiPath Assistant

Help Assistant
,
1

I have built an automation to read a Google Sheet and paste into a local Excel file. The Google sheet is shared with me.

In Studio in the Google Workspace Read Range activity, I am able to browse to a “Shared with me” folder and find the correct sheet. I can run the automation from Studio with no issue.

But when I publish and run from UiPath Assistant, I have to set up a connection to Google Sheets. When I configure the connection, I am only able to browse to the “My Drive” folder, I cannot browse to “Shared with me”, so I cannot select the spreadsheet I need.

How can I configure the connection from UiPath Assistant to read the “Shared with me” files?

image

image
image403×856 78.1 KB

image
image841×709 71.5 KB

2

@KevinE

Did you happen to select the connection and sheet in the process creation page of orchestrator?

Even there you are unable to?

Cheers

3

I have left it as Configurable by users. The Google Sheet is private and it is only shared with certain users, so each user should have to create their own connection with their own Google login.

Is that the correct way of doing it?

image
image1171×512 30.5 KB

4

@KevinE

Perform two tests to know the issue

  1. Change the package version and see if you are able to see the shared
  2. Try to configure from orchestrator only instead of configurable by users to check if its the issue with assitant

The way you configured looks correct

Cheers

5

Setting up the process in Orchestrator I also cannot see the shared folders

image
image1171×839 41.7 KB

I downgraded the Google Workspace from package 2.4.3 to 2.3.4. Same issue - I can see the Shared folder in Studio, but not in Assistant or Orchestrator. I also tried using both the current Google Workspace and Workspace - Classic.

image

6

For anyone who comes across the same issue, I have still not solved the issue of the “Shared with me” folder not appearing in Assistant.

As a workaround, in Studio, in the Google ReadRange activity Spreadsheet field, I have changed the option to use Url or Id. Now, when the user launches the process from Assistant, they are only prompted to select a Google connection, they are not prompted to select a file. The process runs completely so this workaround is sufficient for us.

image
image