Awesome video! I am using an API key to authenticate and I am stuck at the Caller does not have permission error. Since I did not create a Service Account, who/which email must I share the google sheet with? I am assuming the email address linked to my UiPath Studio? Thanks
Thanks a lot for the feedback! I only used with Service Account until now, if you're getting this error, I would say to use the Service Account as we used, but if you don't want, I think you can try to change you Google Sheets file to public, by this way there shouldn't be any issue about permissions, just make sure there isn't any sensitive data.
Hello Marvin, thanks for the feedback. If you want to maintain the first row values, you can define on the Write Range activity, on the Starting Cell activity, to be the "B1" cell, meaning that will be wrote the data table starting on the second row.
Hey Marcelo would it be possible to run/automate a "=TRANSPOSE(IMPORTHTML(formula" to be copied and pasted across all the rows (21k+) of a column of the Google Spreedsheet? Could you add a delay so the RPA waits for the importhtml formula to load the data then copy and paste and values and then continue with the next row until finish?
Hi Marcelo, when using send gmail activity inside gsuite scope using service account key, "The service gmail has thrown an exception. HttpStatusCode is BadRequest. Precondition check failed." Anny idea? Thanks in advance
I realize that this video is very old. But the quality is very low. It is out of focus, so it's difficult to see what you're doing, and the audio is so low you can barely hear what you're saying.
Hello! On my side the quality and audio sounds good, it might be something related to your internet connection. True the video it's old, but matches pretty much how nowadays it's automated gsheets with service account on UiPath.
I appreciate that you took the time to show the errors that occurred when certain inputs were not put in
Is a pleasure! 🙂
This is the only thing that has worked for me. Thank you so much.
You're welcome Shaon!
I did it successfully. Thanks for your guide
You're welcome!
Provides detailed instructions on how to use Uipath google sheets activity from setting up the GSuite Application Scope.
Thanks a lot.
It's Worked well. Thx for your share~~!! I subscribed and liked~
Thank you :D !
Awesome video! I am using an API key to authenticate and I am stuck at the Caller does not have permission error. Since I did not create a Service Account, who/which email must I share the google sheet with? I am assuming the email address linked to my UiPath Studio? Thanks
Thanks a lot for the feedback! I only used with Service Account until now, if you're getting this error, I would say to use the Service Account as we used, but if you don't want, I think you can try to change you Google Sheets file to public, by this way there shouldn't be any issue about permissions, just make sure there isn't any sensitive data.
hi marcelo. very nice video. how about if you want to input datas on your google sheet without overwriting the 1st row. thank you
Hello Marvin, thanks for the feedback. If you want to maintain the first row values, you can define on the Write Range activity, on the Starting Cell activity, to be the "B1" cell, meaning that will be wrote the data table starting on the second row.
thanks man, realy helpful!
Thanks for posting. Very helpful
You're welcome!
very helpful thank you It works well!
You're welcome!
good work
Thanks for the feedback!
Hey Marcelo would it be possible to run/automate a "=TRANSPOSE(IMPORTHTML(formula" to be copied and pasted across all the rows (21k+) of a column of the Google Spreedsheet? Could you add a delay so the RPA waits for the importhtml formula to load the data then copy and paste and values and then continue with the next row until finish?
Hi Marcelo, when using send gmail activity inside gsuite scope using service account key, "The service gmail has thrown an exception. HttpStatusCode is BadRequest. Precondition check failed." Anny idea? Thanks in advance
I realize that this video is very old. But the quality is very low. It is out of focus, so it's difficult to see what you're doing, and the audio is so low you can barely hear what you're saying.
Hello! On my side the quality and audio sounds good, it might be something related to your internet connection. True the video it's old, but matches pretty much how nowadays it's automated gsheets with service account on UiPath.