I am beginner of uiPath, Please can someone help me with 1 sample how to use google spreadsheet and extract data from it. I am having tough time in understanding with the theory part.
Welcome! Please refer the G Suite activity from UiPath Go!:
Description from the above link:
Set of activities to interact with Google Drive, Sheets, and Gmail
Supercharge your productivity with a robot that can collaborate on spreadsheets, access stored files, and read emails all within Google Cloud.
This activity set has 16 components:
- Find Files and Folders
- Copy File
- Move File
- Create Folder
- Get Mail Messages
- Send Mail Messages
- Create New SpreadSheet
- Add New Sheet
- Get Sheets
- Read Cell
- Read Column
- Read Row
- Read Range
- Write Cell
- Write Range
- GSuite Application Scope (API Key, Service Account, OAuth)
Thanks & Regards,
Please can you give a demo of using activity as I don’t know how to use those activity, It would be thankful with 1 sample, as I am a slow learner
Thank you. @Dominic
Have you solved this ans?
Yes I have.
can you please upload the steps ?
or workflow file ?
can you share the demo project based on google sheets
Hello can you please share the .xml?
I am struggling to send Email using G Suite activity.
Please let me know the error message\issue that you are facing currently.
What error does it prompt?
Have you followed the steps mentioned in the link below: https://activities.uipath.com/docs/about-google-gsuite-activities and https://activities.uipath.com/docs/gsuite-send-mail-messages
HI Dominic, I followed the same, it’s working for OAuth, but when I try to do with API key i am getting error.PFA. But I could see the Request counts in Gcloud, on creating new sheet it is giving error.
I am getting following error message:
Source: Send Mail Message
Message: Upload failed after 0 bytes. Error:“unauthorized_client”, Description:“Client is unauthorized to retrieve access tokens using this method, or client not authorized for any of the scopes requested.”, Uri:""
Exception Type: System.ApplicationException
An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:
System.ApplicationException: Upload failed after 0 bytes. Error:“unauthorized_client”, Description:“Client is unauthorized to retrieve access tokens using this method, or client not authorized for any of the scopes requested.”, Uri:""
— End of stack trace from previous location where exception was thrown —
at UiPath.GSuite.Activities.AsyncTaskCodeActivityImplementation.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at UiPath.GSuite.Activities.AsyncTaskCodeActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
Hi there! I’m having the same issue. Could you solve this?
Hi, Looks like i’m upto where you were when you posted. could you please post how you worked it out? 3 of us on the post still looking for the solution
@A669070, @tinchow, @Ryan_Madden
The answer is simple, you need to generate Clicent ID and client sceret ID from this link https://console.developers.google.com/apis/dashboard?project=skilled-circle-248207, you need to enable spreadsheet, or drive or gmail if you need, after enabling it, you will get Clicent ID and client sceret ID from it, and use that IDs in Gsuite scope.
Cheers got it going now