Google spreadsheet api problem

[Shoebmd]

Hey guys

Iam reading excel file with excel application scope and transfer this data to google spreadsheet through gsuite google api

For sometime i can do it easily whereas the same workflow which is fine is giving errors

Error: spreadsheet or google services unable to find

Please help me in this

[Palaniyappan (Palaniyappan P)]

@Shoebmd

Error: spreadsheet or google services unable to find

Hi

Have a view on this on how to configure and for a sample project that shows how to configure and use the G Suite activitieswith OAuth authentication:

GSuite - Gmail Activity Unauthorized client error

So this come back to the basic question, which Authentication type should we use…OAuthClientID or ServiceAccountKey ? When you use Service Account, then the property AuthenticationType should be set to ServiceAccountKey: https://docs.uipath.com/activities/docs/gsuite-application-scope#section-service-account-key After you set up your Service Account, you’ll be able to download the JSON file that act as the key: Authenticate to Cloud services using client libraries  |  Authentication  |  Goog…

Cheers @Shoebmd

[Shoebmd]

Bro,

I used api key

And oauth client id and client secret i used

This works fine sometime, while sometime the samething giving errors

[Palaniyappan (Palaniyappan P)]

@Shoebmd

For sometime i can do it easily whereas the same workflow which is fine is giving errors

Then place it inside the retry scope activity with no conditions activity used

Have only the activities that connects to gsuite in ACTION block of retry scope activity and mention number of retries as many as you want

Cheers @Shoebmd

[Shoebmd]

Hey guys

Iam able to do this

I have used google service account authentication with gsuite UiPath

UiPath - Upload File to Google Drive using Service Account

This above youtube video helped me