cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
krish1729
Helper II
Helper II

Trying to scrap review data from multiple websites.

Hello,

 

I need help to create a flow to scrape google reviews in power automate and generate sentiment on google reviews. Need guidance on it. Please kindly request to share your guidance. 

 

If it possible to do it in a custom connector. Please share. 

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Rhiassuring
Super User
Super User

Hi there, 


He shows how to get all the data from this run and previous runs into a single Excel spreadsheet starting around the 1:56 mark in Part 2 of the video. 

https://youtu.be/MitTMo6hdHw?t=100

 

While he still collects the data into another Excel sheet to start with, he then copies it into the single spreadsheet.

 

R

______________________________________________________________


Did this answer your question? Please mark it as the solution.
Did it contribute positively towards finding the final solution? Please give it a thumbs up.

I answer questions on the forum for 2-3 hours every Thursday!



View solution in original post

7 REPLIES 7
Rhiassuring
Super User
Super User

Hi there, 

 

If you're looking to scrape data from sites, you're probably going to want to use Power Automate Desktop, and likely scheduled so you'll need a premium license.

Here's a step by step on that: https://medium.com/geekculture/power-automate-web-scraping-3ed9b513b4ad


For sentiment analysis, then you'll need to use AI Builder. 

 

You can find the costing for the analysis here, you're looking at $500 a month, minimum.

 

https://powerapps.microsoft.com/en-ca/ai-builder-calculator/

 

Here are the step by steps on how to make use of that:

 

https://docs.microsoft.com/en-us/ai-builder/flow-sentiment-analysis

 

Cheers,

Rhia

______________________________________________________________


Did this answer your question? Please mark it as the solution.
Did it contribute positively towards finding the final solution? Please give it a thumbs up.

I answer questions on the forum for 2-3 hours every Thursday!



hello @Rhiassuring 

 

Thank you for your response but I need to fetch dynamic reviews(every day updated reviews).

 

Currently, I am unable to store Extracted data from webpage output in my excel. It creates every time new excel. 

krish1729_0-1653564808404.png

Thanks

Rhiassuring
Super User
Super User

Yes, using the scheduled run will scrape the data every day for you. That is why you need the premium license, to be able to use that feature in Power Automate Desktop.

So is your issue that you want to keep collecting data into the same Excel file? 

 

Try this YouTube walkthrough: 

 

https://www.youtube.com/watch?v=_O9eEotCT0U

 

This is exactly what you are looking to do, so you should be able to follow through step by step. 

If you have more specific questions around each part as you work through it, you may want to try the Power Automate Desktop forum. 

______________________________________________________________


Did this answer your question? Please mark it as the solution.
Did it contribute positively towards finding the final solution? Please give it a thumbs up.

I answer questions on the forum for 2-3 hours every Thursday!



@Rhiassuring  Thanks, for sharing the link. It is useful but does not show how we can insert flow data in a single excel. Still the flow creates every time a new excel sheet. So I am not able to fetch data in single excel. 

Rhiassuring
Super User
Super User

Hi there, 


He shows how to get all the data from this run and previous runs into a single Excel spreadsheet starting around the 1:56 mark in Part 2 of the video. 

https://youtu.be/MitTMo6hdHw?t=100

 

While he still collects the data into another Excel sheet to start with, he then copies it into the single spreadsheet.

 

R

______________________________________________________________


Did this answer your question? Please mark it as the solution.
Did it contribute positively towards finding the final solution? Please give it a thumbs up.

I answer questions on the forum for 2-3 hours every Thursday!



ajpascu-1
New Member

Hello, and you know how can I stract de google star reviews? I try it but in the excel there are estrange symbols, and if its possible I need transform the stars in numbers. Thanks

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,598)