Gsuite Application

Help
1

Hi guys,

I am trying to make UiPath read a range in a google sheet, which I am not making it capable to do.

The properties of the GSuite Application Scope looks like this:
image

I have also expressed the input range, sheet name & spread sheet ID in the read range.

Can someone please help me in making it work? -the problem might also lie in the GoogleApi’s or Sheets?

The following articles has been used:

2

@Karsten_Bertelsen
Hi Welcome!
Can you please share the error you face while using Read Range.

3

Hi Adheedhan,

Here is the error message:
image

4

Please check on the Spreadsheet ID, you might get this error due to this.

5

@Karsten_Bertelsen did you ever figure this out? I am getting the same Location error.

6

Here is the error I am getting:

error

7

Hi @eonofrey

I checked everything again and made sure that everything was written correctly.

In my case, the Sheet name was not written the correct way.

I hope that this will help you in solving the problem.

8

@Karsten_Bertelsen
Thank you- I was able to sold this by fixing the SheetID as well. I appreciate your help!

1 Like
9

Hey Check out this video. It explains how to use google sheet in detail.

10

I was experiencing the same thing. I had to set the authentication scope.
image