Help Needed - How to extract number of Star Rating in Google Maps Reviews?

Been searching on the UiPath forum, Youtube, & Google but haven’t seen a solid solution for my problem. If it’s a single target review, it is doable using the Get Attribute or Get Text CV Activities (Getting star ratings from a website - #12 by zahpat) but my use case is pulling all reviews from a specified period, let say a month, into a table; to be transformed/processed in Excel. Unfortunately, the “Stars” are all extracted, using Table Extraction, as special character so I can’t accurately capture the rating.

Badly need the community’s aid… Thanks in advance!

@Lloyd_B,

Are you looking for all the reviews of a single place right?

Yes, so ideally, Table Extraction is the perfect solution as it pulls all similar elements targeted, unfortunately except for one crucial information–the number/count of Stars in the rating.

@Lloyd_B,

Table Extraction will not give you the Star rating as we expect and we can’t specify it in Table extraction wizard also.

Use For Each Ui Element for this to get each field you are looking for.

2 Likes

hmmm… this is interesting. I’ll tinker with this. Thanks for the tip @ashokkarale !

1 Like

Hi, @ashokkarale ,

This is the farthest I can get. This is able to capture & return the count of Stars but the main issue is that it doesn’t seem to loop through each of the reviews. No sure what I’m missing here.

It’s because the the reviews get’s loaded once we scroll at bottom like pagination.

Use Mouse Scroll activity to keep scrolling 4-5 distance and extract the last review and check if the previously captured review is same as current last review. This means all reviews are captured, else bot will keep scrolling capturing the reviews.

I already have that actually, just cropped what I sent previously. Had the Mouse Scroll with Distance as type for the Table Extraction activity

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.