00:00In my previous video, I demonstrated how you can web scrape Amazon review.
00:03In this video, I'll demonstrate how you can do sentiment analysis of this review using
00:07ChatGPT.
00:08Let me reorganize my spreadsheet here.
00:10First thing you have to do is install the ChatGPT extension by clicking on extensions,
00:14add-on, add-on, and in the search field here, you're going to type ChatGPT and click on
00:19OpenAI for Sheet and install this extension.
00:22Once this installation is done, you're going to have to install the API by clicking here,
00:25set API.
00:27Click on this hyperlink and get your API.
00:29I already have my API key.
00:31The next thing to do is to use a formula called equalGPT classified sentiment in words followed
00:36by the second argument which is your review, comma, zero, and close parenthesis.
00:41And ChatGPT will do a sentiment analysis for this review.
00:45Let's apply the formula for the rest of the rows.
00:57And how did we do?
Comments