Document Sentiment And Emotion Analysis with IBM Watson NLU API (Google Sheets Template and Apps Script)

Description

Overview

This Google Sheets template integrates with IBM Watson Natural Language Understanding (NLU) via Google Apps Script to perform Sentiment Analysis and Emotion Analysis directly in your spreadsheet. By tapping into Watson NLU’s robust language processing features, you can quickly interpret the overall sentiment of any text and uncover specific emotional indicators—like joy, anger, sadness, fear, and more—with minimal coding effort.

Features

• Seamless Connection: Easily link Google Sheets and IBM Watson NLU to process text data in real time.
• Automated Analysis: Harness Watson’s powerful algorithms to retrieve both sentiment scores and detailed emotion metrics for each snippet of text.
• Beginner-Friendly Setup: No programming experience required; all relevant steps and scripts come preconfigured for straightforward use.

Use Cases

Here are just some of the ways you can use this template:

• Use the template to analyse social media mentions
• Use the template to analyse customer reviews
• Use the template to review third-party content that mentions your brand
• Use the template to analyze content Tone and Measure how emotionally charged your marketing materials or internal documents are, ensuring they align with your brand’s voice and objectives.

See the related publication in the blog on how to set it up: How to do Sentiment and Emotion Analysis with IBM Watson NLU API in Google Sheets (Apps Script) and Google Colab (Python)