GPT and Power Automate Desktop Advanced Use Case: Sentiment Analysis & Web Scrape
HTML-код
- Опубликовано: 3 июн 2024
- Learn how to analyze sentiment with Microsoft Power Automate Desktop and the Create text with GPT action. This complete and advanced use case shows how to read an Excel sheet with URLs, iterate through them, navigate to Google business reviews, web scrape, and analyze the data with GPT.
👨👩👧👦 Get Power Automate help and network with 10.000+ RPA developers in my FREE Discord community: / discord
📚 LINKS FROM THE VIDEO
- Download the Excel input data: drive.google.com/drive/folder...
📺 VIDEOS FOR YOU
- Copilot in Power Automate Desktop: • 😍 Copilot in Power Aut...
- Advanced Power Automate Desktop: • Power Automate Desktop...
RESOURCES (AFFILIATE LINKS)
👨💻 Learn Power Automate Desktop as a Beginner: • Power Automate Desktop...
🥇 Power Automate Best Practices: • Power Automate Desktop...
📖 Best Power Automate Desktop Book: geni.us/FZQlmt
👨👩👧👦 RPA Developer Community: / discord
👨 PAD Facebook Community: / 754059285247921
💼 PAD LinkedIn Group: / 12566435
📜 PL-500 Microsoft RPA Preparation Guide: • PL-500: Microsoft Powe...
► LinkedIn: / andersjensenorg
► Instagram: / andersjensenorg
► Facebook: / andersjensenorg
► Twitter: / andersjensenorg
► Email Newsletter: andersjensen.org/email-newsle...
⌚ TIMESTAMPS
00:00 Create Text With GPT 1
02:19 Web Automation & Scrape
06:16 CSS Selector Work
09:34 Excel
16:24 Extract Data From Web Page
17:36 Create Text with GPT 2
21:28 Save to Excel
#powerautomatedesktop #powerautomate #powerplatform 
Наука
Want free Power Automate Desktop help?
Then join my community of more than 10.000 RPA developers: ruclips.net/video/xWFz-S96XGo/видео.html It's 100% free and we help each other with solutions and around our careers 😍🙌
This is amazing Anders thank you for sharing this use case.
My pleasure, happy you could use it 😊 Have a great day, Anders
Thanks Anders 😊 for such a informative video from you 💻 waiting for long time from you
My pleasure, Siragam - thanks a lot for such a nice comment 😍
Thank you so much for this will try this
My pleasure, very nice - please let me know your feedback here in the chat 😊
I saw the emoji 😄Thank you for your videos, Sir. They are very helpful for a student like me 😊
Hahaha, I think you're the first 😅 My pleasure, thanks for the nice comment! Kind regards, Anders
Great, great video and so usefull thank you once more time for sharing. Obrigado Anders Jensen.
Thank you so much ❤️ I'm so happy about all your supportive messages, helps me a lot, Anders
Very Helpful video but need complete review scraping with including more... text. It would more helpful and appriciatable. Thank you.
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Thanks Anders🤜🤛..
My pleasure 😊😊
Is this available for all?? I see that this action in cloud flow is only available for US region. Not sure if this action is available for all in power automate desktop...
At the moment, it's available for the US region, yes, but soon everyone will have it. You can create a Trial environment in the Power Platform Admin center if you want to try that. Kind regards, Anders
Hello @Anders Jensen, I want to know how to restrict the edit option in Power Automate Desktop in UAT and Production Machine. Is there any option to allow only the developer to edit the flows? If yes, please help me.
Is there maybe a limitation button for read only ?
@@aytunc13 Thank you for your reply. However, I could not find any documentation that matches my scenario. I would appreciate it if anyone who has already implemented this could help me.
@@PowerAutomateDesktop0322 I don't know. Have you tried the free I Love Automation developer community (the link is in the video description). I'm 100% sure someone knows the answer. Kind regards, Anders
@@aytunc13 Thank you 🙂
Your admin has the right to enable or disable this feature.
Do I need to register a US region Microsoft account?
It's still in preview in EU, so yes, you need to create a preview account 😊
@@andersjensenorg I need to create a new EU/US Microsoft account or just add a new EU environment?
I want solution for extract all reviews including more and ratings, likes, responses etc... in nice table formate, please help me out on this
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Sir, Can you make a automation for Excel copy to google sheets and using append way?? plz plz plz help.. 🤭
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Thanks, but I couldn't find this function on my PAD. I think it is only for paid version.
Hey Ricardo, it's in preview, so either setup a Preview Power Platform environment or wait a couple of months 😊 Kind regards, Anders