Hello Anders, How are'y doing? just wanna say thank you for this very helpful tutorial you made, tho I've encountered error along the way. It says: Read Range: Cannot resolve spreadsheet ID and/or Google service. Do you have a resolve or a work around for this? Thanks for your help!
Hey Charles. Kind words, thanks :) Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Very good your video, I managed to integrate my table in uipath, thanks for sharing your knowledge. I'm trying to integrate requests from a FORM into an incident ticket system in HelpDesk.
@@andersjensenorg, I managed to create the integration, thanks to your material that gave part of the integration I needed, I will post a video on my linkedIn thanking you and other professionals who have helped me sharing the knowledge ...
Hey jam05eun. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Hey Jenifer Antony Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
Great video! Thanks! I get this error message. I have selected "Internal" as User Type and should not need to have the app verified. Any idea on how to get around this? "Sign in with Google temporarily disabled for this app This app has not been verified yet by Google in order to use Google Sign In."
Hi Anders your video was very helpful but i encountered an error after running the program a second time.The said error is Google.Apis.Requests.RequestError invalid value [400].
Hi Andres, 1. In properties, services are not available for me, I have tried uninstall and installed the Gsuite package. 2. received error during dropping the find files and folders Activities... Could you please help me on this?
Hey Jenifer Antony Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
Hey Hussein. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 26th of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
hi andres I cant create a set val in find files and folders ountput FeelingLucky it said that " compiler error(s) encountered processing expression. thanks for the help this is Joshua from uipath forum you comment your youtube link
I already figured it out, using Desktop app is the correct option. By the way, could u please share more about UiPath and GSuite? Like using UiPath to reconcile transactions in Google sheets. As well as scenarios for automating ERP by using UiPath. Thanks
@@RalphNgOfficial Hey Ralph, awesome 😊 I can definately do the GSheets part, however regarding the ERP part, I'm working in a company, that sells ERP, so I can only automate in our product, so yes if you can live with that, and no if you want some other specific? Kind regards, Anders
Hey CM Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
hello when i start the studio google prompts me to select an account after i choose this error comes out "The application is blocked This app tried to access sensitive information in your Google account. To protect the account, we have blocked access to this data for the application. "
Hi Anders, I'm getting error in read range Source: Read Range Message: Google.Apis.Requests.RequestError This operation is not supported for this document [400] Errors [ Message[This operation is not supported for this document] Location[ - ] Reason[failedPrecondition] Domain[global] ] Exception Type: Google.GoogleApiException
Hey tejaswi nerella Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
Hey rahul subbiah Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
Hey seetharaman dotsolved Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
Perfect. We use API but then we should authenticate with some other user creds. Genious!
Thanks a ton, Pink 🙌🙂
Its content is perfect twice, once for its didactic and objectivity, and once for the incredibly useful content!
Thank you very much 👍😊 I hope that helped you a little regarding your WinAutomation job.
Thanks a lot for the detailed explanaiton. I like all your UiPath Videos. It's really helpful.
Hey Anoop. Thanks a lot - and your comments help me a lot!! Have a great weekend. Kind regards, Anders
Thank you so much, maseeeh 🙇♂
Thanks a lot, Handoko Halim 🤗 Your feedback helps me immensely. Kind regards, Anders
Hello Anders, How are'y doing? just wanna say thank you for this very helpful tutorial you made, tho I've encountered error along the way. It says: Read Range: Cannot resolve spreadsheet ID and/or Google service.
Do you have a resolve or a work around for this? Thanks for your help!
Hey Charles. Kind words, thanks :) Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Hi Anders,
Would u tell the use of enabling google API
Instead of directly using Gmail from SMTP or POP3.
Sure, I'll come up with a video next week. Kind regards, Anders
Very good your video, I managed to integrate my table in uipath, thanks for sharing your knowledge.
I'm trying to integrate requests from a FORM into an incident ticket system in HelpDesk.
Thank you, Elenito. Did you manage to finalize the project? Kind regards, Anders
@@andersjensenorg, I managed to create the integration, thanks to your material that gave part of the integration I needed, I will post a video on my linkedIn thanking you and other professionals who have helped me sharing the knowledge ...
Hi Anders, do you have tutorial on how to use Sharepoint activities in UiPath?
Hey jam05eun. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Hello Andres, It works Thank you!
I need to append csv file into google sheet... I have tried and got error. Could you please help on this?
Hey Jenifer Antony
Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
Great video! Thanks! I get this error message. I have selected "Internal" as User Type and should not need to have the app verified. Any idea on how to get around this?
"Sign in with Google temporarily disabled for this app
This app has not been verified yet by Google in order to use Google Sign In."
Hey Matti. Many thanks. No, unfortunately not :( Kind regards, Anders
Great video
Hi Anders your video was very helpful but i encountered an error after running the program a second time.The said error is Google.Apis.Requests.RequestError invalid value [400].
Hey Affiq, thank you 🙂 A 400 error is a bad http request, did you change the endpoint/http? Kind regards, Anders
great video
Thanks a lot, Arun :) Kind regards, Anders
Hi Andres, 1. In properties, services are not available for me, I have tried uninstall and installed the Gsuite package. 2. received error during dropping the find files and folders Activities... Could you please help me on this?
Hey Jenifer Antony
Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
Hi Anders, Thanks for the video, But it still blocks me from accesing google sheets it shows me tthe "This app is blocked
" error, any help?
Hey Hussein. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 26th of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Hi Anders, how to use google activities to automate sending emails?
Hey Mr Mavit. We can use IMAP - just remember to enable it in your Gmail 🙂 Kind regards, Anders
hi andres I cant create a set val in find files and folders ountput FeelingLucky
it said that " compiler error(s) encountered processing expression.
thanks for the help this is Joshua from uipath forum you comment your youtube link
Hey joshua, awesome to talk you here as well 😀 Can you paste the exception message? Kind regards, Anders
There is a difference in 3:25, there is no application type for Other. Can I use "Desktop app" instead?
I already figured it out, using Desktop app is the correct option. By the way, could u please share more about UiPath and GSuite? Like using UiPath to reconcile transactions in Google sheets. As well as scenarios for automating ERP by using UiPath. Thanks
@@RalphNgOfficial Hey Ralph, awesome 😊 I can definately do the GSheets part, however regarding the ERP part, I'm working in a company, that sells ERP, so I can only automate in our product, so yes if you can live with that, and no if you want some other specific? Kind regards, Anders
if i want to get all files in a particular folder of drive can you help with something ?
Hey Zaid. Sure. Watch the video, we use the Directory.GetFiles(strYourFolderPath) and then a For Each. Kind regards, Anders
I can only find files and folders created using UiPath. Not able to find existing files or folder. Im using my personal gmail acc. Please help.
Hey CM
Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
hello when i start the studio google prompts me to select an account after i choose this error comes out "The application is blocked
This app tried to access sensitive information in your Google account. To protect the account, we have blocked access to this data for the application. "
Hey John. I really don't know. Can you try to clear cache and restart browser? Kind regards, Anders
I am getting the same error -using google workbook - modern version of gsuite
Hi Anders,
I'm getting error in read range
Source: Read Range
Message: Google.Apis.Requests.RequestError
This operation is not supported for this document [400]
Errors [
Message[This operation is not supported for this document] Location[ - ] Reason[failedPrecondition] Domain[global]
]
Exception Type: Google.GoogleApiException
Hey tejaswi nerella
Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
Hi Whatever i do , when i try retreiving the ID it is empty , Kindly help
Hey rahul subbiah
Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
gmail reading gives " precondition check failed 400 " error. any one faces something ?
Hey seetharaman dotsolved
Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders