Analyzing Reviews using Google Sheets and Cloud Natural Language API:
You have definitely heard about Sentiment Analysis over the last few years, here is a real world example of analysis of user feedback on website comments to look at the the positives and negatives from customers.
You have definitely heard about Sentiment Analysis over the last few years, here is a real world example of analysis of user feedback on website comments to look at the the positives and negatives from customers.
In this tutorial, we shall look at how you can analyze reviews saved in Google Sheets and use a combination of Apps Script, Cloud Functions and Google Cloud Natural Language API to analyze the sentiments and indicate the results in the Google Sheet itself.
There is a lot to cover over here but first up, let’s see what we plan to create by the end of this tutorial.
The first row indicates the columns (attributes) for each review. We have an id, the user who submitted the review, the date time that the review was submitted, the review text and finally the last column sentiment that we are going to calculate.
Shown below is the same Google Sheet with a custom menu option added to analyze the sentiment across each record.
Comments
Post a Comment