No Code Web Scrape and Sentiment Analysis with Power Automate Desktop

This video tutorial teaches you how to extract and analyze online reviews without coding using Microsoft Power Automate Desktop. The demonstration uses Google reviews, but the method can be applied to any type of review and comment. You'll see how to analyze sentiments using the 'Create text with GPT' action from Power Automate Desktop, based on OpenAI's ChatGPT-4 model. The tutorial is beginner-friendly and guides you step-by-step through the process, from web scraping to sentiment analysis and exporting results to an Excel sheet.

TOP LEARNINGS:
🔹 How to perform no-code web scraping with Microsoft Power Automate Desktop
🔹 Analyzing sentiments using the 'Create text with GPT' action
🔹 Exporting extraction results and analysis to an Excel sheet

By the end of this video, you can extract online reviews, analyze them for sentiment, and output the results to an Excel sheet using Microsoft Power Automate Desktop. This tutorial is perfect for beginners who want to learn step-by-step.

📚 RESOURCES FROM THE VIDEO

📺 VIDEOS FOR YOU

RESOURCES

⌚ TIMESTAMPS
00:00 Introduction
00:56 Basic sentiment analysis
06:58 Web scraping
11:15 Data Table work
22:11 Save to Excel

#powerautomatedesktop #powerautomate #gpt

[andersjensenorg]

61k subs - thanks for all the support and likes ❤

[leonovgleb]

It was short enough, clear and simple.
Nicely done, thanks for sharing!

[furkansimsek]

Mange tak, Anders. Dine videoer er altid meget brugbare, så fortsæt venligst med at lave videoer om Power Automate og ChatGPT kombinationer :)

[CaioAlmeida-hyhy]

Thanks Anders Jensen, your videos are helping me to improve my skills enormously!
Big hug from Brazil

[beeduky]

Thank you for the great video! May you also guide how to use power automate desktop to highlight all the results when searching certain key word in pdf file. Thanks in advance!

[rnovbeg]

Hey Anders, excellent video and looking to build along. I don't seem to have the 'Create text with GPT' option. Running v.2.45 - Any ideas?

[kamransanaee]

Thanks for the great video - Is it possible to do the same with either "Data table" actions (under variables) or lists?

[andonii]

Nice video! One question though, are you handling pagination when extracting data from google? Or have you just extracted the first reviews? Great work!

[Fedgery]

Good video! I am confused though…is this using ChatGPT?! Is this free? Or is this just all inside of power automate so all this functionality is included with access the power automate?

I’ve been reading about power automate connectors so I’m really confused.

[imranansary]

could you please make a video on Twitter data sentiment analysis

[happy]

hello Anders Jensen Thank you very much for your video Great!