Gsuite scope Authentication opens every run

Help Activities
, ,
1

Hello, I have two gsuite scope but on different xaml files. One is for updating google sheet, and one is for sending email. How can I fix that it will not re prompt every run? Both scope reprompts every run.

2

@ian.palomares

If you are using OAuth, then there is a change of re-prompts for authentication
but you have other option to have a Service Key authentication
for this from your Gsuite you need to generate Service key which is as a json file and that can be used

Hope this may help you

Thanks,
Srini

3

@ian.palomares

Also, you can try the latest package of Gsuite activities where you can create a connection in Integration Service once and the you can use this

Hope this may help you

Thanks,
Srini

4

Hello @ian.palomares

To prevent the GSuite scopes from prompting for authorization every time you run your UiPath process, you can use the “Get Password” activity to store the authorization token for each scope in a secure manner.

Here are the steps you can follow:

  1. Add the “Get Password” activity to each XAML file where you are using the GSuite scopes.
  2. Set the “Password Name” property to a unique name for each scope. For example, “GoogleSheetScopeToken” and “EmailScopeToken”.
  3. In the “Get Password” activity for the Google Sheet scope, set the “Password” property to the output variable of the Google Sheet scope activity. Do the same for the Email scope.
  4. When you run your UiPath process for the first time, you will be prompted to authorize each scope. Once you have authorized the scopes, the authorization token will be stored securely in the Windows Credential Manager on your computer.
  5. On subsequent runs of your UiPath process, the “Get Password” activity will retrieve the authorization token from the Windows Credential Manager, so you will not be prompted to authorize the scopes again.

Regards, hope you got the solution for your Querey.

5

Hi @Srini84 Thanks for this. But our client gave us an OAuth with client secret and ID. Will there be any workaround for that?

6

HI @mkankatala Thank you for this. I’m using OAuth with Client secret and ID. Will this workaround work for this setup?

Also, my client id and secret are stored from windows credential manager already and was retrieved to be stored in config dictionary during the initialize part of the process. My Gsuite scope properties are as follows:

image

7

@ian.palomares

OAuth will have a token expiry, So, it will always prompt to login and authenticate, This is the behaviour of OAuth, I believe there are no such workarounds for this

Thanks,
Srini

8

Hi @Srini84

I’ve tried Serice account key JSON for both GSheets and Gmail. Gsheets worked, but Gmail throws an error

Precondition check failed[400]

9

@ian.palomares

Which activity you are getting issue in Gmail?
Can you share the screenshot?

Thanks,
Srini

10

Hi @mkankatala , what do you mean by this? I can’t see any output to Gsuite scope

11

image

I used the same settings with Gsuite scope for google sheets

12

I’m having the same problem. Can you please explain more thoroughly as to how I should proceed. Currently my authentication type is OAuthClientID. What do you mean by “Passport Name” property, where can I find this, and also the 3rd bullet point can you explain it a bit more? Thanks.

13

Hi @agullina.shllaku

  1. Set the “Password Name” property to a unique name for each scope. For example, “GoogleSheetScopeToken” and “EmailScopeToken”.
    The above point was saying take the unique names for password based on the scope. If password variable is in the Google sheet sequence take the variable name as “GoogleSheetScopeToken”, Then Password variable is in the Email Sequence take the variable name as “EmailScopeToken”.
  2. In the “Get Password” activity for the Google Sheet scope, set the “Password” property to the output variable of the Google Sheet scope activity. Do the same for the Email scope.
    The above point was Get password is an activity which uses to store the password in a variable which the password is stored in the local machine.

Hope you Understand!!