00:00If you need to extract Amazon review into Google Sheets so they can perform
00:03sentiment analysis later, this is how you can do it. First click on extension, add-on,
00:07get add-on. Over here you're gonna click on the search icon and look for import
00:12from web. Click on this guy here and install this extension here. I already
00:16installed mine. I'm gonna close this here. Next you're gonna have to get the URL of
00:19the product. I'm gonna go to Amazon here and if you scroll all the way down and
00:23scroll up a bit, you can see see all reviews. Click on it and copy the URL for
00:29that product and paste it in A2 and if you go to B2 and say equal and you say
00:34import from web and then the first argument will be a URL and the second
00:40argument will be a selector. Select review underscore rating review underscore title
00:45review underscore body and then close parenthesis and hit enter and this is
00:50how I get your review rating title and body
Comments